496,644 views 243 on YTPak
827 65

Published on 06 Feb 2010 | over 8 years ago

See how to create a basic Attendance Sheet for a classroom in Excel. See THESE TRICKS:
1)See how to Freeze Panes for Large Spreadsheet
2)Ctrl + 1 to open Format Cells Dialog box
3)Create A Custom Date Number format: ddd, m/d/y
4)Copy Dates and use Smart Tag to fill weekdays only
5)Ctrl + Shift + Arrow selection trick
6)IF function to show blank when no student name is showing
7)SUM function to add attendance score.

Vhmrz18 from YouTube
Customize Your Hybrid Embed Video Player!

6-digit hexadecimal color code without # symbol.


Report video function is under development.


Loading related videos...