Attendence list in Excel

In this tutorial we will learn attendence list using Excel.
We will use Countif function in this tutorial.
1.Example:
   x means present.
   Blank cells showing absent.

   

2.Example:We can also count absent days by using Countif        function as shown in below image.

We can see in following image that employee ID 706 have only 1 absent.Inverted commas "" in formula count blank cells

IFERROR function

In following image VLOOKUP function used to find the required data.
For Example If we enter john it shows the result of john's data.

But if we enter the name which is not listed then it shows #N/A.To avoid #NA, IFERROR function can be used.

By using IFERROR function we can show our desired message.You can see it in below image.

COUNTA Function

It use to calculate cells,but empty cells are not included. You may use it, according to your own purposes.

Vlookup Function

Vlookup use for search specific information in spreadsheet.Form example in below picture we want to search a product price.

How to fix a cell's value while copying cell

Following picture is an example for fix a value while copying formula and drag it to down.In below picture I want to multiply all values of Qty with 100 for this I used formula =C5*D$4,Dollar sign fix the value and it can't change while copying cell.

Isnumber Function

Isnumber function returns true if value is a number,otherwise returns falls

How to Show Largest Value In MS.Excel

With the help of LARGE function we can show largest value. It may be  1st,2nd,3rd etc largest value.

In this image 1st largest value is return.

If we want to show 2nd largest value then below's image is an example.Formula will be same,we just have to change last value of formula like,1 will return 1st largest and 2 will show 2nd largest value.

Concatenate Function in Excel

In Concatenate function we can compose text of multiple cells.