Webcast: Data Visualization with Excel (XCDVEX17)
Tell a Friend About This EventTell a Friend
 

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.

7/21/2017
When: 07/21/2017
10:30 AM until 12:30 PM
Where: Webcast
CALCPA
4173134A
United States
Presenter: Jeff S. Lenning, CPA, CITP


Online registration is closed.
« Go to Upcoming Event List  

Acronym XCDVEX17
CPE 2 hours
Vendor CalCPA
Category
Management
Level Overview
Prerequisite None
Adv Prep None
Yellow Book? No
Designed for Accountants using Excel for Windows.
Registration
Member $60
CPA Non-Member $94

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course 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.

Materials are provided as an ebook.

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