/
/
/
/

Excel Dashboards and Data Visualization

(4.8)17 reviews
Recent reviews of this course provider

Pivot tables in 45 minutes

Excellent course. My teacher Sarah was really good and took me through how to cr...more

See all reviews
Add to shortlistShortlisted by 30 people

https://www.hotcourses.com/courses-by-subject/Excel-Dashboards-and-Data-Visualization-courses/56270490/

Course description

Excel Dashboards and Data Visualization:

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,
    • Axes,
    • 2D, 3D chart elements,
    • Sizing of charts
    • 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

Additional entry requirements

What are the pre-requisites? Knowledge of Excel 2010 / 2013 An understanding of Pivot Tables and Pivot Charts

Training for employers

This course has been specifically designed for companies training their employees.

Course info
277 views
Start Date: Fri 21st June 2019
START DATES
MAY 2019
Sun Mon Tue Wed Thu Fri Sat
JUNE 2019
Sun Mon Tue Wed Thu Fri Sat

Location:

Manchester, M1 5AN, Milton Keynes, MK9 2UB, London, WC2N 4JF, You study this on your computer

Time:

11:00am - 6:00pm, Any time

Duration:

1 day, By arrangement

Attendance:

Full time, Online

Qualification:

Qualification awarded by the course provider

Level:

Beginner IntermediateAdvanced

From: £350

Other Microsoft Excel courses

Excel Introduction Course, Private 1-to-1

PCWorkshops

Duration: Variable

Beginner

Course Provider Diploma/Certificate/Award

Excel Intermediate Course, Private 1-to-1

PCWorkshops

Duration: Variable

Intermediate

Course Provider Diploma/Certificate/Award

View 6 courses

Summary of all course reviews for PCWorkshops

17 reviews

(94%)
(6%)

Average student ranking

Reviews of other courses at PCWorkshops

pcworkshops

Pivot tables in 45 minutes
5 5
Hotcourses
December 2017

Excellent course. My teacher Sarah was really good and took me through how to create pivot tables step by step. She made it simple and straightforward. I can now create a pivot table with confidence. You also get a certificate of attendance. I would highly recommend this course to a friend. Sharmini Shanthakumar

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.

pcworkshops

Java taster
5 5
Hotcourses
December 2017

Sarah is an excellent mentor . She taught me well in such a short span of time and gave sufficient material to get a feeling of programming in Java. Thanks!! Rahul

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.

Please note reviews of Java Programming "Taster" Course, 1 Day are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Excel Dashboards and Data Visualization by PCWorkshops on Hotcourses

Ask a question

Get course info