Excel Basics

How to Create a Risk Heat Map in Excel (3 Easy Methods)

Method 1 - Applying Conditional Formatting to Create a Risk Heat Map in Excel We have a dataset showing math, chemistry, and physics scores. We are ...

How to Separate Date and Time in Excel without a Formula – 3 Methods

This is an overview: The sample dataset contains date and time in the same cell. Method 1 - Using the Text to Columns Wizard to ...

How to Make Geographic Heat Map in Excel (2 Easy Ways)

  Method 1 - Using Built-in Maps Chart to Make Geographic Heat Map in Excel   Case 1.1 Creating Heat Map of States For a demonstration ...

How to Recover Previous Version of Excel File (4 Easy Ways)

We'll use a simple dataset to show how to recover a previous version of a file. The name of the workbook is Recover Previous Version of Excel ...

How to Show Ribbon in Excel (5 Quick & Simple Ways)

This article illustrates 5 easy ways to show the ribbon in Excel. You may accidentally hide the ribbon in Excel. If you are wondering about how to ...

How to Show Toolbar in Excel: 4 Simple Ways

Method 1 - Show Toolbar Using Control Buttons Steps: The ribbon menu toolbar on a given Excel sheet is hidden at the moment. That means there ...

Is There Any Way to Increase the Excel Row Limit?

Each workbook in Excel has a limit on the number of rows and columns of data it allows. Tip: Hold the CTRL+Down Arrow key simultaneously to ...

How to Fill Blank Cells with Color in Excel – 5 Methods

This is the sample dataset. There are several blank cells in the dataset. Method 1 - Using the Go to Special Command to Fill Blank ...

How to Fill Blank Cells in Excel with ‘Go To Special’ (3 Examples)

  Method 1 – Filling in Blank Cells with Previous Cell Values Steps: Select the entire range where you have blank cells. Go to ...

How to Fill Blank Cells with Value from Left in Excel (4 Suitable Ways)

At times, you can work in a dataset that has empty cells and you need to take the exact value from the left cell. In that case, you can do it ...

How to Add Strikethrough in Excel Toolbar (3 Easy Ways)

Strikethrough is a special character. It is mainly used to format the cells. When a person applies the strikethrough on any cell, a line appears ...

How to Remove a Formula When Filtered in Excel (3 Ways)

  Method 1 - Use the Delete Button to Remove a Filtered Formula with Values in Excel STEPS: Select the whole data range B4:E12. Go to ...

How to Fill Blank Cells with N/A in Excel – 3 Easy Methods

Method 1 - Using the Go To Special Command to Fill Blank Cells with N/A The following dataset showcases blank cells in the Sales column. ...

Advantages of Sorting Data in Excel (All Features Included)

Excel data sorting allows users to sort data according to their requirements. Data can be sorted in a variety of ways, including alphabetical order, ...

How to Convert Word Picture to Excel Table

In day-to-day life, we often need cross-use data from different applications. Data fetching or importing from Microsoft Word to Excel or vice versa ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo