Excel Data Visualisation and Dashboards
Short course
In Jersey Guernsey (UK Offshore Dependencies), London and Manchester
Description
-
Type
Short course
-
Level
Intermediate
-
Location
-
Duration
1 Day
Excel Dashboards summarizes and presents the most important information of large data in attractive, easy-to-read charts, graphs, tables and pivots. It highlights the key trends so the most useful data insights could be interpreted in a matter of seconds. Management descisions are based on the information provided by these visuals.
Facilities
Location
Start date
Start date
Start date
Start date
About this course
To create attractive and insightful data charts and dashboards.
Data people. Excel users who analyse data with Excel or create management reports. Excel users who want to analyze large data sets.
You should have a basic working knowledge of Excel.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Excel
- Data Mining
- Data Collection
- MS Excel
- Visualisation
- Dashboards and servicing reports
- Graphs
- Charts
- Data Analytics
- Dashboards
Teachers and trainers (1)
Sarah Barnard
Coder, Instructor
Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.
Course programme
Introduction
Activating Power Pivot in Excel
Browse, Filter and Sort PowerPivot Data
PowerPivot Menu Options
The AutoSum Function in Power Pivot
Creating Pivot Tables with PowerPivot Data
Creating PivotTables
Changing the Method of Calculation
Pivot Table Calculations
Filtering with Slicers
PivotTable Filters and Slicers
Filtering PivotTables and PivotCharts
Creating Hierarchies
Excel techniques that are essential for Dashboards:
Offset
Lookup formulae (Vlookup, Hlookup, Match, Index)
Conditional formulae (If, Countifs, And, Or, etc.)
Aggregate formulae
Advanced filters to organise columns and filter rows
Visuals
Sparklines
Charting: Pie, Line, Area, Column, Scatter, Bar charts,
Charting: Axes, 2D, 3D chart elements, Sizing of charts
Charting: Formatting of charts
Create dashboard heat maps and other shapes
Conditional Formatting
Highlight top and bottom products/ people etc
Excel Dashboard Tips and Tricks including
Adding inter-activity
Forms and controls (for drop down lists to choose what you are comparing)
Linking cells to a text box
Linking cells to chart labels
Linking dynamically to changing ranges and values
Create Relationships with PowerPivot Data
Create Relationships to Master Data
Create PivotTables with Table Relationships
Refreshing Dashboards inline with changing data
What is included:
Laptops and data for the course. Let us know beforehand if you would like to bring your own
Excel Course Certificate on completion (assessment based)
Excel Course notes
Practical Class exercises, Excel Course Homework
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online via Skype or Teamviewer.
Max group size is 4.
Excel Data Visualisation and Dashboards