Excel Formulas

How to Insert and Use Timestamp in Excel?

In this article, you will learn 5 suitable ways to insert a timestamp in Excel with 5 practical applications of timestamp in Excel. The ways are: ...

Ageing Formula in Excel (All Things You Need to Know)

In this Excel tutorial, we will learn about the ageing formula in Excel. We will use these formulas to: - Calculate age in years, months, and/or ...

Excel Date Format (Learn and Convert)

In this article, you will find various tasks related to date conversion, formatting, and manipulation in Excel. It also includes converting different ...

Nested Formula in Excel (All You Need to Know)

In this article, you will learn about nested formula in Excel and their application with different functions. You will get to know about the use of ...

How to Insert Line Break in Excel? (Add New line and Remove)

Are you interested in learning about line break in Excel? Line breaks are often used to display data in multiple lines within a single cell, making ...

How to Use Operators in Excel? (All You Need to Know)

In this article, you'll get to know about 4 commonly used operators in Excel. They are Arithmetic, Comparison/Logical, Reference, and Concatenation ...

How to Use Dynamic Arrays in Excel (20 Useful Functions)

Dynamic arrays in Excel help handle data without the need for complex formulas or manual adjustments. With the help of dynamic array formulas, you ...

Name Manager in Excel (Basic and Applications)

In this article, we will cover everything you need to know about Name Manager in Excel. First, we will discuss what a name manager is and when we ...

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 Perform Excel Match? (8 Different Cases)

This article is about how to match in Excel. In this Excel tutorial, you will learn - The basics of the MATCH function - How to find exact and ...

How to Compare Dates in Excel?

In this article, we will demonstrate how to compare dates in Excel. You will learn how to - Compare dates whether they are the same - Compare ...

How to Randomize in Excel? (5 Effective Ways)

In this article, we are going to randomize Excel data and show the real-world use of randomizing data using five suitable methods in Excel. These ...

How to Apply Abbreviation in Excel (Abbreviate Words, Numbers)

In this Excel tutorial, you will learn how to, - Create an abbreviation for names or words using an initialism approach, where only the first word ...

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

In this Excel tutorial, you'll find ways how to convert text to number format. You'll learn how to convert text to numbers in detail here using the ...

How to Convert Number to Text in Excel?

In this article, we will explain how to - Convert numbers to text in Excel. - Use an apostrophe to keep leading zeros. - Use the TEXT function to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo