Data Visualization With Excel

Course Details

Date

Thursday, August 22, 2019

7:00am – 9:00am
(Registration: 6:30am)

Field of Study

Technology

Course Number

4193134A

CPE Credit

2.0 hours CPE credit

Level of Knowledge

Overview

Vendor

CalCPA Education Foundation

Prerequisites

None.

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.

Highlights

  • Sparklines
  • Conditional formatting
  • PivotCharts

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.

Designed For

CPAs, accountants and financial professionals.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$60.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$94.00
Your Price $94.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts