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. Contact us to discuss.

 

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

Our Excel courses include:

Excel 2007 Foundation

Excel 2007 Intermediate

Excel 2007 Advanced

Excel 2007 Power User

Excel 2003 Foundation 

Excel 2003 Intermediate 

Excel 2003 Advanced

Excel VBA

Bespoke Excel Training
We can design an Excel course to suit your requirements. Contact us to arrange a tailored Excel course.

 

ICT Wizard courses:

• on your site or locations throughout the UK
• Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
• delivered by Certified Master Instructors.