Current Status
Not Enrolled
Price
$159.95
Get Started
or

Welcome to TechMentor’s Excel PivotTables course

This course is about the basics, tips and tricks, and some advanced features of Excel PivotTables.Ā  It includes:

  • 11 online lessons with step-by-step instructions
  • Multiple video demonstrations in each lessonĀ 
  • Downloadable exercise files
  • TechMentors’ 133-page PivotTable e-book
  • A 30-minute one-on-one Q&A sessions with a TechMentor
  • Additional one-on-one sessions at a discounted price – contact us to learn more

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.

 

Materials will be available after you enroll in the course.

Course Content

Expand All