This one-day course builds on the skills and concepts
taught in Excel 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
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:
Text
functions
Date and time functions
Information
functions
Advanced Lookup, Match, Index, Offset and other
functions
Array formulas
Merging styles
Additional chart
formatting
Tables
Add-ins
Solver models and reports
Analysis ToolPak
Embedding and linking
Popular and Save options
Formulas options
Automating Excel
Advanced options
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:
Funnel chart
Histogram
Pareto chart
Sunburst chart
Treemap chart
Waterfall chart
Box and whisker
chart
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 from 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,
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.
... a range of further topics can be covered to meet your business needs and training requirements.
Topics covered will vary slightly depending upon the version of Excel you are using, e.g 2007, 2010, 2013, 2016, 2019 or 365.
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
FILTER function
RANDARRAY function
SEQUENCE function
SINGLE function
SORT function
SORTBY function
UNIQUE function
Also new in Excel 365: Create a diagram in Excel 365 with the Visio Data Visualizer add-in
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.