Build a Smart Dashboard with Pivot Charts

This is an online self-paced course that will take you through best practices and tips for building smart dashboards with Pivot Chart

The Course will take you through a robust methodology for building dashboards with Pivot Charts. The methodology if implemented as taught will save you significant time in building dashboards with Pivot Charts. This is not a Basic Excel course, it assumes that students have a basic understanding of Excel especially as it relates to the topics listed below.

Course curriculum

    1. Requirements & How to Complete the Course

      FREE PREVIEW

    2. How to use the Platform

      FREE PREVIEW

    3. Course Overview

      FREE PREVIEW

    4. Before we Begin

    1. Download Exercise File

    2. Planning your Pivot Chart Dashboard Build

    3. Building a Simple Chart Based on a Plan

    4. Adding Data Labels to your Pivot Chart

    5. Inserting Modifying Slicers in Pivot Charts

    6. Comparing Monthly Performance with Pivot Charts

    7. Smart Formatting Tricks for Pivot Charts

    8. Finalising your Pivot Chart Dashboard

    9. Using AI for extract insights from your Data

    1. Instructions

    2. Before you go...

    1. 50 Excel Keyboard Shortcuts for Windows

    2. 50 Excel Keyboard Shortcuts for Mac

About this course

  • $30.00
  • 17 lessons
  • 0.5 hours of video content

Learning Outcomes

This not a basic excel course, participants are required to pass our Excel Proficiency Test before attending the course.

  • Automate any report with Pivot Chart

  • Build interesting dashboards

Some of our Clients

Instructor

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.