Data Visualization With Excel
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.
- Conditional formatting
- 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.
CPAs, accountants and financial professionals.
Applicable if you are a HSCPA member in good standing.
Applicable if you are not a HSCPA member.