Mobile Edition


Data Visualization with Excel (4173134B)

 
Date:Monday, December 18, 2017
Time:11:30AM - 1:30 PM
(Registration at 11:00AM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Jeff S. Lenning
Vendor:California CPA Education Foundation
Course Level:Overview
Early Bird Price:$60.00 FICPA Members, $90.00 Non-Members

Description:

Excel has many features that allow us to communicate information graphically. In this session, explore several of these data visualization capabilities. Start by discussing best practices in building charts, then explore features in Excel that help us communicate information graphically, including Sparklines, conditional formatting and PivotCharts. Course is presented in Excel for Windows.

Note: Certain items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.



Objectives:
  • Identify the feature that can create a one-cell chart.
  • Recall the steps to use conditional formatting to create bar charts.
  • Identify the feature that plots the values displayed in a PivotTable.


Major Topics:
  • Sparklines
  • Conditional formatting
  • PivotCharts


Who Should Attend:

Accountants using Excel for Windows.



Prerequisite:
None.

Advanced Preparation:
None.

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.