How to Sum by Group in Excel (4 Methods)

We will use the following dataset to illustrate summing by group. We have groups of items in the Items column, some of which repeat. ...

How to Remove Filter in Excel (5 Easy & Quick Ways)

For the purpose of demonstrating how to remove Filter in Excel, we'll use a sample dataset of a particular salesperson’s sales information, ...

How to Apply ‘If Greater Than’ Condition In Excel (9 Ways)

Method 1 - Using a Logical Operator to Test the If Greater Than Condition Here's a dataset of the marks obtained by several students. We want to ...

How to Use VBA Int Function in Excel ( 3 Examples)

The Int function in Microsoft Excel returns the integer part of a value. The VBA Int is a built-in function in Excel. In Excel, it can be used as a ...

How to Sum Only Visible Cells in Excel (4 Quick Ways)

We have a dataset of some employees. It contains four columns: Employee name, Department, working Hours per day, and Salary. Here’s an overview of ...

Create Depreciation Schedule in Excel (8 Suitable Methods)

Depreciation describes how an asset's value decreases over time. A Depreciation Schedule is a table that displays the amount of depreciation for a ...

How to Create Drop Down List with Filter in Excel (7 Methods)

Method 1 - Creating a Drop-Down List in Excel The dataset contains some candidate names in column B. We'll create a drop-down that inputs one of ...

How to Extract Text After a Character in Excel (6 Ways)

Method 1 - Using MID and FIND Functions to Extract Text After a Character We'll use the following dataset. We'll extract the text after the hyphen ...

Labour Contractor Bill Format in Excel (Download Free Template)

Here's a template we will make to ensure you can properly bill your customers for the work you do. Download the Practice Workbook ...

How to Sum Only Positive Numbers in Excel (4 Simple Ways)

We're going to use a sample dataset as an example. The following dataset represents the Profit/Loss in the first 5 Days of January of a store. ...

How to Use VBA IsEmpty Function (5 Relevant Examples)

When you need to check whether a cell remains empty/blank or not. In such circumstances, you may utilize the VBA IsEmpty function to identify the ...

How to Use the VBA Weekday Function (2 Suitable Examples)

In this article, we'll explain how to use the VBA Weekday function in Excel. VBA Weekday Function (Quick View) Running this code will ...

How to Use VBA And Function in Excel (4 Examples)

The VBA And function in Excel is a logical function that allows us to perform a conditional check between two or more conditions. It returns true if ...

How to Calculate Cumulative Sum in Excel (9 Methods)

The following picture shows the cumulative sum obtained by using one of the methods. 9 Ways to Perform Cumulative Sum in Excel ...

How to Use the VBA Mod Operator – 9 Examples

This is an overview.   Download to Practice Examples of VBA Mod Operator.xlsm The VBA Mod Function Summary The VBA ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo