Welcome to TechMentor’s Excel PivotTables course
This course is about the basics, tips and tricks, and some advanced features of Excel PivotTables.
Upon completion of this course, you will be able to:
- Describe what a PivotTable is and how it can help you
- Create a PivotTable from Excel data
- Change PivotTable calculations
- Drill down on a summary calculation to see its underlying details
- Create a PivotChart from Excel data
- Sort, group, and filter your PivotTables and PivotCharts
- Create and use slicers to make your PivotTables and PivotCharts more interactive
- Add and remove totals and subtotals
- Change report layouts
- Enhance your report’s appearance with styles
To get an idea of everything covered, see the full course outline.
Downloadable Course Materials
- Exercise Files - Zip file with 42 exercise files - 7.9 mb
- TechMentors' Student Manual - 133 Page - 9.6 mb
- Support - If you have questions regarding this course please let us know.