Skip to main content

Microsoft Excel - Pivot Tables - 2019-365

Microsoft Excel - Pivot Tables - 2019-365

Taught by Ken Puls

Summarize and explore large datasets quickly using Excel’s Pivot Table tools.

Get started
  • Get an accredited certificate
  • 14-day money-back guarantee

About this course

New to Pivot Tables or want to get more out of them? This online course is designed to give you a solid understanding of Pivot Tables, taking you from novice to ninja!

Pivot Tables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable way.

In 38 engaging lessons you will learn best practices for preparing source data, using database data, how to preserve formats and create custom styles, sorting and filtering techniques, and much more.

Whether you use Excel for work or study, these tutorials will start you on your journey to becoming a Pivot Tables Ninja! Learn more about how a GoSkills Excel certification can boost your career.

The course is Excel 2016, 2019 and Microsoft 365 compliant (previously known as Office 365), so you can choose the version that works best for you.

If you’d like to learn more about Excel try our Basic, Advanced or Basic and Advanced Excel courses.

Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

Syllabus

10 sections · 38 lessons · 3h 12m total

Download syllabus

The Very Basics 4 lessons · 18m

  1. 1. What is a PivotTable - and Why Do You Care? PivotTables open up your world to quickly summarize data and build solutions that others can explore. 4m View lesson
  2. 2. The PivotTable Life Cycle Understanding how the life cycle of a PivotTable solution is different than an ad-hoc reporting solution. 4m View lesson
  3. 3. Creating Your First PivotTable Creating your first PivotTable is the first step to unlocking serious Excel power in data optimization. 5m View lesson
  4. 4. Field Well Options Determining the Field Well options you’d like to use to view your PivotTable data. 4m View lesson

  1. 1. Source Data Best Practices Setting up your data sets to ensure that they will be able to be consumed by a PivotTable. 4m View lesson
  2. 2. Using Excel Ranges Choosing between building quick and dirty PivotTables or future-proofing PivotTables for future updates. 5m View lesson
  3. 3. Preparing Source Data When you need to aggregate multiple tables or create new fields in order to display properly in a PivotTable. 5m View lesson
  4. 4. Using External Data Connecting to external data sources (such as databases), and pulling the data into Excel. 5m View lesson
  5. 5. Managing Power Queries Updating a Power Query solution to a new file path, allowing us to refresh the file with a click. 4m View lesson

  1. 1. Totals and Sub-Totals Use to turn totals and subtotals on/off where needed in your PivotTable. 5m View lesson
  2. 2. Choosing PivotTable Layouts Determining the basic layout you’d like to use to display your PivotTable data. 4m View lesson
  3. 3. Grouping Use to group different row or column fields together for a more logical display. 5m View lesson

  1. 1. Aggregation When you wish to show different aggregation on your PivotTable fields than what is provided by default. 4m View lesson
  2. 2. Running Totals When you need to display a running total on your PivotTable. 5m View lesson
  3. 3. Percent of x Calculations When you need to display a value as the % of another value on your PivotTable. 6m View lesson
  4. 4. Difference From Calculations When you need to display values that are a difference from another value in a PivotTable. This is very useful for showing growth/decline from previous periods. 4m View lesson
  5. 5. Percentage Difference From Calculations When you need to display values that are a percentage of difference from another value in a Pivot Table.  This is very useful for showing growth/decline from previous periods. 4m View lesson
  6. 6. Top and Bottom x Items When you want to filter your PivotTable to show the top/bottom x items or top/bottom x% of items in the data set. 4m View lesson
  7. 7. Calculated Fields Understanding how to create calculated fields in a PivotTable. 6m View lesson
  8. 8. Calculated Items Understanding how to create calculated items in a PivotTable. 5m View lesson

  1. 1. Value Field Formats Various ways to display numbers in the values area of a PivotTable. 4m View lesson
  2. 2. Preserving Cell Formats on Update How to force a PivotTable to preserve cell formats and column widths when it is updated. 3m View lesson
  3. 3. PivotTable Styles Using pre-defined styles with a PivotTable. 2m View lesson
  4. 4. Custom PivotTable Styles Creating your own style to use with a PivotTable. 5m View lesson
  5. 5. Conditional Formatting on PivotTables Basics of applying conditional formats to a PivotTable. 4m View lesson

  1. 1. Basic Sorting Basic sorting of row and column headers in a PivotTable. 3m View lesson
  2. 2. Custom Sorting Creating custom sort orders for a PivotTable. 4m View lesson
  3. 3. Sorting Values Sorting the values area of a PivotTable. 4m View lesson

  1. 1. Report Filters Using Report Filters to narrow down results in a PivotTable. 4m View lesson
  2. 2. Built-in Filter Controls Using row and column filters to narrow down results in a PivotTable. 5m View lesson
  3. 3. Slicers Slicers are user-friendly filters for PivotTables. 5m View lesson
  4. 4. Timelines Timelines are date specific filters for PivotTables. 3m View lesson
  5. 5. Filtering Multiple PivotTables Filtering multiple PivotTables at once with Slicers. 4m View lesson

  1. 1. Show Details Using Show Details to extract details from a summarized value. 4m View lesson
  2. 2. GETPIVOTDATA Using the GETPIVOTDATA function to extract specific fields from a PivotTable. 4m View lesson

  1. 1. Creating PivotCharts Creating PivotCharts out of a PivotTable. 4m View lesson

  1. 1. Automating Refresh Automating PivotTable refresh operations. 6m View lesson
  2. 2. Pre-release Considerations Items to consider before releasing your file to users. 6m View lesson

Time to humblebrag

Complete the course and pass the final test to get a verifiable CPD-accredited certificate

Share on LinkedIn

Add your certificate to your profile in one click, and let recruiters and managers see your new skills.

  • CPD accredited
  • Verifiable online
Sample GoSkills certificate of completion

Taught by Ken Puls

Ken Puls is a globally recognized authority in Microsoft Excel, Power Query, and Power BI, with over two decades of hands-on experience in accounting, IT, and business intelligence systems. His career began in public practice accounting and industry, where he served as both Controller and IT Director, leading numerous system implementations and designing custom business intelligence solutions from the ground up.

Ken’s deep technical expertise is matched by a passion for teaching and community engagement. He has authored several acclaimed books, including RibbonX – Customizing the Office 2007 Ribbon, Power Query Recipes, and Master Your Data with Power Query in Excel and Power BI. His writing reflects a clear, practical approach to solving real-world data challenges.

Read more

The reviews are in

See what other learners think of our courses

4.6
Based on 565 learner reviews
See all reviews
  • “Very good Learning website,love this and the Course was very good”
  • “Great course to learn everything of Pivot Tables ”
  • “Wow! This was a great course. Appreciated the clear manor of each lesson. Very good way to gain exposure to pivot tables and how they work. Thank you!”
Chris Sanchez, GoSkills learner
I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth.
Chris Sanchez GoSkills learner

Your questions, answered

Frequently asked questions

We’ve compiled the most important information to help you get the most out of your experience. Can’t find what you’re looking for? Contact us.

Does my membership include other courses?

Yes. A GoSkills plan gives access to the full course library, not just this course.

You sure can. As a learner, you can sign up for a 7-day free trial here. If you’re training your organization, you can also start with a free plan here.

Your dashboard shows which lessons you’ve completed and how far you are through each course, so you always know where to pick up next.

Yep! With a business account, you can access the full course library along with the GoSkills LMS where you can assign courses, track team progress and report on results from one dashboard. Learn more about GoSkills for teams here.

Our support team is available at support@goskills.com for questions about your account or the platform. Reach out anytime!