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.
Microsoft Excel - Pivot Tables - 2019-365
Microsoft Excel - Pivot Tables - 2019-365
Summarize and explore large datasets quickly using Excel’s Pivot Table tools.
- 4.6 565 reviews
- 19h study time
- 3h 12m video
- 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
Sourcing Your Data
- 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. Using Excel Ranges Choosing between building quick and dirty PivotTables or future-proofing PivotTables for future updates. 5m View lesson
- 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. Using External Data Connecting to external data sources (such as databases), and pulling the data into Excel. 5m View lesson
- 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
Laying Out the PivotTable
- 1. Totals and Sub-Totals Use to turn totals and subtotals on/off where needed in your PivotTable. 5m View lesson
- 2. Choosing PivotTable Layouts Determining the basic layout you’d like to use to display your PivotTable data. 4m View lesson
- 3. Grouping Use to group different row or column fields together for a more logical display. 5m View lesson
PivotTable Calculations
- 1. Aggregation When you wish to show different aggregation on your PivotTable fields than what is provided by default. 4m View lesson
- 2. Running Totals When you need to display a running total on your PivotTable. 5m View lesson
- 3. Percent of x Calculations When you need to display a value as the % of another value on your PivotTable. 6m View lesson
- 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. 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. 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. Calculated Fields Understanding how to create calculated fields in a PivotTable. 6m View lesson
- 8. Calculated Items Understanding how to create calculated items in a PivotTable. 5m View lesson
PivotTable Formatting
- 1. Value Field Formats Various ways to display numbers in the values area of a PivotTable. 4m View lesson
- 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. PivotTable Styles Using pre-defined styles with a PivotTable. 2m View lesson
- 4. Custom PivotTable Styles Creating your own style to use with a PivotTable. 5m View lesson
- 5. Conditional Formatting on PivotTables Basics of applying conditional formats to a PivotTable. 4m View lesson
Sorting
- 1. Basic Sorting Basic sorting of row and column headers in a PivotTable. 3m View lesson
- 2. Custom Sorting Creating custom sort orders for a PivotTable. 4m View lesson
- 3. Sorting Values Sorting the values area of a PivotTable. 4m View lesson
Filtering Data
- 1. Report Filters Using Report Filters to narrow down results in a PivotTable. 4m View lesson
- 2. Built-in Filter Controls Using row and column filters to narrow down results in a PivotTable. 5m View lesson
- 3. Slicers Slicers are user-friendly filters for PivotTables. 5m View lesson
- 4. Timelines Timelines are date specific filters for PivotTables. 3m View lesson
- 5. Filtering Multiple PivotTables Filtering multiple PivotTables at once with Slicers. 4m View lesson
Extracting Data
- 1. Show Details Using Show Details to extract details from a summarized value. 4m View lesson
- 2. GETPIVOTDATA Using the GETPIVOTDATA function to extract specific fields from a PivotTable. 4m View lesson
Data Visualization
- 1. Creating PivotCharts Creating PivotCharts out of a PivotTable. 4m View lesson
Finalization
- 1. Automating Refresh Automating PivotTable refresh operations. 6m View lesson
- 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
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.
The reviews are in
See what other learners think of our courses
-
“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!”
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.
How do I track my progress?
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.
Can I use GoSkills for team training?
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.
What if I need help?
Our support team is available at support@goskills.com for questions about your account or the platform. Reach out anytime!