In our 8th lesson I will discuss about COUNT, COUNTIF and combination of IF and COUNTIF. COUNT is a function which counts the number of cell in a range which contains number. I have given example of COUNT in above two pictures. Now I will show what is COUNTIF and how they can be…

## Lesson#7: How to make nested IF

I this post we will discuss about nested IF making. I have to show Grade on mark sheet so I will check multiple condition by IF. The structure of nested IF will be like this =IF(E5<85,IF(E5<70,IF(E5<55,IF(E5<40, IF(E5<25, “F”, “E”), “D”), “C”), “B”),”A”) which is shown in above picture. 1st layer: If the marks is Less the…

## Lesson#6: Function IF

In this post we will discuss about function IF. IF is a logical function which checks whether a condition met then returns a value if TRUE or another value if FALSE. Syntax of function IF is =IF(logic_test, value_if true, value_if_false). I have added a row to show a simple example of IF by showing the marks…

## Lesson#5: Function VLOOKUP and dollar sign

In this post we will learn a very useful function VLOOKUP (Vertical Lookup, or value lookup in columns) by which we can easily find a data within a table. I have made Data Validation (List) within a cell which shows roll number. Now I will use VLOOKUP to show the relevant student name automatically when…

## Lesson#4: Data Validation (List)

In this post we will learn a function DATA VALIDATION. This is a very useful for making a proper data entry. I will give a good example where we can use it. I made a report card format in another sheet which will show the report card of any student in this format. I have…

## Lesson#3: Showing percentage, learning function MAX, function MIN

We made a table of mark sheet in previous post now we will learn something new. We will learn showing percentage, function MAX and function MIN I have added columns in right hand and put total marks there which is 6*100=600 in every row. Then another column is for showing percentage of marks scored by…

## Lesson#2: Making and formatting table, SUM function and AVERAGE function

We will learn how to make a table with a simple mark-sheet example and we will learn SUM function and AVERAGE function. This is a table I have made. In left side there are names of students, on top subjects and I have put the marks the have scored against the subject. Now what we…

## Lesson#1: Basic operations in Excel

OK friends. This is going to my first lesson. The ABCD of Excel starts here. We will learn how to make basic operations in Excel. How to add, subtract, multiply and divide two numbers. This picture now shows how to make addition between two numbers. Select the first cell then press ‘+’ then select second…

## Introduction: The first post

Why Excel? Microsoft Excel is a very powerful software developed by Microsoft Inc. It’s a spreadsheet software where we can make any type of data calculation, chart, graph preparation. It is very much useful and widely used in offices all over world. Any type of mathematical data, business data easily calculated within seconds by using formulas….