Latest Blog Posts

How to Select Row in Excel (9 Simple Ways)

Microsoft Excel is vastly used to organise data and represent them in a better way. While working with it, we often face the necessity of selecting a ...

Calculate Percentage with Criteria in Excel (2 Useful Examples)

In this Excel tutorial, you will learn 2 useful examples of calculating percentage with criteria. We will discuss how to use the IF function to ...

Excel Picture Format: A Complete Guide

In this article, we are going to explore how we can use Excel picture format feature to correct, resize, color, create an artistic style, make ...

Excel ENGINEERING Functions (50++ Functions)

Excel Engineering Functions are the 54 Excel functions that are most preferably used in engineering applications. Engineers may find these Excel ...

Excel Floating Cells (Create and Remove)

We'll talk about different methods to give the spreadsheet a floating effect as we explore the idea of floating cells in Excel. Excel does not have a ...

Heatmap in Excel (Static, Dynamic and Geographic)

In this article, you will learn how to create Heatmap in Excel. Here, we will explain static and dynamic heat maps, we will also learn about ...

Excel String Functions [Basics + Practical Example of 17 Functions]

In this article, we will explain 17 Excel string functions with all sorts of examples of every single function. Download Practice Workbook ...

Excel Date Functions: A Complete Guide

In this article, we'll take you on a journey through the diverse range of powerful Excel date functions. From simple functions like DATE, TODAY, and ...

Network Diagram in Excel (Creation Process)

In this article, you will learn how to create a network diagram in Excel. This covers the fundamental network diagram as well as the project network ...

How to Use Timeline in Excel? (A Visual Presentation)

In this Excel tutorial, you will learn how to -Create a timeline using a template. -Use Excel's built-in Scatter chart, SmartArt and PivotChart ...

Flowchart in Excel (Different Types Explained Workflow)

In this article, you will learn about how to create different types of flowchart in Excel. Here, you will know how to create a basic and simple ...

Drawing in Excel (Basics & Application)

In this article, you will learn about drawing in Excel. More specifically, you will learn about the basics, drawing flow charts, and free-form ...

Insert Shape in Excel (2 Easy Methods)

In this article, we'll learn how to insert shape in Excel. Understanding how to work with shapes can significantly elevate your Excel skills. We ...

Conditional Average in Excel (Complete Guide)

In this Excel tutorial, we will learn how to calculate conditional average in Excel. We can use the AVERAGEIF or AVERAGEIFS function for this ...

Excel Data Mining (All Things You Need to Know)

In this tutorial, we will demonstrate data mining Excel example. Further, we will explore examples to prepare data before data mining in Excel. You ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo