Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting. and this video is uploaded by excelisfun at 2010-02-05T13:59:30-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [J05oqUcsiRM]
| Name | Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting |
| Video Uploader | Video From excelisfun |
| Upload Date | This Video Uploaded At 05-02-2010 21:59:30 |
| Video Discription | Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT494-501.xls 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 [J05oqUcsiRM] |
| Category | Science & Technology |
| Tags | Excel | 2007 | 2010 | Attendance | Sheet | for | classroom | in | Excel. | See | some | copying | tricks | and | the | SUM | function | excelisfun | Mike | Gel | Girvin | Highline | Community | College |
