Excel Expert

Excel Expert

Objective: To give users an extended knowledge of Excel’s advanced features. Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.

Delegates: Maximum 8
This course is suitable for existing users of Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time. Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an “Excel Advanced” course or from a user environment. Delegate numbers are restricted to 8, to ensure personal attention from the trainer.

Structure: PC for every delegate All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.

Duration: 1 day 9.30 am – 4.30 pm
Course Outline:


Excel Expert
· Review Exercise

Auditing a Worksheet
· Using Worksheet Auditing Tools
· Data Entry Validation
· Validating the Whole Worksheet
· Auditing Data Dependency
· Finding and Replacing Data

Working with Data Lists
· Setting Up Lists
· Sorting Lists
· Filtering Lists
· Using Forms

Data Management
· Searching for Data with Advanced Filters
· Compiling Consolidations
· Summarising Data with Outlines
· Querying a Database
· Data Sources
· Controlling Formatting and Layout
· Refreshing External Data

PivotTables
· Creating a PivotTable
· Modifying a PivotTable
· Creating a PivotTable Chart
· Creating Interactive PivotTables for the Web

Using Analysis Tools
· Goal Seeking
· Using Solver
· The Scenario Manager
· Scenario Summaries
· Merging Scenarios

Collaborating with Workgroups
· Applying Worksheet Protection
· Password Protecting a File
· Changing Workbook Properties
· Adding Comments to the Worksheet
· Shared Workbooks
· Tracking Changes
· Resolving Conflicts
· Merging Workbooks
· E-mailing Workbooks for Review


Fee £220+ VAT