Excel PivotTables: Building Dashboards

Level: Intermediate
Rating: 4.6/5 4.62/5 Based on 116 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

BLENDED LEARNING

On-Demand & Live Review Session

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

Standard £500/ Year

ADD TO CART

PRODUCT #70B8

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.

On-Demand & Live Review Session

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.

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

Please Choose a Language

Canada - English

Canada - Français