Excel Dashboards and Data Visualization Course
Details
Dashboards will summarize and present the key indications of large data in an attractive visual display, highlighting the most important trends so the most important aspects of data could be seen in a snap second by glancing at attractive, colourful
charts.
PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data.
PowerPivot helps analyze and understand the growing quantities of data that are created on a daily basis.
Who should attend?
- Business users who analyse data with Excel or create management reports
- Excel users who want to analyze large data sets and also create relationships between tables
- Excel users who know how to Pivot Tables and Pivot Charts
- Excel users who wish to create interactive dashboards
- To use ours, arrange beforehand otherwise please bring your own.
- Excel Course Certificate on completion (assessment based)
- Excel Course notes, Class exercises, Excel Course Homework
- Tea, coffees, but no lunch
- After course free 1-hour question session via Skype or Teamviewer
- Max group size is 4.
Outline
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
PCWorkshops is a specialist provider of training courses in Java programming, databases and MS Project.
Customisation:- We can tailor courses. In addition, we are able to offer in-house training.
- What makes us different: all our Access Database, Excel, Word, Publisher, PowerPoint are offered as a standard on a 1-1 basis.
- The Excel VBA, Database Design, SQL, SSRS, SQL Report Builder and Java Courses are in groups of 4, but could also be 1-1.
- Software companies, testing companies,companies who employ software developers
- Coders and new coders who need Accredited Java qualification
- Data analysts and all others who use large sets of data
- Up-to-date relevant courses for todays’ business world
- Trainers with professional experience
- Award Winning Trainer
- 21 Years In Business
- Excellent Client References
- Classroom training with max class-size 4 people, virtual classrooms, 1-1 mentoring
- Customised training
- Assessment-based certificate, Oracle exam vouchers
- Weekdays, Evenings and Weekends
- At PCWorkshops, we love out job!
- MS Project Training.
- Database design and Data Normalisation.
- SQL Courses. ...