Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF
In our 8th lesson, I will discuss COUNT, COUNTIF, and the combination of IF and COUNTIF. …
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF Read more →
Lesson#7: How to make nested IF in Excel?
In this post we will discuss nested IF making. I have to show Grade on the …
Lesson#6: What is Function IF in Excel?
In this post, we will discuss function IF. IF is a logical function that checks whether …
Lesson#5: Function VLOOKUP and dollar sign
In this post, we will learn a very useful function, VLOOKUP (Vertical Lookup, or value lookup …
Lesson#4: What is Data Validation in Excel?
In this post, we will learn the function DATA VALIDATION. This is very useful for making …
Lesson#3: Showing percentage, learning function MAX, function MIN
We made a table of mark sheets in the previous post; now we will learn something …
Lesson#3: Showing percentage, learning function MAX, function MIN Read more →
Lesson#2: Making and formatting table, SUM function, and AVERAGE functions
We will learn how to make a table with a simple mark-sheet example, and we will …
Lesson#2: Making and formatting table, SUM function, and AVERAGE functions Read more →
Lesson#1: Basic operations in Excel
OK friends. This is going to be my first lesson. The ABCD of Excel starts here. …
Introduction: The first post
Why Excel? Microsoft Excel is a very powerful software developed by Microsoft Inc. It’s a spreadsheet …