Microsoft Office and Accounts

Overview of New User Course

• List of Shortcuts and Tips from New User Course
• Overview of Percentages
• Absolute Cell Referencing recap using F4

Range Names

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

3D Spreadsheets

• Setting up worksheets
• Grouping worksheets
• Calculating multiple sheets
• Linking data from other spreadsheets
• Copying worksheets quickly and tips on copying to new spreadsheet

Advanced Functions

• Advanced Functions such as IF, IF(AND, IF(OR, Countif, VLookup, ISERROR, Data Calculations

Conditional Formatting

• Apply shading and formats to cells by setting up conditions.
• Creating Conditions using Formulae

Data Validation

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

Pivot Tables

• Create Pivot Tables
• Group Data in Pivot Tables
• Show Pages

Database Functions

• Working with the AutoFilter feature
• Advanced Filters
• Data Form
• Sub Totals

Scenario Manager

• Creating and saving Scenarios
• Editing Scenarios
• Comparing and running Scenario Reports

Advanced Charting

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

About SquareOne

Any SquareOne 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.

Course Objectives

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.  This is also suitable for existing users of Excel who have recently upgraded to 2007.  The course follows on from the New User course and is full of shortcuts and tips.

Course Details

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

Course Contents

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.