What is the Protection Function or the Protect Range in Microsoft Excel?

What are “Trace Precedents” and “Trace Dependents” Function in Microsoft Excel?

This is helpful in a couple of ways:

  1. To determine where a value is being derived from (precedents) and mapping it through its…

What is Sorting function in Microsoft Excel?

In this post I will explain how to use sorting function…

What is Data Validation in Excel:

When inputting the data, data validation can display a message for the user regarding what type/kind of data can be input.

It also stops the…

What is Scenario Manager in Excel

Where to find Scenario Manager in Excel:

Data>Forecast>What-If Analysis>Scenario Manager

1. Data

2. Forecast

What is Text to Column function in Microsoft Excel?

In this post…

What is Remove Duplicates Function in Microsoft Excel?

If a data table contains an abundance of data and you…

What is Name Manager Function in Excel?

Where to find Name Manager in Excel:

How to use Name Manager Function in Excel?

Let’s understand how…

What is INDIRECT Function in Excel?

Commerce Curve

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store