MS Excel Introduction training course (2 days)

This basic Excel training course requires no experience of using Excel, just basic computing skills. It provides fundamenal Excel tuition and intermediate Excel training on all key aspects of using the program: entering, formatting and editing data, using functions and formulas, creating charts and producing reports.

Basics

Standard toolbar overview
Formatting toolbar overview
Data entry
Block selection
Copying data
Moving data
Inserting cells, rows and columns
Deleting cells, rows and columns
Resizing rows and columns
Using the AutoFit facility
Undoing and redoing operations
Spell checking
Printing a spreadsheet

Formatting

Setting alignment
Using cell shading
Adding borders to cells
Using Autoformat
Number and date Formats
Creating styles
Applying styles
Modifying Styles
Using conditional formatting

Formulas

How formulas work
About cell references
About Excel ranges
Overview of functions
Using the AutoSum facility
Using the formula palette
Using conditionals
Statistical functions
Financial functions
Creating external references

Charts

Creating a chart
Setting chart options
Editing chart elements
Editing chart data
Adding logos and graphics
Printing charts

Productivity

Creating reports
Setting print options
Creating custom lists
AutoCorrect
Password protecting documents
Protecting worksheets
Using hyperlinks
Save As Web Page
Web Page Preview