Latest Blog Posts

How to Make a Waterfall Chart with Multiple Series in Excel

The default waterfall chart feature in Excel 2016 and later versions can be used to create a waterfall chart with just one series. However, it is ...

Excel VBA: How to Refresh All Data Connections – 4 Examples

This is an overview. Create Data Connections between Excel Files The original dataset is the Dataset sheet in the Source Sheet workbook . ...

How to Calculate Economic Order Quantity in Excel

  What Is Economic Order Quantity? It means the optimum level of order quantity, not higher or lower. Economic Order Quantity (EOQ) is a ...

How to Use Excel VBA to Add a Comment to a Cell – 3 Examples

This is an overview.   If you are new to Microsoft Visual Basic Application, read How to Write VBA Code in Excel. Example 1 - ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo