How to Use EDATE Function in Excel (5 Simple Examples)

EDATE Function in Excel: Syntax and Argument Summary: Provides a Date according to the month number given in the argument. Syntax: ...

How to Use For Each Loop in Excel VBA (3 Suitable Examples)

Example 1 - Using Excel VBA For Each Loop Statement with Range Object Let’s say we have a workbook with one worksheet, the cells E4: E11 containing ...

How to Use the Do While Loop in Excel VBA – 3 Examples

Download Practice Workbook Download the practice workbook. Do While Loop.xlsm The Do While Loop in Excel VBA The syntax is: Do While ...

How to Use Sparklines in Excel [With a Snail Farming Example]

Sparklines are tiny mini-charts that are contained wholly within worksheet cells. Sparklines were introduced in Excel 2010. They allow users to ...

How to Use DATEDIF Function in Excel (6 Suitable Examples)

In this article, we will demonstrate how to use the DATEDIF function to calculate the difference between two particular dates, whether in days, ...

How to Use Do Until Loop in Excel VBA (with 2 Examples)

In this article, we will explain how to use the Do Until Loop in Excel VBA with two simple examples. What Is a Loop? A Loop is a programming ...

Changing Case using Worksheet Functions and Excel VBA

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function, and the Proper Function, which can change the case of a ...

How to Use For Next Loop in Excel VBA (10 Suitable Examples)

A loop is used when we need to run an operation repeatedly. Without performing the same operation manually every time in Excel, we can apply the VBA ...

Exchange (Copy, Import, Export) Data Between Excel and Access

Excel usage is widespread and Excel is often the go-to Office application for data entry, analysis, and manipulation. Microsoft Access provides ...

Comparison Among MAX vs MAXA vs LARGE and MIN vs MINA vs SMALL Functions in Excel

Introduction of MAX, MAXA, LARGE, MIN, MINA, and SMALL Functions 1. MAX Function The MAX function in Excel is used to return the maximum value from ...

IF & AND Functions in Excel VBA to Test Multiple Conditions

We have already seen how to use the IF & AND worksheet Functions to test multiple conditions, in a previous tutorial. We are now going to see how ...

How to Use Select Case Statement in Excel VBA (2 Examples)

Download Practice Workbook Select Case Statement.xlsm Using the sample dataset below, we will illustrate two examples to use the Select ...

Difference Between Protect Sheet and Protect Workbook in MS Excel

  What Are Protect Sheet and Protect Workbook in Excel? In Microsoft Excel, the feature that prevents other users from accidentally or ...

How to Use CEILING.MATH and FLOOR.MATH Functions in Excel

Excel CEILING.MATH Function: Syntax and Arguments Summary: The CEILING.MATH function rounds a specified number up to the nearest integer or ...

All Types of Round Functions in Excel (15 Functions)

Excel provides multiple functions for rounding numbers in one’s worksheet. The most often utilized are the ROUND function, the ROUNDUP function, the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo