Excel Formulas

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

How to Create Named Range in Excel: 4 Suitable Methods

Method 1 - Create Named Range Using Name Box Create a name for the Annual Salary column using the Name Box. Select the cell range F6:F15 ...

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

The following image shows a dataset containing products from different sellers. Each product has a discount. The formula to calculate the discounted ...

How to Calculate Percentage Change in Excel (4 Examples)

The following dataset contains some products (B5:B14) and their sales in January (C5:C14) and February (D5:D14). We have calculated the percentage ...

Find and Replace in Excel (A Complete Guideline)

In this blog post, you will learn how to find and replace data in Excel- Using the Find and Replace tool Using the Go to Special feature for ...

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

In the following image, you see some students with their marks in English. We have calculated the total marks, average marks, total no. of students, ...

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

The following sample dataset will be used for illustration. ⏷ Apply Conditional Formatting to Compare Tables and Highlight Differences  ⏵ ...

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

In the following image, we have shown different functions related to complex number operations in Excel. X and Y are two complex numbers. We can see ...

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

What Is GST Reconciliation in Excel? GST (Goods and Services Tax) is a tax applied to items you purchase or services you use. It’s added to the cost ...

How to Create Multiple Invoices in an Excel Spreadsheet – 2 Steps

This is an overview. Download Practice Workbook Invoices.xlsx Creating Multiple Invoices.docx Create Invoices in ...

How to Combine Two Formulas in Excel (3 Ways)

Here is an overview of combining two formulas in Excel. How to Combine Two Formulas in Excel: 3 Ways Method 1 - Two Different ...

How to Insert Timestamp in Excel (6 Easy Ways)

Here's an overview of inserting a timestamp into an Excel table via VBA. Read on for the full discussion. Download the Practice Workbook ...

How to Do Three Way Reconciliation in Excel: 5 Methods

Method 1 - Inserting Bank Statement and Transactions Record in Dataset Insert the bank statement for the month of July in a sheet titled ...

How to Use Arithmetic Operators in Excel (a Detailed Guide)

Types of Operators in Excel There are four kinds of operators for calculation. They are: Arithmetic Comparison Text concatenation ...

How to Create a Min-Max-Average Chart in Excel – 4 Steps

This is an overview: Download Practice Workbook Download the practice workbook. Min Max Average Chart.xlsx What Is a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo