Microsoft Excel 2010 Power User Training Course Outline

Home PageTraining CoursesExcel Training Courses


Excel Training Courses 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.

Prerequisites

Before taking this course, you should have equivalent experience of Excel to Advanced level