Latest Blog Posts

How to Insert an Excel Table from an Image

We will add a table from the below image for the methods below. Method 1 – Using an Image Saved in File Explorer Steps: Select a ...

Excel VBA to Check If String Contains Letters: 3 Easy Ways

Method 1 - VBA Code to Check If String Contains Any Letter Every character has a unique ASCII code and the computer recognizes them with that code. ...

Excel Formula to Change Cell Color Based on Text (3 Easy Methods)

Suppose you have the following dataset: Method 1 - Applying Conditional Formatting Steps: Application of Cell Rules Select the ...

How to Use Excel VBA Try Catch – 3 Examples

In the image below, the error is neglected by declaring the On Error Resume Next statement, which replicates the Try Catch statement.   ...

Excel VBA Nested If Then Else in a For Next Loop (3 Examples)

In this article, we will explore three simple examples that demonstrate the practical application of nested If Then Else statements within a For Next ...

How to Use Excel VBA Do While Loop with Multiple Conditions

The Do While loop in Excel VBA allows code to be executed repeatedly as long as a specified condition remains true. In this article, we will explore ...

Excel VBA to Filter Pivot Table Based on List

We will use Excel VBA to filter a Pivot Table based on a list. Consider the following dataset with fruit sales. Create a Pivot Table in ...

How to Make Slicer Horizontal in Excel

Excel slicer is a vital tool that gives users easy access to data filtering and interaction. Slicers are often shown vertically, however, a ...

Using Excel VBA to Change the Pivot Table Source – 2 Methods

  The dataset contains Product ID, Product, category, sales of the products, Date, and Outlets of a grocery shop.   Method ...

How to Use Excel VBA to Filter a Pivot Table (5 Examples)

  Method 1 - Filter a Pivot Table Based on Single Criteria Using VBA STEPS: To create a pivot table, a sample code is given ...

Excel VBA to Get Pivot Table Field Names (3 Easy Methods)

We have two pivot tables in separate sheets named Sheet1 and Sheet2. The picture below is the first pivot table containing the Sum of Revenue of a ...

Using Excel VBA to Declare a Global Variable – 2 Methods

This is an overview. Download Practice Workbook Download the practice workbook. Declare Global Variable.xlsm   Method 1 ...

Excel Scientific Notation Without e (7 Quick Tricks)

Download the Practice Workbook Convert Scientific Notation to Number.xlsx Method 1 - Apply the INT Function to Convert Scientific ...

How to Calculate Safety Stock and Reorder Point in Excel (6 Methods)

Safety Stock Safety stock acts as a buffer to ensure that a company can meet customer demand even during unexpected fluctuations in demand or lead ...

Excel VBA Call Sub from Another Module

  Method 1 - Using Call Function Using the Call Function we can call a sub and execute the task inside the sub directly. There are ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo