Latest Blog Posts

Excel VBA Manual Calculation on Workbook Open

This article provides a comprehensive guide on implementing VBA manual calculation on workbook open, taking into account diverse user requirements ...

Excel VBA to Calculate Active Sheet (6 Practical Applications)

Sometimes, when working with large datasets, Excel won't compute all the formulas in the cells. One solution to this problem is to use VBA to ...

How to Use VBA Array Function in Excel

The Array Function is a very useful tool in Excel to store data and limit the use of the variable, which is basically saving a lot of memory usage of ...

Excel SUMIF Not Equal Criteria: 5 Suitable Examples

Method 1 - Calculating Sum with Numeric Not Equal Single Criteria Use the following formula in a cell of your worksheet. =SUMIF(E5:E17, ...

How to Handle Excel VBA On Error GoTo 0 

While working on a dataset, sometimes you need to sum up numbers or do other operations. This is quite easy while you are working on a small dataset, ...

How to Use Excel VBA Select Case and Operator

,In this article, we will discuss VBA codes with Select Case and related Operator(s). The Select Case statement is one of the control structures ...

How to Add the Excel Feathered Theme

In Excel, you will find different types of themes that can improve the readability of the dataset. Usually, a feathered theme is not added to Excel ...

Excel Slicer Greyed Out: 2 Methods

Method 1 - Greyed Out Slicer for Excel Table Reason: Earlier Version Slicers are not natively supported in older versions of Excel, such as Excel ...

Excel VBA Do While Continue

In this article, we will demonstrate the duplicate use of the Excel VBA Do While Continue statement. Continue statement allows you to skip all the ...

VBA Excel to Exit Do While Loop (4 Suitable Examples)

In this article, we will demonstrate how to use the Exit Do command inside the Do While loop. The Exit Do command inside the Do While enables us to ...

Pivot Table Date Format

Pivot Table Date Format: Knowledge Hub Change Date Format in Pivot Table in Excel Remove Time from Date in Pivot Table << Go ...

How to Resolve the Excel VBA “Argument Not Optional” Error (4 Solutions)

Why “Argument Not Optional” Error Occurs in Excel VBA This error occurs when you call a procedure or function without providing all the required ...

How to Create Dynamic Table in Excel: 3 Quick Ways

We'll use the following simple dataset of employees to demonstrate how to create more dynamic tables. Method 1 - Using the Excel Table and Named ...

How to Make a Bill of Materials in Excel (2 Types)

  Type 1 - Making a Bill of Materials for a Single Product   Step 1. Create a Basic Dataset for Making a Bill of Materials We have ...

How to Create Dynamic Table of Contents in Excel (3 Easy Methods)

A dynamic table of contents in Excel allows users to create an interactive and automated index for their workbooks. By linking sheet names and ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo