This course covers Pivot Tables, arguably the most useful, yet underutilized tool in Excel. To paraphrase Queen, you will become a “PivotTable Wizard!
- Introduction to PivotTables (collapsing and expanding fields, sorting data, drilling down, etc.)
- How to automatically update PivotTables
- How to filter data
- Creating Calculated Fields and Calculated Items
- Using Slicers, Filters, and Timelines to quickly analyze data
- How to create a Pivot Table from multiple worksheets and workbooks
- Much more!
Who Will Benefit?
Any professional that uses Microsoft Excel.