Latest Blog Posts

VBA to Call Sub From Another Workbook in Excel (With Examples)

In this article, we will demonstrate how to utilize VBA to call a subroutine (sub) from another workbook, both opened and closed. We will also ...

How to Use the CONCAT Function in Excel – 7 Examples

Quick View: Download Practice Workbook CONCAT Function.xlsm Overview of the CONCAT Function Syntax: =CONCAT(Text1, …) ...

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

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

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo