November 29, 2022


Webinar


2 CPE

Excel - Create KPI Dashboards for Maximum Impact

November 29, 2022
Webinar
2 CPE

Excel - Create KPI Dashboards for Maximum Impact

Learning Objectives

After completing this class you will have the ability to...

  • Understand how you can make strategic decisions based on dashboards
  • Create KPI dashboards
  • Use various Excel tools to easily create meaningful KPI dashboards

Major Topics

The major topics that will be covered in this class include:

  • Dashboard design guidelines
  • Setting up a Data Model
  • Creating calculated fields and columns
  • Creating KPIs
  • Adding a linked table to the data model
  • Creating PivotTables and PivotCharts
  • Adding Power View visualizations
  • Reviewing the completed dashboard

CPE Credits Available

2 CPE
2
Other

Things to Know About This Course

Course Level

  • Intermediate

Prerequisites

Excel Data Analysis Series Part 2 - Data Gathering

Advanced Preparation

None

Intended Audience

Anyone who wants to use Excel to make strategic decisions

Provider

CPA Crossings

This event has ended.