What is the Screenshot function in Excel? If you’re doing tutorials, walkthroughs or need to paste a screenshot In the Excel file to show a reference to something or support for something, the same can be done by using screenshot function of Excel. …

What are “Trace Precedents” and “Trace Dependents” Function in Microsoft Excel? The precedents and dependents function is used to graphically display and trace the relationships between cells and formulas with tracer arrows as shown in this figure below: This is helpful in a couple of ways: To determine where a value is being derived from (precedents) and mapping it through its…

What is Sorting function in Microsoft Excel? When the volume of data is humongous, sorting of data becomes essential. This helps in presentation of information in user friendly manner. Sorting can be done in multiple ways, ascending, descending, alphabetical, color, font and in numerous other ways. In this post I will explain how to use sorting function…

What is Data Validation in Excel: Data validation is the function in Excel that is used to control what data can be input in a particular cell or range of cells. 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 Scenario Manager function in excel can be used for making different scenario such as good, bad, moderate, based on certain range of output/input which impact the ultimate outcome. Where to find Scenario Manager in Excel: Go to: Data>Forecast>What-If Analysis>Scenario Manager 1. Data 2. Forecast

What is Text to Column function in Microsoft Excel? Text to column function is used to split cell contents into multiple columns depending on the criteria set. Exported data from a system contains a mix of data attributes. You need the data to be split up so that you can only the relevant part of it. In this post…

What is Remove Duplicates Function in Microsoft Excel? Remove duplicates function is used to remove duplicate values from a series of data in a table. This is a commonly used function if you need to find only unique values of a characteristic of data within a table. If a data table contains an abundance of data and you…

What is Name Manager Function in Excel? Name Manager function of excel is used to add, edit, delete and find the name of a particular cell, cell range, formulas, tables etc. This function increases the understandability of the formulas by giving the cell reference a particular name. Where to find Name Manager in Excel: Go to: Formulas>Defined Names>Name Manager How to use Name Manager Function in Excel?

What is INDIRECT Function in Excel? INDIRECT function of Excel is used to give reference to the cell, cell range, any named range, work sheets or workbook. In simple words INDIRECT function is used to refer the cells, cell range of different work sheets or workbook in any formula and converts the text string into a…