Who Should Attend: Existing users of the product who wish to build on the essential skills covered in the Getting Started course.

Pre-requisites: The ability to create a spreadsheet with simple formula and differentiate between relative and absolute cell addresses.

Course Objectives: At the end of the course you will be able to create and edit charts based on existing data. Produce templates which include formulae and formats. Record and play macros. Update information across multiple sheets and workbooks.

Course Content
Charting: Learn how to create and edit charts from your Excel data. Add titles and trend lines to the chart.

Date Functions: Discover how to create calculations using the date.

Worksheets and Workbooks: Link data from sheet to sheet and workbook to workbook. Insert Excel data into Powerpoint presentations and Word documents. Copy and move a worksheet from one workbook to another. Save a workspace.

Templates: Create and edit a template which includes formats, formulae and labels. Create a new file based on the template.

Formatting Cells: Use Conditional formatting to apply formatting to cells when a condition is true. Set Data validation on cells. Protect cells within the spreadsheet and Password protect the workbook.

Macros: Record and play a macro. Assign the macro to a toolbar button, a keyboard shortcut and a shape.

Customising Toolbars: Create and edit a custom toolbar with frequently used features.

Related courses
Excel Advanced
Getting Started with Word
Adobe Acrobat
Getting Started with PowerPoint