Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Excel Quickstart for Complete Beginners
Downloadable files
Downloadable project file - Follow along and compare your spreadsheet with mine.
Transcript of my talks
Starting right at the beginning
How to open workbooks and save them as different file types (1:42)
Save time with the quick access toolbar and other top row icons (1:32)
Introduction to the ribbon - where you can access the brains of Excel (2:28)
The name box and formula bar (1:23)
Tabs, worksheets and zoom (2:01)
Saving as another name or filetype (1:59)
Work Smarter not harder
Navigation part 1 - using end then arrow (2:03)
Navigation part 2 - ctrl and left or right arrow plus timesaving navigation tip (2:09)
How to freeze rows and columns (2:42)
How to add and delete rows and columns, undo and redo (3:01)
How to move rows and columns (3:12)
Using Math and Formulas the Easy Way
How to copy and paste values (2:40)
How to do math - add, subtract, multiply and divide (3:04)
Formulas - autosum and average (2:21)
How to combine contents of cells (3:59)
Make a Beautiful Table and Print it out over Multiple Pages
How to make a table of data and format it (4:46)
Manual table formatting (5:32)
Printing part 1 - How to print out (3:03)
Printing part 2 - Using row and column titles for multiple pages (4:07)
How to do math - add, subtract, multiply and divide