Learn basic Microsoft Excel in just four hours.
This online course contains four hours of basic Excel training split across-22 modules. If you’re new to Excel or have limited knowledge of Excel, this course is for you.
A description of the purpose and application of Excel – what it can do, why it’s useful.
Understanding and working with the Excel interface – getting to know your way around the application, how to access functionality and how to customize it.
How to create, save and open Workbooks. Under Save As, a brief explanation of backwards compatibility and other formats (e.g. PDF) save options. Skydrive, alternative online storage, and ‘local’ saving. Basic printing.
Entering information into cells, types of data (text, numbers, dates). Basic formatting. Working with multiple Worksheets.
Selection and navigation. Moving around a spreadsheet efficiently.
Copying, pasting, inserting and deleting cells, ranges of cells, rows, columns and Worksheets. ‘Special’ pasting – for example to copy just formulas, or just values. Common problems with pasting. The differences between copying and ‘cutting’. Excel aids to copying – Fill Handle and Flash Fill.
Perform basic maths calculations in Excel using cell references and arithmetic operators.
Techniques for sorting and filtering data, including controlling the order of precedence in a sort, advanced filters, and an introduction to PivotTables. Using sorting and filtering to check and ‘clean’ data.
Displaying spreadsheets as pages. Page layout view, page breaks, print area. Printing from multiple Worksheets (and that default will be to print only from active Worksheet). Headers and footers. Adjusting page setup. Printing very large sheets of data.
Pricing is for 12 months access.
Completion Time: 4 hours (average)