Excel Formulas

Name Manager in Excel (Basic and Applications)

  Download Practice Workbook Use of Name Manager.xlsx What Is Name Manager in Excel? Name Manager in Excel is used to create, ...

Excel Formulas

Excel Formulas: Knowledge Hub How to Create a Formula in Excel How to Show Formulas in Excel Why Formula Is Not Working in Excel? How ...

How to Calculate Root in Excel? (All You Need to Know)

In this Excel tutorial, you will learn the basics of calculating several types of roots of a number such as - Square root. - Cubic root. - Any ...

Excel Count Unique Values (A Complete Overview)

This article gives a complete overview on Excel count unique values. Here, I will try to explain counting unique values as well as distinct values in ...

Excel Unique Values

In this article, we have demonstrated all the necessary information that is related to Excel unique values. We will use functions and pivot table to ...

How to Perform Excel Match? (8 Different Cases)

Finding matches is an integral part of data analysis. From searching out relevant information from a large dataset to finding errors by matching ...

How to Compare Dates in Excel (2 Methods)

Dataset Overview We'll use the following dataset to demonstrate these methods. We have two columns: Predicted Delivery Date and Delivery Date. Our ...

Excel Compare Columns

Here, we will learn Excel compare columns using different processes and formulas such as conditional formatting, IF function, EXACT function, AND ...

How to Randomize in Excel? – 5 Methods

This is an overview.   Method 1 - Using the RAND Function to Get a Random Decimal Number Between 0 and 1 Go to C5 and enter ...

Wildcard in Excel

Wildcard in Excel: Knowledge Hub Excel Match Wildcard in Lookup Array Search for Question Mark in Excel How to Remove Asterisk in Excel ...

How to Apply Abbreviation in Excel – Abbreviate Words and Numbers

This is an overview.     Method 1 - Combining the LEFT, MID, FIND & LEN Functions to Abbreviate in Excel Enter the ...

How to Convert Text to Number in Excel? (Complete Guideline)

In this Excel tutorial, we will discuss various ways to convert text to number format, including using Error Checking, Paste Special, Text to Columns ...

How to Convert Numbers to Text in Excel (4 Methods)

Method 1 - Using the TEXT Function The TEXT function in Excel can convert any value to text, including numbers. You can also specify a specific ...

Excel Percentage Formula Examples

Excel Percentage Formula Examples: Knowledge Hub Calculate Percentage of Month in Excel Calculate Error Percentage in Excel Apply ...

Spell Number in Excel (With/Without Currency)

You can spell out numbers in different currencies as well as without currency as per your requirement. We have a list of numbers and various ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo