Latest Blog Posts

How to Use VBA IsEmpty Function (5 Relevant Examples)

When you need to check whether a cell remains empty/blank or not. In such circumstances, you may utilize the VBA IsEmpty function to identify the ...

How to Use the VBA Weekday Function (2 Suitable Examples)

In this article, we'll explain how to use the VBA Weekday function in Excel. VBA Weekday Function (Quick View) Running this code will ...

How to Use VBA And Function in Excel (4 Examples)

The VBA And function in Excel is a logical function that allows us to perform a conditional check between two or more conditions. It returns true if ...

How to Calculate Cumulative Sum in Excel (9 Methods)

The following picture shows the cumulative sum obtained by using one of the methods. 9 Ways to Perform Cumulative Sum in Excel ...

How to Use the VBA Mod Operator – 9 Examples

This is an overview.   Download to Practice Examples of VBA Mod Operator.xlsm The VBA Mod Function Summary The VBA ...

How to Keep 0 Before a Phone Number in Excel (6 Methods)

Method 1- Apply Text Format to Retain 0 Before a Phone Number in Excel Highlight all the cells where you want to keep the numbers with a leading ...

How to Get Unique Values from Range in Excel (8 Methods)

Let’s assume a scenario where we have an Excel file that contains information about the products that a country exports to different countries in ...

VBA EXP Function in Excel (5 Examples)

VBA Exp function is a built-in function in Excel, categorized under the Math and Trig function. In this article, we will show you what Exp function ...

VBA Format Function in Excel: 8 Uses with Methods

Method 1 - VBA to Format Numbers with Predefined Formats Below is the VBA code which covers all the predefined formats to Format numbers in Excel. ...

How to Use VBA IsNumeric Function (9 Examples)

If you are looking for some of the easiest ways to use the VBA IsNumeric function, then you are in the right place. We generally use this function in ...

Advanced Excel Lookup Functions (9 Examples)

In this tutorial, I will discuss several methods regarding MS Excel's advanced Lookup functions. I will use the single Lookup Function to return ...

How to Refresh All Pivot Tables in Excel: 3 Ways

Method 1 - Applying the Refresh All Command to Refresh All Pivot Tables in Excel Step 1: Look at the pivot tables; the Grand Total of the ...

How to Use VBA Right Function in Excel (6 Examples)

The VBA Right function in Excel returns a substring from within a string based on a specified location from the right to the left of that string. We ...

How to Group by Week in an Excel Pivot Table? – 3 Methods

The following dataset showcases sales amounts in January. Method 1 - Setting 7 Days As a Week to Group a Pivot Table by Week This is the ...

How to Substitute Multiple Characters in Excel: 7 Methods

  Method 1 – Using the SUBSTITUTE Function to Substitute Multiple Characters Below is a dataset of Microsoft Word version names. We want to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo