Visual Data with Excel Pivot Tables and Dashboards Course

Visual Data with Excel Pivot Tables 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

The course duration is 1 Day.

Visual Data with Excel Pivot Tables and Dashboards Course Description

Introduction:

Activating Power Pivot in Excel
Browse, Filter and Sort PowerPivot Data
PowerPivot Menu Options
The AutoSum Function in Power Pivot

Creating Excel Pivot Tables with Excel PowerPivot Data:

Creating PivotTables
Changing the Method of Calculation
Pivot Table Calculations
Filtering with Slicers
Excel PivotTable Filters and Slicers
Filtering Excel 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

Creating Visuals in Excel:

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 Excel cells to a text box
Linking cells to chart labels
Linking dynamically to changing ranges and values

Relationships:

Create Relationships with Excel PowerPivot Data
Create Relationships to Master Data
Create PivotTables with Table Relationships

Refreshing:

Refreshing Excel Dashboards in line with changing data

What is included in the Excel Courses:
  • Excel Course Certificate on completion (assessment based)
  • Excel Course notes
  • Practical Excel Course exercises, Excel Course Homework / Excel Course Revision work
  • Tea, coffees, but no lunch
  • To assist after the course, 1 free session for questions online Excel Course via Skype or Teamviewer.
  • Max group size on this Excel Course is 4.
LOCATIONS
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops Manchester
MANCHESTER: 53 Fountain Street, Manchester, M2 2AN
Read More
PCWorkshops Birmingham
BIRMINGHAM: One Victoria Square, Birmingham, B1 1BD
Read More
PCWorkshops Southend-on-Sea
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS
Read More
PCWorkshops Milton Keynes
MILTON KEYNES: Exchange House, 494 Midsummer Boulevard, Milton Keynes, MK9 2EA
Read More
PCWorkshops PORTSMOUTH
PORTSMOUTH: Building 1000, Lakeside North Harbour, Western Road, Portsmouth, PO6 3EZ
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More

Subscribe our Newsletter

Sign up to receive lessons, tips, examples, quizzes and other training materials.