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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo