Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Excel - Create KPI Dashboards for Maximum Impact CXOXLS142W2
View Registrations Tell a Friend About This EventTell a Friend
 

Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel.

11/4/2017
When: 9:30 AM to 11:30 AM
Where: Webinar/Webcast
United States
Presenter: Bryan L. Smith, CPA.CITP, CISA
Contact: April Deneault
801-466-8881
« Go to Upcoming Event List  

Office 365

Field of Study

Computer Software & Applications - Non-Technical

Credit:  2

Level:  Intermediate

Designed for:

Anyone who wants to use Excel to make strategic decisions

Objective

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

Description

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

 

Price:  $79.00

Link to register:  http://cpe.cpacrossings.com/CXOXLS142W2?partner=uacpa

Event Code:  8094

Keywords:

Data Presentation Kpi Dashboard Data Model Powerpivot Pivottable Power View Excel

Membership Management Software Powered by YourMembership  ::  Legal