£95

Multiple Dates

Excel Dashboards and Data Visualization 1-Day Course, Birmingham

Actions and Detail Panel

£95

Event Information

Location

Location

One Victoria Square

Birmingham

B1 1BD

United Kingdom

View Map

Refund policy

Refund policy

No Refunds

Event description

Description

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.
Share with friends

Location

One Victoria Square

Birmingham

B1 1BD

United Kingdom

View Map

Refund policy

No Refunds

{ _('Organizer Image')}

Organiser PCWorkshops

Organiser of Excel Dashboards and Data Visualization 1-Day Course, Birmingham

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups szie that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and tecnologies.
  • Excellent trainers with professional experience.
  • We offer stress free training: we start at 11am, giving you time to attend toto the necessary emails etc. before starting.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
    • Tableau, MS Power BI, SSRS, and MS Excel Dashboards
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.
Our Java course outlines are aligned 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.

 

 

 

Save This Event

Event Saved