Latest Blog Posts

How to Separate Date in Excel Using Formulas (5 Methods)

Dataset Overview For this demonstration, we’ll be utilizing the dataset provided below. In the range of cells from B5 to B10 on the left, you’ll ...

How to Sum Filtered Cells in Excel (5 Suitable Ways)

  Download the Practice Workbook Sum Filtered Cells.xlsm 5 Easy Methods to Sum Filtered Cells in Excel Let's consider a ...

How to Make Subtotal and Grand Total in Excel (4 Methods)

Consider the dataset as shown in the following screenshot. Here, the sales report contains Product Items, States, Price, Quantity, and Sales. We'll ...

How to Sum Selected Cells in Excel (4 Easy Methods)

  Method 1 - Using the SUM Function to Sum Selected Cells in Excel The following dataset shows sales for different months for a company. We'll ...

How to Remove Filter in Excel VBA (5 Simple Methods)

To remove filters from data, we are going to use the following dataset. It contains some product IDs in column B, product names in column C, and the ...

How to Use SUBTOTAL in Excel with Filters (With Quick Steps)

This article will demonstrate how to use the SUBTOTAL function in Excel with filters. Excel SUBTOTAL Function: Overview Objective: The ...

How to Enable Vertical Side-by-Side View in Excel – 4 Methods

Method 1 - Enable Vertical Side-by-Side View of 2 Worksheets in the Same Excel Workbook This is the first sample dataset. This is the dataset ...

How to Sort Subtotals in Excel (with Quick Steps)

Excel is widely used to store important numeric information of students or employees. So it is often needed to extract a group of subtotal values ...

How to Group Rows with Same Value in Excel (6 Useful Ways)

In this article, we demonstrate multiple ways to group rows with same value using Excel features and formulas. Suppose we have an organized dataset ...

How to Open Multiple Excel Files in One Workbook (4 Easy Ways)

Sometimes, we may feel the need to open multiple Excel files in one workbook for better presentation and ease of moving from one file to another. In ...

Excel VBA: Split String by Number of Characters (2 Easy Methods)

In this article, I’ll show you how you split a string by any given number of characters using VBA in Excel. Split String by Number of ...

How to Subtract from Different Sheets in Excel: 2 Suitable Methods

Method 1 - Using Manual Formula to Subtract from Different Sheets Steps: Go to the spreadsheet where you want to find the subtraction of the ...

Subtracting One Range from Another in Excel VBA – 3 Examples

The following dataset contains sales records of different products in different regions.   Example 1 - Getting a Range Address ...

How to Calculate YTD (Year-To-Date) Average in Excel (4 Approaches)

Method 1 - Calculate YTD Average Using Excel AVERAGE Function For calculating the year-to-date average, we are going to use the following dataset. ...

How to Switch Rows and Columns in Excel Chart (2 Methods)

This tutorial will demonstrate how to switch rows and columns in an excel chart. Suppose we are creating a chart in excel or working on an existing ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo