Excel Formulas

How to Calculate Due Date with Formula in Excel (7 Ways)

We have a dataset where some Project Names and their Starting Date and Total Days to complete these Projects are given in Column B, Column C, and ...

How to Use IF Formula with Dates (6 Easy Examples)

Excel IF Function Overview Description The IF function tests a condition, then returns one of the two values depending on whether the test is ...

How to Use COUNTIF Between Two Numbers (4 Methods)

The COUNTIF Function in Excel: Syntax ➤ Description Count cells within specific criteria. ➤ Generic Syntax COUNTIF(range,criteria) ➤ ...

Calculate Future Investment Value with Inflation, Tax and Interest Rates

If you want to calculate future investment with inflation and nominal interest rates, then there is an essential article on How to calculate future ...

How to Calculate Weighted Moving Average in Excel (3 Methods)

Weighted moving average is one form of moving average that is used to smooth out time-series data with an aim to decrease the effects of random, ...

How to Calculate Percentage of Total in Excel? (2 Methods)

Suppose you have a list of your daily or monthly transactions. You want to know in which transaction category you are spending the most. You can get ...

How to Use Excel WEEKNUM Function (5 Examples)

In this article, we’ll demonstrate various examples of how to use the WEEKNUM function effectively in Excel. Introduction to the WEEKNUM ...

How to Use SIGN Function in Excel (7 Effective Examples)

Sometimes, we need the sign of any real number. Regarding the demand, Excel provides the SIGN function which returns the sign of number quickly. In ...

How to Use the YEARFRAC Function in Excel – 7 Methods

This is an overview:   The YEARFRAC Function in Excel  Function Objective The YEARFRAC function is used to calculate the fraction of ...

Different Types of Lookup to Apply in Excel (8 Types)

Here's an overview of the functions and formulas for different types of lookups in Excel. What Is a Lookup in Excel? A lookup means ...

How to Use INDEX MATCH Instead of VLOOKUP in Excel

  Excel INDEX Function The INDEX function returns a value or the reference to a value from within a table or range. The INDEX function is used ...

Conditional Formatting If Cell is Not Blank

Method 1 - Use the Conditional Formatting ‘Highlight Cell Rules’ Option If a Cell Is Not Blank Steps: Select the entire dataset B5:D13. ...

How to Sum Multiple Rows in Excel (4 Quick Ways)

  Download the Practice Workbook Sum Multiple Rows.xlsx 4 Quick Ways to Sum Multiple Rows in Excel Method 1 - Using the SUM ...

How to Remove 0 from Excel (7 Methods)

When we work with spreadsheets not prepared by us, we face different types of number formats in cells. For example, phone numbers may contain leading ...

How to Add Characters in Excel (with Formula, Flash Fill & VBA)

Here's an overview of a method where characters are added using Flash Fill. Download the Practice Workbook Add Characters.xlsm ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo