Excel Formulas

Find Text in Excel Range and Return Cell Reference (3 Ways)

In this tutorial, I shall write how to find text in an Excel range and return the reference of the cell that holds the text. Also, I will show ...

How to Reference Cell in Another Excel Sheet Based on Cell Value

Want to use Excel to reference cells in another sheet based on a cell value? In this tutorial, I will explain the whole process step by step. I will ...

Excel formula to find difference between two numbers

Want to know how to find the difference between two numbers (positive or negative) in Excel? Or how to calculate the percentage difference for ...

How to Use Excel Formula to Calculate Percentage of Grand Total

In this tutorial, you will learn several methods of using the Excel formula to calculate the percentage of grand total. Basics of Percentage ...

Adding and Subtracting in Excel in One Formula (4 Easy Ways)

Adding and subtracting are the two most common mathematical operations that we do in our everyday lives. In this post, you will learn how to add and ...

Division Formula in Excel for Multiple Cells (5 Suitable Examples)

If you are searching for some special tricks to use division formula in Excel for multiple cells then you have landed in the right place. There are ...

How to Insert Square Root Symbol in Excel (8 Easy Ways)

This article will show you how to insert the square root symbol in Excel. Sometimes you may need to store irrational numbers as data in an Excel ...

How to Make a Yield to Maturity Calculator in Excel

In this tutorial, I am going to show you 4 effective ways to make a yield to maturity calculator in excel. You can quickly use these methods even in ...

Effective Interest Rate Method Excel Template (Free)

Effective Interest Rate Method Excel Template "No Macro used. No installation is necessary. Just download and start using." - ...

How to Calculate Weighted Average with Percentages in Excel

Calculating a weighted average with percentages in Excel involves multiplying each value by its respective weight (percentage), summing up these ...

Calculate Percentage Difference Between Two Numbers in Excel

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default ...

How to Calculate Hours Worked Minus Lunch with Excel Formula?

In this article, we will show you the Excel formula to calculate hours worked minus lunch. Lunchtime can be in hours or it can be expressed as in ...

How to Calculate Years of Service in Excel (4 Easy Ways)

Suppose you have an employee who recently resigned from your company. You want to calculate his/her years of service at your company. There are ...

How to Sum Multiple Rows and Columns in Excel

Summing up multiple rows and columns in Excel is important for many purposes. In this article, we will see different techniques on how to sum ...

How to Round to Nearest 1000 in Excel (7 Easy Methods)

Here's an overview of the different ways you can round numbers to the nearest 1,000. Let's dig into each option. Method 1 - Using Excel ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo