Excel Advanced 2003

This course is for anyone who wishes to become an expert user of Excel.

Aims

By the end of this online course you will be confident in using Excel to an advanced level.

What you will learn

This course will cover the following topics:

Editing: Range names; Formatting cells; Conditional formatting; Importing data; Freezing and hiding rows and columns; Subtotals; Data tables; Protecting your work.
Sorting and Linking: Sorting; Filters; Linking worksheets and workbooks; Linking with Word.
Templates and Charts: Templates; Chart graphics; Chart options.
Functions: Date and time functions; Mathematical functions; Statistical functions; Text functions; Financial functions.

More Functions: Lookup and reference functions; Logical functions; Database functions.
Analysis: Pivot tables; Scenarios; Auditing a worksheet.
Special Tools: Macros; Assigning a macro to a button.

Requirements

Delegates must be confident in using a keyboard, Windows and a mouse, and in the basic features of Excel.

How the online course works

The online modules are structured as follows:

How it works

Here you can find out about how our lessons are structured, the style of training we use, and guidance on some of the features you will find in our lessons.

Course materials

Here you will find the manual and the demo files you need to complete the lessons.

Complete the preassessments

Here you can choose a preassessment to assess which lessons you need to take. The preassessments can be taken in any order you wish.

Start lessons

Here you will find the full list of lessons for that module.

Your learning plan

Here you will find lessons that have been added to a structured plan for you based on the results of the preassessments. You can also manually add and remove lessons from this plan.