Microsoft Excel: Pivot Like a Pro
Summarize Data with Pivot Tables & Charts
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.
Understanding Data Tables
Sorting & Filtering Data
Adding New Data
Using a Total Row
Creating PivotTables & PivotCharts
Inserting Slicers & Timelines