Latest Blog Posts

How to Link Sheets to a Master Sheet in Excel (5 Ways)

Let’s say we have sales data for three different cities, New York, Boston, and Los Angeles. These three are identical in form, so we'll show only one ...

How to replace the Text of a Cell Based on a Condition in Excel – 5 Methods

Method 1 - Replacing Text using the Find and Replace Tool in Excel This is the sample dataset. Step 1: Go to the Home tab. Click ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo