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

Download Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting video on savevid.com

Download Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting streaming video in flv, mp4, avi formats direct easily on Savevid.com.

 

Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM funct...

  • To download Youtube videos you should click "Run" when java window opens. Enable "Always trust content from the publisher" to download seamlessly in the future.
  • Download video
  • Provider: Link: http://www.youtube.com/watch?v=J05oqUcsiRM
  • Rate: Please rate this video Views: 16 Downloads: 45
  • Description: 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
  • Tags: , , , , , , , , , , , , , , , , excel.
  • Category: Flag video Science & Technology

Related videos

download youtube videos