Microsoft Excel 2016 Power User Training Course Outline

Home PageTraining CoursesExcel Training Courses

Excel Training Courses This one-day course builds on the skills and concepts taught in Excel 2016 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 and a course will be designed to meet your needs:

Advanced formulas, functions, and arrays

Text functions
Date and time functions
Information functions
Advanced Lookup, Match, Index, Offset and other functions
Array formulas

Advanced editing and formatting

Merging styles
Additional chart formatting
Tables

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

Dashboards and Advanced Charts

Principles and concepts
Dynamic Charts
Data, analysis and presentation layers
Data Format
Advanced Chart Formatting and Combination Charts
Pivot Charts
Form Controls for Charts and Dashboards
New Charts available in Excel 2016:
Funnel chart
Histogram
Pareto chart
Sunburst chart
Treemap chart
Waterfall chart
Box and whisker chart

Power Tools

Power BI
Business Intelligence. Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices.

Power Pivot
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

Power View
Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting.

Power Map
Power Map is a 3D data visualization tool for Excel that provides an immersive experience for making discoveries in data that might never be seen in traditional 2D tables and charts. Power Map lets you plot geographic and temporal data visually, analyze that data in 3D, and create cinematic tours to share with others.

Power Query and Get & Transform
Power Query is known as Get & Transform in Excel 2016. Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources. With Get & Transform in Excel 2016, you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.

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

What's New in Excel 2016

Excel 2016 for Windows has all the functionality and features you're used to with some added features and enhancements and the best new features from Office 2016. Here are some of the top new and improved features for Excel 2016:

Six new chart types

Get and transform (Query)

New Functions

One click forecasting

3D Maps

PivotTable enhancements

Publish and share your analysis with Power BI

Quick Shape Formatting

Insert pictures with the correct orientation

Do things quickly with Tell Me

Insights into what you're working on

Ink Equations

Simpler sharing

 Improved version history

New themes

Data Loss Protection (DLP) in Excel

New Financial Templates

Take an Excel 2016 course to discover more!

Contact us for further information, to check available dates or to book a course.