Excel Formulas

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

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

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

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

3D Referencing & External Reference in Excel

What Is 3D Referencing in Excel? In Excel, you can use the 3D reference feature to select the same cell from multiple worksheets. By simply ...

NOW vs TODAY Functions in Excel (3 Practical Examples)

We have a spreadsheet showing some data of an employee working for a company. Details such as the employee’s name, department, and total sales are ...

How to Use Excel FORMULATEXT Function?

The FORMULATEXT function is an Excel function first introduced in Excel 2013 and later versions of Excel. The FORMULATEXT function allows users to ...

Best price How to Use Excel FORMULATEXT Function?

How to Use the INDEX MATCH with Excel VBA – 9 Steps

  Download Practice Workbook Download the practice workbook and practice. INDEX-MATCH.xlsx Step1 - Apply the INDEX and the MATCH ...

How to Use Different Types of COUNT Functions in Excel?

Method 1 -Using COUNT Function to Count Cell Numbers The syntax for the COUNT function is: Steps: To count only the number of jobs in ...

How to Use the CONVERT Function to Calculate BMI in Excel

Introduction to the Excel CONVERT Function The CONVERT function converts a number from one measurement system to another. It was introduced in Excel ...

Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. ...

DGET vs VLOOKUP in Excel (7 Differences)

The following sample dataset will be used to illustrate the seven (7) key differences between DGET and VLOOKUP. Difference 1 - Syntax of ...

How to Use the Excel DAYS Function with a Practical Example

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, ...

How to Use Wildcards in Excel (4 Easy Methods)

In this article, we will demonstrate how to use wildcards in Excel. Wildcard characters such as the asterisk "*", question mark "?" and tilde "~" ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo