UK training courses contact:
telephone: 01382 453447
email: mail@ictwizard.com




This one-day course builds on the skills and concepts taught in Excel 2007: Advanced.
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.
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
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:
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.
Excel 2010 Foundation
Excel 2010 Intermediate
Excel 2010 Advanced
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.
Microsoft Excel Training Courses in Aberdeen
Microsoft Excel Training Courses London
Microsoft Excel Training Courses in Edinburgh
Microsoft Excel Training Courses in Dundee
Microsoft Excel Training Courses in Perth
Microsoft Excel Training Courses in Inverness
Microsoft Excel Training Courses in Angus
Microsoft Excel Training Courses in Fife
Microsoft Excel Training Courses in Glasgow
... and at many more locations throughout the UK
Microsoft Access
Microsoft
Office 2010
VBA
Visio Courses
Microsoft
Office - all versions
Microsoft Outlook
SharePoint
Microsoft Project
Presentations
Microsoft PowerPoint
Internet
Word Courses
Introduction to Computing
Microsoft Publisher
Windows
Adobe Acrobat
Expression Web
InfoPath
OneNote
... and others

