Excel Formulas

Spell Number in Excel (With/Without Currency)

Spelling numbers in Excel is often required for banking or marketing sectors. Although Excel does not offer any built-in function to spell numbers, ...

Excel Named Range (A Complete Guideline)

Excel named range allows users to assign names to specific cells or ranges. This feature increases clarity and efficiency while working with large ...

How to Copy Formula in Excel (Column, Rows, Copy as Formulas, etc.)

Copy a formula in Excel means to replicate a formula from one cell to another or multiple cells. It allows you to use the same formula for other ...

How to Calculate Percentage Change in Excel (4 Examples)

Percentage change determines the relative difference between the two values and the difference is expressed as a percentage. From this calculation, ...

Find and Replace in Excel (A Complete Guideline)

Finding and replacing data in Excel means Excel will find data first and then replace it with another one. It can be a single character or even ...

Excel Formula List (40+ Useful Formulas to Master Excel)

In this Excel tutorial, you will get a list of useful Excel formulas for your daily use while working. We’ll use relevant practical datasets to give ...

How Can You Compare Tables in Excel? (All You Need to Know)

In this Excel tutorial, we will explain everything about how to compare tables in Excel. We will discuss 6 different ways of comparing tables as well ...

How to Insert, Use and Convert Complex Numbers in Excel?

In this Excel tutorial, you will learn how to - Insert complex numbers in Excel - Find imaginary and real parts of a complex number - Sum, ...

How to Do GST Reconciliation in Excel (4 Suitable Methods)

In this article, you’ll learn how to do GST reconciliation in Excel with 4 suitable methods. The methods include using different functions like the ...

How to Create Multiple Invoices from Excel Spreadsheet

In this article, we will learn to create multiple invoices from an Excel spreadsheet. In terms of business, efficient invoicing processes play a ...

How to Combine Two Formulas in Excel (3 Ways)

In this article, we will learn how to combine two formulas in Excel. Microsoft Excel is a powerful tool for data analysis, calculations, and ...

How to Insert Timestamp in Excel (6 Easy Ways)

In this article, you will learn how to insert timestamp in Excel. Here, I will show you different methods for inserting timestamps. So, you can use ...

How to Do Three Way Reconciliation in Excel (Step-By-Step)

In this article, you’ll learn how to do three way reconciliation in Excel with 5 simple steps. You’ll also learn what is three way reconciliation ...

How to Use Arithmetic Operators in Excel (Detailed Guide)

In this article, you will learn everything you need to know about how to use arithmetic operators in Excel. The main application of Excel requires ...

How to Create Min Max and Average Chart in Excel

In this article, we will learn how to create a min max and average chart in Excel. We’ll also learn how to add or draw max min or average lines in an ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo