Easy Explanation Notes with Examples

HLOOKUP Function in Excel

HLOOKUP function is similar to the VLOOKUP function, however, the only difference is that it looks up and retrieves data from a selected horizontal row, instead of a vertical column. Example For example, data mentioned in the screenshot below has item related detail. By using the HLOOKUP function, you can easily look up for a […]

LOOKUP function in Excel

The LOOKUP function looks up for a value in a column or row and returns a corresponding value from the same position in another column or row. For example, if you know the name of a product but does not know its price, by using the LOOKUP function you can find the price of the […]

Things to remember about VLOOKUP

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 […]

Copyright © 2016 - 2019 Explainry.com | All Rights Reserved