In the previous lesson, we learned the basics of the VLOOKUP function. In this section, we will make you familiar with the important characteristics of the VLOOKUP. Absolute references increases usability You may need to look up for more than one value. For this, you will first need to change table_array relative reference into absolute […]

## VLOOKUP Function in Excel

Suppose, you have a data table with the following information: student name, ID, total marks and marks obtained. By using the VLOOKUP function, we can look up marks obtained of a student by mentioning his/her ID only. How the function work? When you deal with a huge amount of data, instead of inputting data manually, […]

## Data Analysis in Excel

In this section, Excel’s data analysis features are mentioned, click the needed feature and see its usage illustrated with easy examples. Sort Data Sort data in a range or table Sort by Color in Excel Sort by dates in Excel Filter Data How to filter in Excel Filter by color in Excel Number and Text […]

## Group data in Excel

To present data in a well-organized way or to show the only relevant data, use the group feature in Excel. In this illustration, we will first learn how to group then un-group data mentioned in the below screenshot. 1- Select data range that you want to group. 2- Go to the Data Tab, in the […]

## Data Table in Excel – Setting up Two Variable

Previously, we have illustrated the Data Table usage with one variable. In this example, we will illustrate how to use the Data Table feature with two variables. Suppose, you sell a vehicle at $100,000, out of which 60% is your operational cost (1st variable) and 5% is selling cost, resulting in a profit figure of […]

## Data Tables in Excel

If you have a final value based on different variables, the Data Table feature will help to see the impact of changing variables on the final value. Instead of testing each variable individually, the data table feature will let you see the impact at glance without even changing original data. For example, suppose you sell […]

## Scenario Manager in Excel

If you have a final value based on different variables, by using the Scenario Manager tool you can see the impact of changing variables on final value without changing the actual data. For example, you sell a product at $500 each and 60% of product price incurred as its cost. But what if the cost […]