Excel - Create KPI Dashboards for Maximum Impact Webinar

Feb 19
3:00 - 5:00 p.m.

Online

2-Other
CPE Credits

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

Highlights

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

Registration

PICPA Member: $79
Nonmember: $104

More Information

Course No. OX142W-021918 Level: Intermediate

Prerequisites: Excel Data Analysis Series Part 2 - Data Gathering

Speaker(s)

Bryan Smith