Formulas - autosum and average | Excel Keith

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)

Teach online with

Formulas - autosum and average

Complete and Continue