Latest Blog Posts

How to Find Outliers with Standard Deviation in Excel: 5 Methods

Method 1 - Estimate Mean of Dataset Select cell E5 and entitle the cell as Mean. Write down the following formula into cell F5. ...

Bonus Calculation as per Bonus Act in Excel (3 Suitable Examples)

In this article we will demonstrate several methods to calculate employee Bonuses in accordance with the USA's Bonus Act in Excel. Overview of ...

How to Ungroup Worksheets in Excel (5 Easy Ways)

In Excel, you can ungroup worksheets. There are a couple of methods for ungrouping Excel sheets. In this article, I’m going to show how to ungroup ...

How to Group Dates by Filter in Excel: 3 Easy Methods

Method 1 - Using Filter Command to Group Dates by Filter in Excel 1.1. Utilizing AutoFilter Simply Steps: Select any data or the entire ...

How to Calculate Cut and Fill Volume in Excel (3 Steps)

Step 1 - Formatting Data in Excel to Calculate Cut and Fill Volume To make the data more understandable, we’ll format it appropriately. ...

How to Filter a Date Range Based on a Cell Value Using VBA (2 Methods)

An Overview of the Dataset and VBA Code  We have a dataset in the range B3:D12 containing Delivery Dates, Delivery Items, and Quantities. ...

How to Filter Last 30 Days of Date in Excel (5 Easy Ways)

Suppose we have the following dataset containing dates along with other entries, and we want to filter the dataset to only show entries from the last ...

How to Create an Email Address with First Initial and Last Name Using Excel Formulas (3 Methods)

Dataset Overview Our dataset contains the first and last names of some people. Method 1 - Combine LOWER and LEFT Functions Open your ...

Nested Formula with AVERAGE and ROUND Functions in Excel

To perform multiple tasks at once, we often use a nested formula in Excel. The nested formula saves time and cells in Excel. In this article, we’ll ...

How to Separate the City State and Zip from the Address Using an Excel Formula – 4 Steps

The sample dataset contains Addresses in column B.  The Address includes the Street, City, State, and Zip code. Step 1 - Combine the LEFT and ...

How to Calculate Mileage in Excel (Step-by-Step Guide)

Throughout this article, we’re going to use the dataset shown below. The dataset consists of a mileage log with the Date of the journey, the Distance ...

How to Calculate Volume in Excel (7 Different Ways)

Method 1 - Volume Calculation of a Sphere Volume of a Sphere = 4/3 * pi * r^3 Steps: We only need to know the radius of the sphere. ...

How to Organize Bank Statements in Excel – 2 Methods

  How to Create a Bank Statement Outline Using Data Organization Guidelines in Excel Create an organized outline for a Bank Statement using ...

How to Arcsine Transform Data in Excel (4 Handy Methods)

If you want to know about how to arcsine transform data in Excel, this article is for you. Here, we will walk you through 4 handy and effective ...

How to Group Dates in Excel Slicer (4 Ways)

We can easily visualize data if we group them. This can save us a ton of time. There are many ways to group Dates. We will show you 4 ways to group ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo