Excel PivotTables: Building Dashboards

Level: Intermediate
RATING: 4.6/5 4.60/5 Based on 166 Reviews

Microsoft Excel features a powerful set of tools for analysing data and creating dashboards. In this Excel PivotTable training course, you learn to visualise and glean critical insights from large data sets, and leverage Power Pivot for designing dashboards, creating sophisticated lookups across numerous datasets, and extending the capabilities of your Excel workbooks.

Key Features of this Excel PivotTables Training

  • Unlimited annual access to a library of on-demand courses
  • Unlimited retakes of our 1-day class for a year
  • Exclusive LinkedIn group membership for peer and SME community support

You Will Learn How To

  • Design a dashboard to improve data visualisations with Excel PivotTables
  • Analyse data with PivotTables and PivotCharts
  • Express KPIs with conditional formatting
  • Synchronise multiple data views with slicers

Certifications/Credits:

PMI 6 PDU

Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • Library of on-demand business professional courses
  • 1-day instructor-led training course
  • Exclusive LinkedIn group membership for peer and SME community support
View Course Details & Schedule

Standard £495

RESERVE SEAT

PRODUCT #4611

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organisation
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience

CONTACT US

Save More on Training with Learning Tree Training Vouchers!

Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.

In Class & Live, Online Training

  • AFTERNOON START: Attend these live courses online via Anyware

    26 Nov ( 1 Day)
    2:00 PM - 9:30 PM GMT
    Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 27 Mar ( 1 Day)
    9:00 AM - 4:30 PM GMT
    London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

  • 24 Jul ( 1 Day)
    9:00 AM - 4:30 PM BST
    London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

  • 19 Feb ( 1 Day)
    2:00 PM - 9:30 PM GMT
    Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 1 Apr ( 1 Day)
    2:00 PM - 9:30 PM BST
    Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 31 May ( 1 Day)
    2:00 PM - 9:30 PM BST
    Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 22 Jul ( 1 Day)
    2:00 PM - 9:30 PM BST
    Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 11 Sep ( 1 Day)
    2:00 PM - 9:30 PM BST
    Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 4 Nov ( 1 Day)
    2:00 PM - 9:30 PM GMT
    Online (AnyWare) Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Excel PivotTables Training Information

  • Excel Data Analysis Blended Training Description

    This product offers access to a library of Microsoft Office on-demand courses including Excel, Word, PowerPoint, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Excel PivotTables — Course 4611, Excel PivotTables: Building Dashboards.

On-Demand Training Outline

  • On-Demand Course List

    • Access 2016 Essentials
    • Excel 2016 Essentials
    • Excel 2016 Essentials for Mac
    • Excel 2016 Advanced
    • Excel Charts and PivotTables
    • Excel Functions
    • Relational Database Design
    • PowerPoint 2016
    • Advanced PowerPoint 2016
    • PowerPoint for Mac
    • Advanced PowerPoint for Mac
    • Outlook 2016
    • Outlook on the Web
    • Word 2016 Essentials
    • Word 2016 Advanced
    • Word 2016 Expert
    • Word 2016 Mail Merge
    • Word 2016 Essentials for Mac
    • Word 2016 Advanced for Mac
    • Word 2016 Expert for Mac
    • Word 2016 Mail Merge for Mac
    • End User Security Awareness
    • Skype for Business

Team Training

Excel PivotTables Training FAQs

  • What background do I need?

    Experience with Excel fundamentals at the level of Microsoft Excel Introduction • Course 1361.

  • What on-demand content will I receive?

    An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrolment period.

    How will I access my course materials if I choose this method?

    Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.

  • How can I sign up for a review session?

    Once you are enrolled in the program, specific details and dates will be sent to you.

Questions about which training is right for you?

call 0800 282 353
chat Live Chat




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition fee!
  • No advance payment required for most products.
  • Tuition fee can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

Online (AnyWare)
London / Online (AnyWare)
London / Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français