Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting

Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting

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

Leave a Reply