Latest Blog Posts

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

How to Use VBA InStrRev Function (7 Suitable Examples)

When you need to find the position of a character inside a string or the occurrence of a substring inside a string, the VBA InStrRev function might ...

Excel COUNTIFS Not Working (7 Causes with Solutions)

We'll use this dataset to demonstrate what actions to take when the COUNTIFS function doesn’t work properly. Download the Practice ...

Excel Invoice Tracker: Format and Usage

Managing and keeping track of billing is a daunting task when we use a plain Excel worksheet. Using an Excel Invoice Tracker can ease this task. An ...

How to Use the VBA Chr Function (2 Examples)

One of the most important and widely used functions of VBA is the Chr function. In this article, I’ll show you how you can use the VBA Chr function ...

How to Make an Amortization Table in Excel?

This article shows how to make an Amortization table in Excel that shows the periodic payments on a loan over a period of time. This table breaks ...

How to Lookup Multiple Values in Excel (10 Ways)

Method 1 - Using an Array Formula to Lookup Multiple Values in Excel The VLOOKUP Function can only return a single match. We can use an array ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo