Microsoft Excel 2007 Power User
Training Course Outline

1-day course

This one-day course builds on the skills and concepts taught in Excel 2007: Advanced.

Description:

This course teaches advanced users of Excel more complex formulas, functions, and arrays, and covers more advanced editing and formatting options, such as using commands to copy validations and link data.

Students will learn about various analysis tools such as Wizards, problem models, and methods for correlating data. Finally, they will learn advanced customisation techniques by changing default settings and automating selected features.

Course Contents:

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

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.