Latest Blog Posts

How to Move One Cell Down Using Excel VBA (4 Methods)

The dataset represents the sales of various salespersons in different regions. Method 1 – Using VBA to Move One Cell Down from an Active ...

Excel VBA: Split String into Cells (4 Useful Applications)

The article will provide you with some useful applications to split string(s) into cells by Excel VBA. We do this often to see necessary data ...

How to Generate a Random String from a List in Excel (5 Suitable Ways)

In this article, you will learn 5 different ways to generate a random string from a list in Excel with ease. How to Generate Random String ...

How to Filter a Table based on Cell Values with Excel VBA (6 Methods)

Dataset Overview We've included a sample dataset in the figure below, from which we'll sift through values according to specific cell criteria. ...

Subtraction for Whole Column in Excel (with 5 Examples)

  Below is a dataset that includes income and expenses. Method 1 - Subtraction of Cells Between Two Columns in Excel Steps ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo