Latest Blog Posts

How to Consolidate All Comments in Excel (3 Simple Ways)

In order to add important information to a cell, we often use comments in Microsoft Excel. There might have multiple comments in a worksheet. It can ...

How to Convert Easting Northing to Lat Long in Excel

Here's an overview of converting coordinates into latitude and longitude. Download the Practice Workbook Easting Northing to Lat ...

How to Get Cell Value as String Using Excel VBA (4 Easy Ways)

Here's an overview of the VBA code needed to get cell values. How to Get Cell Value as String with Excel VBA: 4 Approaches Method 1 - Get ...

Compare Two Excel Sheets and Highlight Differences Macro

In this article, we will learn how to compare two Excel sheets and highlight differences using a macro. So, let's start. Sometimes we are working on ...

[Solved!] MINVERSE in Excel Not Working

Here's an image overview of the most common reasons behind the MINVERSE function not working properly. Download the Practice Workbook ...

Extracting Email Addresses from Excel (4 Easy Ways)

Here's a dataset that will provide an overview of extracting email addresses from Excel. It contains addresses embedded into larger strings in cells. ...

Bookkeeping for Truck Drivers in Excel

Here's an overview of the template we'll make in the article. Bookkeeping for Truck Drivers in Excel: Step-by-Step Procedure Step 1 ...

Excel VBA to Filter Pivot Table Based on Multiple Cell Values

For more accurate data analysis, Microsoft Excel VBA provides a powerful method for filtering pivot tables based on multiple cell values. We'll walk ...

VBA Code to Create Pivot Table with Dynamic Range in Excel

We will use a sample dataset containing First Name, Last Name, Email, and Gross Pay to demonstrate creating a pivot table with a dynamic range. ...

Proofing in Excel

Proofing in Excel: Knowledge Hub How to Spell Check in Excel Dictionary in Excel (Create & Use) << Go Back to Learn Excel

The Feathered Theme is Missing in Excel – Solution

This dataset represents sales and profit of different companies over the year. The Office theme was used to create the dataset. Step 1 - ...

How to Perform Excel Data Analysis: Forecasting (3 Easy Ways)

Download Practice Workbook Data Analysis Forecast.xlsx Method 1 - Using Moving Average Method for Forecasting Data Analysis in Excel ...

Excel Evaluate String as Formula (2 Easy Ways)

In this article, we will explore the idea to evaluate a string as a formula in Microsoft Excel. The necessity of this feature is discussed, ...

How to Calculate Inverse Matrix in Excel (3 Ways)

Here's an overview of a matrix in Excel and the functions that create inverse matrices. Download the Practice Workbook Inverse ...

How to Compare Sheets Side by Side in Excel (5 Examples)

In this article, we will show you how to use Excel to compare sheets side by side. Comparing various datasets at the same time is a very common ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo