Microsoft Excel 2010 Power User
Training Course Outline

1-day course

This one-day course builds on the skills and concepts taught in Excel 2010: Advanced and can be designed to focus on the specific specialised areas of a client's work.

Description:

This course teaches advanced users of Excel more complex formulas, functions, arrays, data analysis, dynamic charts, dashboards, business modelling, business intelligence and various techniques and concepts for the Excel developer.

Also covered are various analysis tools such as Wizards, problem models, methods for correlating data, advanced customisation techniques, interactive controls and automating selected features.

Typical course contents include (tailored to suit client):

Advanced formulas, functions, and arrays
Text functions
Date and time functions
Information functions
Array formulas

Advanced editing and formatting
The Paste Special command
The Go To Special dialog box
Merging styles
Additional chart formatting

Analysing and sharing information
Wizard add-ins
Solver models and reports
Statistical analysis tools
Embedding and linking

Advanced customization
Popular and Save options
Formulas options
Automating Excel
Advanced options

Advanced Charts and Dashboards
Principles and concepts
Data, analysis and presentation layers
Data Format
Advanced Chart Formatting and Combination Charts
Pivot Charts
Form Controls for Charts and Dashboards

A range of further topics after discussion with clients

Bespoke Excel Power User courses

We can design a Power User course to cover specialised Excel topics that meet your particular business needs. Expert and specialised courses and consultancy sessions can include many topics ranging from business modelling to arrays to Monte Carlo simulation. Contact us to discuss.

For further details, or to book a course, please contact us:
email: training@ictwizard.com
telephone: 01382 453447

Our courses are delivered by top-class trainers and consultants that are leaders in their field and meet our highest standards of experience, qualifications and ability.