This is one-day course builds on the skills and concepts
taught in Excel 2010 to Advanced level. It is designed
as a bespoke course to
focus on specific specialised areas of a client's work
and covers topics, concepts and techniques required for
expert Excel users.
Description:
A typical Power
User course develops expertise in areas such as complex
formulas, functions, arrays, data analysis, dynamic
charts, dashboards, business modelling, business
intelligence, handling Big data and other techniques and
concepts for Excel expert users and for Excel developers.
Various analysis tools such as Wizards, problem
models, methods for correlating data, Power Pivot, advanced
customisation techniques, interactive controls and
automating selected features are often included at this
level.
Contact us for further details.
An Excel Power User course can cover an extensive
range of topics, techniques and concepts; the following are examples:
Advanced formulas, functions, and arrays
Text
functions
Date and time functions
Information
functions
Array formulas
Advanced editing and
formatting
Merging styles
Additional chart
formatting
Analysing and sharing information
Add-ins
Solver models and reports
Analysis ToolPak
Embedding and linking
Advanced customisation
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
Power Pivot for handling Big Data
VBA for
Excel
... a range of further topics can be covered to meet
your business needs and training requirements.
Contact us to
discuss you requirements for a Power User course.
Before taking this course, you should have equivalent experience of Excel to Advanced level