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. Contact us for further details.
Advanced formulas, functions, and arrays
Date and time functions
Advanced editing and formatting
The Paste Special command
The Go To Special dialog box
Additional chart formatting
Analysing and sharing information
Solver models and reports
Statistical analysis tools
Embedding and linking
Popular and Save 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.