An Intermediate Excel program focused on summarizing data with Pivot Tables and Pivot Charts, including an introduction to creating your own Excel Dashboards. These powerful tools SAVE HOURS of manual calculations when you get them set up to work for you each reporting cycle. We'll start with table best practices and move into pivoting, charting, and dashboard setup with slicers and timelines. A valuable course for anyone managing large sets of data that require ongoing analysis.
We will learn to:
- Understand Data Tables
- Sort & Filter Data
- Add New Data
- Use a Total Row
- Create PivotTables & PivotCharts
- Insert Slicers & Timelines
Speaker: Dawn Monroe
Recertification Points: 1
Branch Director: Pat Zimmerer | pzimmerer@verizon.net
Hosted by the Denton Branch, a part of the Texas / Louisiana Region.
