This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
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
Complete and Continue