Microsoft Excel

Intermediate/Advanced

Any Square One course can be tailored to meet the particular requirements of your organisation.
We will be happy to use any of your examples for delegates to ensure that the course is as interesting and relevant as possible.

This course is suitable for existing users of Excel who wish to improve their understanding of the package and produce powerful well presented spreadsheet models.

The course follows on from the New User course and is full of Shortcuts and Tips.

Duration: 2 Days
Timings:  9:30 - 16:30

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.

Booking

List of Shortcuts and Tips from
New User Course

Create Range Names
Navigate using Range Names
Print Range Name Areas
Create Formulae using Range Names

Use some of the more Advanced Functions such as IF and VLookup

Apply shading and formats to cells by setting up conditions

Setting up the restriction on how cells are input as dates, numbers, or time
Setting up cell entries as a list
Limit the characters of cell entries
Create Error Messages

Working with the AutoFilter feature
Advanced Filters
Data Form
Sub Totals

Creating and saving Scenarios
Editing Scenarios
Comparing and running Scenario Reports

Producing Charts using a Function Key
Changing the Chart Type
Formatting Charts
Adding Titles
Customising the Chart
Drawing on Charts