CoursesWorkforce Training
Menu
    All Courses
  • Home
  • About Us
  • Workforce Training
  • Top Courses
  • Become a Partner
  • Affiliates
  • Education Providers
  • Contact Us
  • Careers
  • Terms of Use
  • Privacy Policy
  • Blog
  1. Home
  2. Microsoft
  3. Excel
  4. Short
  5. Excel Data Visualisation and Dashboards
Enquire Now

Excel Data Visualisation and Dashboards

Study Method
In-class
Locations
London, Milton Keynes, Portsmouth, Southend-on-Sea
Institution
PCWorkshops
Start Date
Multiple start dates available
Course Fees
£420
PCWorkshops Courses

Course overview

Dashboards will summarise 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 analyse the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot helps analyses and understand the growing quantities of data that are created on a daily basis.

Expand all and read more

Campus locations

  • London
  • Milton Keynes
  • Southend-on-Sea
  • Portsmouth

Study method

  • In-class
  • Blended
  • Online

Locations

  • England
    • London
    • Milton Keynes
    • Portsmouth
    • Southend-on-Sea
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 1 Day

Course features

  • Laptops and data for use during the course. To bring your own, arrange beforehand
  • Excel course certificate on completion (assessment based)
  • Excel course notes, class exercises, Excel course homework
  • After course free 1-hour question session via Skype or Teamviewer
  • Max group size is 4

Who's it for?

  • Business users who analyse data with Excel or create management reports
  • Excel users who want to analyse 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

Subjects

Core Units
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
Adding Interactivity
  • 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 With Master Data
  • Create PivotTables With Table Relationships
And more!
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £420

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.

Reviews
Trustpilot

Study method

  • In-class
  • Blended
  • Online

Locations

  • England
    • London
    • Milton Keynes
    • Portsmouth
    • Southend-on-Sea
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Want to know more about this course?
Complete the form and learn about:

  • Pricing and payment options
  • Start dates
  • Subjects
  • Study method
  • How to get help and contact information
  • Everything you need to know before enrolling!

Want to know more about this course?

Get your free course guide now! Complete this easy form and you'll receive a course guide and consultation from PCWorkshops

By submitting this enquiry I accept the "Privacy Policy" and "Terms of Use"

Receive a consultation from a course expert

See student testimonials below

avatar1
"I found the website easy to use and the contact I received after my enquiry was good. Not too pushy but there if I needed them." - Dimity G.
avatar2
"All details and info was there and my query was answered quickly." - Soula M.
avatar3
"Gave me everything I needed and someone called me, pretty much straight away." - Marlon T.

Popular Courses

  • Accounting Courses
  • Administration Courses
  • Bookkeeping Courses
  • Finance Courses
  • Business Management
  • Human Resources Courses 
  • Computer Courses
  • Cyber Security Courses
Copyright © 2020 Coursesonline.co.uk Contact About Privacy Terms Become a Partner Affiliates Blog Sitemap
VAT No: 301 5420 62 Company No: 11182409

Coursesonline.co.uk uses cookies. By continuing you are agreeing to our use of cookies. Learn more.

gdpr logo
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Additional Cookies

This website uses additional cookies to collect anonymous information such as the number of visitors to the site, and the most popular pages.

Keeping this cookie enabled helps us to improve our website.

Please enable Strictly Necessary Cookies first so that we can save your preferences!

Cookie Policy

More information about our Cookie Policy