Log Out

Excel - Create KPI Dashboards for Maximum Impact

 
 Thursday, Feb. 28, 2019 from 12:30 pm to 2:30 pm
 Online
 
2.0
19 / 2-50716
Registration is Open
VSCPA Members
$79.00 Regular Registration
Nonmembers
$79.00 Regular Registration
Designed For:
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
Prerequisite:

Excel Data Analysis Series Part 2 - Data Gathering

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.

We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions either during or after the event.

Related Events

The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.

For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.