00 - Introduction and Printable Downloads
A brief introduction with downloadable/printable Quick Reference Guide and a Progress/Score Sheet
01 - Exploring and Customising the Excel 2016 Interface
Learn about how to start Excel and create new documents, the Excel screen layout, the ribbon,
and the Quick Access Toolbar.
02 - Managing Documents
Learn how to create, open, and save Excel workbooks.
03 - Navigating the Worksheet
Learn how to find your way around a worksheet and workbook using the mouse and
04 - Basic Editing
Adjust column width and row height, cell formatting, edit cell contents.
05 - Number and Text Formats
The difference between numbers ('values') and text ('labels'), using an apostrophe as a label prefix, and how the Smart tag works. Different ways of formatting numbers as currency, percentage, etc. Selecting cells and applying basic formatting.
06 - Copying and Moving Data
How to use Cut, Copy & Paste, and also 'Drag & Drop' to move data.
07 - Basic Formulas
+ - * / % - simple cell-by-cell formulas, F5 Go to Special, the 'BODMAS' rule and using brackets, use of AutoSum and AutoFill.
08 - Editing
Inserting and deleting columns and rows using the menu, right-click method, Ctrl+ & Ctrl-, keyboard shortcuts. Hiding columns and rows using right-click method, double-clicking column separator, changing column width and row height for the entire worksheet.
09 - More on Formatting
A look at some more advanced formatting.
10 - More Formulas
A look at some more advanced formulas.
11 - Cell Comments
How to use cell comments
12 - Printing and Views
How to insert titles and page breaks to your printouts.
13 - Tables
How to set up, format and edit tables.
14 - Charts
An Excel chart tutorial that shows you how to create, edit and format both chart sheets and chart objects.
15 - What next?
Here's a taster of more advanced Topics & learning. Try the VLOOKUP video.
©All content is strictly copyright. One login is for one user unless stated otherwise.
If you do not see clickable links to the Excel Foundation Course above or to the left you will need an account and a paid subscription. If you already have these, but don't see the links, log on here. If you run into problems, please contact us.