Microsoft Excel 2013 Advanced: PivotTables
PivotTables combine all of the best Data Tools: Sort, Filter, and Subtotal. This lesson teaches how to summarize data in an interactive PivotTable in Microsoft Excel 2013.

If you wish to prepare students for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you teach the skills and knowledge your students need:

This course includes:
• Step-by-step video demonstrations (MP4)
• Companion eBook with detailed instructions (PDF)
• Sample spreadsheets and files
• Practice, Quizzes and Skill Test

With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Excel 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market.

If you are interested in Microsoft Excel 2013, here are some resources you may consider:
Microsoft Excel 2013 Beginning
Microsoft Excel 2013 Beginning: It All Adds Up
Microsoft Excel 2013 Beginning: A Question of Balance
Microsoft Excel 2013 Beginning: Chart and Chart Tools

Microsoft Excel 2013 Intermediate
Microsoft Excel 2013 Intermediate: Create a Price Sheet
Microsoft Excel 2013 Intermediate: Legs, Eggs and Pigs
Microsoft Excel 2013 Intermediate: Text and Date Formulas
Microsoft Excel 2013 Intermediate: Using Lookup Tables
Microsoft Excel 2013 Intermediate: Using Named Ranges
Microsoft Excel 2013 Intermediate: In Print
Microsoft Excel 2013 Intermediate: Online

Microsoft Excel 2013 Advanced
Microsoft Excel 2013 Advanced: Tables
Microsoft Excel 2013 Advanced: PivotTables
Microsoft Excel 2013 Advanced: PivotCharts



(25% off)

Save for later
  • AdvancedExcel2013-PivotTables.pdf
  • Excel_Advanced_2013_PivotTables.mp4
  • Customer-Sales-2013.xlsx
  • Customer-Sales-2013-COMPLETED.xlsx
  • Brown-Bag-Lunch-Sales-Team.xlsx

About this resource


Created: Mar 20, 2016

Updated: Feb 22, 2018


pdf, 18 MB



mp4, 58 MB



xlsx, 83 KB


Report a problem

Tes Paid License

How can I re-use this?