Latest Blog Posts

Excel Pivot Table: Difference between Two Columns (3 Cases)

Consider the dataset which contains the Sales Report for 2021 and 2022 of some Product Categories, along with Order Date and corresponding States. ...

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 ...

Split Date and Time Column in Excel (7 Easy Methods)

Method 1 - Use the INT Function to Split Date and Time Steps: Add two new columns for date and time. Go to cell C4 and put the ...

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 ...

Separate First and Last Name with Space Using Excel Formula (3 Ways)

We have a dataset of some full employee names. We will separate their first and last names in different columns. Method 1 - Combine LEN, ...

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 Create a Database That Updates Automatically in Excel

Watch Video - Create a Database That Updates Automatically in Excel Method 1 - Extract Data from the Web to Create a Database That ...

How to Replace Text with Carriage Return in Excel (4 Smooth Approaches)

For the fabrication of information, We can use Carriage Return. It means to return the beginning of the next line in the same cell. Here, We are ...

[Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)

Reason 1 - Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel Let’s assume we have a dataset containing several fruits and their ...

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. ...

Assigning Weights to Variables in Excel (3 Useful Examples)

In many cases, the exams in a school, or products in a company carry equal weight or significance. In that case, the average is very easy to ...

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, ...

Stocks and Geography Data Types are Missing in Excel – 3 Solutions

Data Types in Excel There are different Data Types in Microsoft Office 365: Stocks, Geography, Currencies, Automatic, Activities, Anatomy, Animals, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo