YouTube: Innovative CPE Channel Listen to Our Customers, Preview Our Instructors, Stay On Top of Breaking News
Connect with Western CPE on Facebook Western CPE on Twitter Western CPE on LinkedIn
New in Self-Study
  • Mid-year Quick & Easy Tax Updates
    Just updated! From bestselling tax expert Vern Hoven comes the mid-year update to his Quick & Easy Tax Update series. These critical courses update all the major areas of tax and prepare you to server your clients more effectively.
Self-Study Editor's Pick
 
  Innovative Education

Phone:
(800) 822-4194
(406) 556-0115

Fax:
(206) 774-1285

E-mail: wcpe@westerncpe.com

243 Pegasus Drive
Bozeman, MT 59718

Office hours:
Monday - Friday
7 A.M. - 6 P.M. MST

Self-Study — Course Detail

links to other topics
Accounting & Auditing Computer Applications & Technology Corporate Finance
Management & HR Ethics Government & Nonprofit
Personal Development Professional Development Taxation
Taxation & Financial Planning

Excel Driven Dashboards


Patricia McCarthy
Copyright© 2013

Course: 2114528   Version 1304
NASBA Category:     Spec Knldg & Apps     CPE Credits 10
Level: Intermediate  (112 pages)
Prerequisite: Knowledge of how to create and format a simple chart and PivotTables are assumed, as is knowledge of simple formulas and functions.

Advance Preparation: Excel 2007 or 2010.



Course Description
A dashboard provides pertinent summary information to assist in management decision making. It is geared to emphasize areas of performance that managers are interested in. It essentially provides the analysis which allows the users to draw a quick conclusion based on the trends and comparisons shown. In this course we are focusing on using Excel to create an effective dashboard using Charts, Camera Tool, Conditional formatting, Data Validation and more. This course consists of an EBook and exercise files. This course assumes a good underlying knowledge base of Excel and a basic knowledge of chart creation as much of the course focuses on charting features.

*To access the practice files for this course, go to westerncpe.com, log in to your account, and click on “Order History.” Practice files are included under Downloadable Materials.

Table of Contents

Learning Objectives
Upon successful completion of this course, participants will be able to:
  • To improve analysis of key performance measurements through effective presentation of information using Excel.




Select   Format   Retail Price
  Online   $109.00   After purchasing this course, you may click here to log in and access the course material.
  Hard Copy   $109.00


Extra Tests:
Qty   Format   Retail Price
  Extra Exam Online   $40.00
  Extra Exam Hardcopy   $40.00

: : Privacy Policy : : Refund Policy : : Shipping Policy : :

Western CPE | Offering Continuing Professional Education (CPE) and Professional Development for Accountants and Financial Planning Professionals | Home

Photo of Beartooth Mountains courtesy of www.magicpixel.biz