Latest Blog Posts - Page 65 of 584

How to Use Excel VBA Do While Loop with Multiple Conditions

Jun 16, 2024

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

How to Use Excel VBA Do While Loop with Multiple Conditions

How to Create Excel Floating Total Row (2 Quick Ways)

Nov 11, 2025

In this article, I am sharing with you how to create Excel floating total row with a running total. Creating a floating row with a running total in ...

How to Create Excel Floating Total Row (2 Quick Ways)

Excel VBA to Filter Pivot Table Based on List

Jul 24, 2024

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

Excel VBA to Filter Pivot Table Based on List

How to Make Slicer Horizontal in Excel

Jul 6, 2024

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

Aug 10, 2024

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

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

Excel VBA Variable Types

Nov 11, 2025

In this article, we will discuss Excel VBA variable types. Variables are a fundamental concept of any programming language. Different types of data ...

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

Jul 6, 2024

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

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

How to Use Excel VBA to Call Private Sub from Userform

Nov 11, 2025

Looking for ways to use Excel VBA to call private sub from userform? Then, this is the right place for you. In Excel VBA, private subs are ...

How to Use Excel VBA to Call Private Sub from Userform

How to Calculate Daily, Weekly or Monthly Average in Excel

Nov 11, 2025

Daily Weekly Monthly Average in Excel: Knowledge Hub How to Calculate Monthly Average from Daily Data in Excel How to Calculate Weekly ...

How to Calculate Daily, Weekly or Monthly Average in Excel

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

Jul 15, 2024

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

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

Using Excel VBA to Declare a Global Variable – 2 Methods

Aug 13, 2024

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

Using Excel VBA to Declare a Global Variable – 2 Methods

Excel Scientific Notation Without e (7 Quick Tricks)

Jul 9, 2024

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

Excel Scientific Notation Without e (7 Quick Tricks)

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

Jul 25, 2024

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

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

Excel VBA Horizontal Alignment

Nov 11, 2025

In this article, we will learn how to use Excel VBA horizontal alignment. Excel VBA is the visual basic analysis which is a programming language. You ...

How to Use Excel VBA to Unwrap Text

Nov 11, 2025

In this article, we will discuss VBA codes to unwrap text. We often use the Wrap Text command to fit text inside a cell. In order to unwrap the text, ...