How to Create a basic attendance sheet in Excel

This video teaches you how to make a functional attendance sheet in Microsoft Excel. This video shows you a lot of neat tricks to make keeping attendance simple and easy. It shows you how to use the SUM and the IF functions in excel, which are formulas that make the program do a lot of the work that you would normally have to do yourself. This video also shows you a way to create a print area so when the end of the term comes and you have to print out all of the students attendance, you don't have to print out the whole spreadsheet, but can simply make another table with just the total attendance of each student and the name of the student.

4 Comments

how to make attendance sheet in excell 2010 who can help and show me step by step

Ms office is a wonderful thing actually can be used in every walk of life

I HAVE MADE A EXPENSE SHEET ON EXCEL. THERE ARE MENTION STATIONARY PURCHASE, LABOUR PAYMENT, XEROX CHARGES, FUEL COST ETC. AND THIS IS MENTION A SEVERAL TIMES BUT HOW WILL I FIND OUT THE TOTAL COAST OF PARTICULAR ITEM? (eg. I WANT TO TAKE A TOTAL OF LABOUR PAYMENT OF A SHEET OR FROM MANY SHEET)

its a perfect way to create an attendance register in a simplest way.

Share Your Thoughts

  • Hot
  • Latest