Hi, My name is Ijtaba and I am a Data Analyst having more than 15 years of experience in diversified fields like Business Analysis, Workforce Management(WFM), Data Analysis, Process Improvement, and Machine Learning. My goal is to knowledge, but what I also learned is that I should prepare an army of excellent skilled professionals. I have personally trained many subordinates, colleagues, friends, and professionals in the journey.

How to use HLOOKUP in Excel

How to use HLOOKUP in Excel

HLOOKUP is one of the functions provided by Microsoft Excel which helps us find a value for a particular reference value. Its functions are the same as VLOOKUP, just the difference exists in terms of fetching data horizontally instead of vertically.

This formula also requires 4 inputs as mentioned below:

How to use HLOOKUP in Excel 4
How to use HLOOKUP in Excel
How to use HLOOKUP in Excel 5

We will take an example to understand this in a better way. As we see in the below table we have data for student’s marks achieved in different subject. Now if I wanted to fetch data for a particular student for a particular subject then we will use HLOOKUP to … Continue Reading

How to use VLOOKUP function in excel | VLOOKUP formula in excel with example

How to use VLOOKUP function in excel

Excel Vlookup is the most sought formula in excel and is widely used by everyone. It is used basically for looking up values vertically means from the column.

Before learning how to use vlookup excel we need to understand about different inputs of excel vlookup formula. As we can see below picture there are 4 different inputs required for using excel vlookup function.

How to use VLOOKUP in excel
Vlookup formula

The explanation of values are given as given below:

How to use VLOOKUP in excel
How to use VLOOKUP in excel

Let us understand this by and example.

In the below table we can see the name of the person and sales done by them on the month on month basis. Now we wanted … Continue Reading

Different COUNT functions in Excel: How to use these functions

Different COUNT functions in Excel

Excel COUNT function is a very important function in excel and it is being used very frequently. There are five COUNT functions in excel(count, counta, countblank, countif,countifs) that are being used in excel. I will explain every function one by one how to use the count function in excel and have also shared a video with a full explanation.

Count: This function counts the number of numeric entries in a list. It will ignore blanks, text, and errors.Syntax: =COUNT(Range1,Range2,Range3……………….,RangeN)

Different COUNT function in Excel
Different COUNT functions in Excel

Counta: This function counts the number of numeric and text entries in a list. It will ignore blanks.Syntax: =COUNTA(Range1,Range2,Range3……………….,RangeN)

counta function in excel
counta function in excel

Countblank: This function counts the number of … Continue Reading

employee 3005501 1920

The History of MS Excel: A timeline

The History of MS Excel

The journey of Excel started in 1987 with Excel 2.0 as the first version for Windows. There never was an Excel 1.0 for DOS or Windows. Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.0 (to synchronize with the Macintosh version 2.2) in November 1987.
Excel 3.0 launched in 1990s and it included tool-bars, drawing capabilities, outlining, add-in support, 3D charts among the other features.
Excel 4.0 launched in 1992 and it introduced auto-fill options in Excel.
Excel 5.0 launched in 1993 includes VBA and it had the ability to automate the tasks in excel and has the capacity to create a user-defined … Continue Reading