Latest Blog Posts

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

How to Keep 0 Before a Phone Number in Excel (6 Methods)

Method 1- Apply Text Format to Retain 0 Before a Phone Number in Excel Highlight all the cells where you want to keep the numbers with a leading ...

How to Get Unique Values from Range in Excel (8 Methods)

Let’s assume a scenario where we have an Excel file that contains information about the products that a country exports to different countries in ...

VBA EXP Function in Excel (5 Examples)

VBA Exp function is a built-in function in Excel, categorized under the Math and Trig function. In this article, we will show you what Exp function ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo