Microsoft Excel Training Course 2003 Intermediate

Overview and objectives of the Microsoft Excel Training Course

On the Intermediate  Excel Training Course you will learn to work with multiple workbooks and worksheets, sort lists using complex criteria, create complex logical statements and create advanced graphs (charts)

Who is this Microsoft Excel Training Course for?

If you want to develop your skills to create more complex formulas and list management.

Microsoft Excel Training Course prerequisites

It is recommended that you attend the Introduction Excel training course prior to attending this course

Microsoft Excel Training Course Contents

List (Database) Management in Microsoft Excel

Create a database, Use the Data  Form to enter  view, sort and delete records. Apply single and multi-level sorts, Apply Filters to the database using the Auto-Filter Facility

Formatting Cells in Microsoft Excel

Apply borders and shading, AutoFormat

Viewing a Large Worksheet in Microsoft Excel

Navigate to a named range or specific cell  , Split and Freeze a worksheet , work with multiple windows, Hide and unhide workbooks, worksheets, columns & rows.

Managing Worksheets in Microsoft Excel

Switch between worksheets, Enter on multiple worksheets, Copy data from worksheets and workbooks, Insert & delete worksheets, Move & copy a worksheet, Rename  and change the colour of a worksheet tab.

Linking Worksheets and Workbooks in Microsoft Excel

Link worksheets and workbooks, Summarise data using 3D references, Manipulate data with Paste Special, Update linked workbooks

Logical and Nested Functions in Microsoft Excel