Data Visualization with Excel
Monday, December 18, 2017
2CREDITSComputer Software and Applications
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.
- 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.
- Conditional formatting