Latest Blog Posts

[Fixed!] Trace Dependents Is Not Working in Excel (3 Solutions)

In this article, I am going to present some possible solutions to fix the Excel Trace Dependents not working problem. The Trace Dependents is a very ...

IF with ISERROR Function in Excel: 4 Practical Examples

Here's an overview of using the IF and ISERROR functions to check a car's unit price depending on the amount of available stock. What Is ...

Excel Function Categories

Excel Function Categories: Knowledge Hub Excel LOOKUP and Reference Functions Excel Date Functions Use of Excel Database Functions DGET, ...

How Do You Link Sheets in Excel with Index (3 Swift Ways)

In this article, we are going to show you how you link sheets in Excel with an index. We will apply the HYPERLINK link function, VBA macro, and also ...

Sole Trader Bookkeeping Excel

This article will teach us how to create a sole trader bookkeeping Excel. Here, we will create a template and add all the information to complete the ...

Excel VBA Range Address – 5 Examples

This is an overview. Download Practice Workbook Download the workbook and practice. Range Address.xlsm Syntax of the Excel ...

Excel Color Index Formula

In this article, we will explain how to use the Excel color index formula. One of the standout features of Excel Color Index is its ...

Excel Button Tooltip

This article will demonstrate how to add and utilize an Excel button tooltip to enhance the accessibility and user-friendliness of complex ...

How to use the Excel VBA Watch Window

Below, you can see how the watch window monitors the variable value in Excel VBA. How to Add a Watch Window  Open the VBA code editor ...

Excel Change Color If Time Is in Range: 3 Suitable Ways

Method 1 - Formatting Cells Between Time Range to Change Color Select the range of cells > go to the Home tab > click Conditional ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo