Latest Blog Posts

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

How to Use Excel VBA to Create a Pivot Table (3 Examples)

  Method 1 - Inserting a Pivot Table with CreatePivotTable Command Steps: Create a dataset to insert the pivot table. Check out our ...

How to Run a Private Sub in VBA (3 Methods)

Here's an overview of a private sub in VBA. What Does Private Sub Mean in Visual Basic? A private sub refers to a subroutine or method ...

How to Do Excel Data Analysis Correlation (4 Easy Ways)

Here's a sample example of using the correlation coefficient to analyze data. Download the Practice Workbook Download this practice ...

Use Excel VBA to Create Chart from Pivot Table

Here's an overview of using VBA to create a chart from a pivot table. Use Excel VBA to Create Chart from Pivot Table: 3 Methods We have ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo