Skip Main Navigation
Page Content

Save This Event

Event Saved

Excel Dashboards and Data Visualization 1-Day Course, Milton Keynes

PCWorkshops

Thursday, 3 January 2019 from 11:00 to 18:00 (GMT)

Excel Dashboards and Data Visualization 1-Day Course,...
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Excel Dashboards and Data Visualization
Thanks for booking! Please call us on 020 7164 6359 or 07784 357309 to confirm your attendance. Keep the mobile number for your contact on the day.
1 Jan 2019 £380.00 £0.00
Excel Dashboards and Data Visualization, Advanced Booking
Please call us on 020 7164 6359 or 07784 357309 to confirm your attendance. Keep the mobile number for your contact on the day. Thanks for booking!
27 Dec 2018 £350.00 £0.00

Share Excel Dashboards and Data Visualization 1-Day Course, Milton Keynes

Event Details

EXCEL DATA VISUALISATION AND DASHBOARDS

COURSE SUMMARY

Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could 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. Power Pivot help 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

COURSE 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

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.
Do you have questions about Excel Dashboards and Data Visualization 1-Day Course, Milton Keynes? Contact PCWorkshops

Save This Event

Event Saved

When & Where


PCWorkshops at MWB Milton Keynes Regus
The Exchange House
494 Midsummer Boulevard
MK9 2UB Milton Keynes
United Kingdom

Thursday, 3 January 2019 from 11:00 to 18:00 (GMT)


  Add to my calendar

Organiser

PCWorkshops

  • PCWorkshops  is a specialist provider of training courses in Java programming, Databases and MS Project.

More about us:

Our up-to-date training courses are designed and delivered by registered, qualified instructors with a wealth of experience in software development and training.

The maximum class-size is normally 4.

Every one gets personalised attention.

Why learn with us at PCWorkshops:

Up-to-date relevant courses for todays’ business world

Trainers with professional experience

Award Winning Trainer

21 Years In Business

Excellent Client References

Assessment-based certificate, Oracle exam vouchers

Weekdays, Evenings and Weekends

At PCWorkshops, we love out job!

We offer Training Courses in Software Packages:

MS Project Training

Database design and Data Normalisation

SQL Courses

Data Analysis and Data visualtion courses

MS Excel, data analyses with Excel. Excel VBA

Access Database Courses.

Java Programming.

MS Office Training.

Our Style:

Relaxed, Practical, Useful

Methods of instruction:

Classroom training with max class-size 4 peopl

Virtual classrooms

1-1 mentoring

Customised training

Certification:

Our PCWorkshops certificates are assessment based.
Our course outlines are in-line with Oracle courses. We assist with exam prep for the presitigeous, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of data
Software companies, testing companies,companies who employ software developers
Coders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

  Contact the Organiser

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.