VBA If – Then – Else Statement in Excel (4 Examples)

Conditional statements are used to perform a set of actions depending on the specified condition in programming languages. In this article, we will ...

Hotel Bill Format in Excel (Create with Easy Steps)

Hotel Bill format is an invoice format that you can use to create hotel bills for clients in order to document information about hotel services as ...

Cannot Group Dates in a Pivot Table – 4 Solutions

This is an overview: Solution 1 - Replacing Missing or Distorted Date Values to Group Dates in a Pivot Table Step 1: There are error ...

Shortcut for Sum in Excel (2 Quick Tricks)

From time to time, we store various types of data in Excel sheets, and most of the time we need to Sum up cell values. This article will show you ...

How to Use VBA TimeValue Function (6 Relevant Examples)

Often, we may have a time string in a format where the time value is not separate. In such a situation, using the VBA TimeValue function will be a ...

How to Auto Refresh Pivot Table in Excel (2 Methods)

To illustrate how to refresh an Excel pivot table, we created two pivot tables for a dataset. The dataset shows a list of sale data with all required ...

How to Use IsDate Function in VBA (3 Examples)

The IsDate function is a built-in VBA Information function in Excel that you can use in a lot of scenarios. Besides, you can perform various ...

How to Use VBA Case Statement (13 Examples)

The CASE statement is a logical function, which can be used instead of the IF-THEN-ELSE statement. VBA Case Statement: Syntax & Arguments ...

How to Calculate Sum of Squares in Excel (6 Quick Tricks)

Microsoft Excel provides us with the option to calculate the Sum of Squares very easily. We can also compute the Sum of Squares using mathematical ...

How to Calculate Percent Frequency Distribution in Excel

A percent frequency distribution can help you figure out what proportion of the distribution is made up of specific values. By grouping values ...

How to Trim Spaces in Excel (8 Methods)

Dataset Overview Let's use a sample dataset that represents the personal information of specific people. The dataset has 3 columns. These are Name, ...

44 Mathematical Functions in Excel (Download Free PDF)

1. The AVERAGE Function Function Objective: The AVERAGE function calculates the average of numbers in a range of cells. Syntax: ...

Create Tally Bill Format in Excel From Scratch: 7 Methods

Method 1 - Create a Bill Header with Company Details Enter company details such as Company Logo, Name, Address, Contact Details, GSTIN No. etc. ...

VBA Date Function (13 Uses of Macros with Examples)

Download Practice Workbook Uses of VBA Date.xlsm Function 1 - DateAdd Function as Date in VBA In VBA, we use the DateAdd function to ...

How to Use Reference from Another Excel Workbook Without Opening it – 5 Examples

Example 1 - Use a Reference from Another Workbook Using the Paste Link Option Step 1: Open the worksheet: Closed.xlsm. Copy B5:C9. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo