Microsoft Excel - Pivot Tables - From Novice to Ninja

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!

Microsoft Excel – Pivot Tables – From Novice to Ninja

Course Description

Pivot Tables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable way. In 36 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 Microsoft Excel 2010 and 2013 compliant. Video tutorials are recorded in Microsoft Excel 2013 for PC, and where the user interface is significantly different, Excel 2010 videos are provided too. If you’d like to learn more about Excel try our Basic, Advanced or Basic and Advanced Excel ... Read More »

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

In 36 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 Microsoft Excel 2010 and 2013 compliant. Video tutorials are recorded in Microsoft Excel 2013 for PC, and where the user interface is significantly different, Excel 2010 videos are provided too.

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

Read Less
Certificate Info:

Type of Certification

A Certificate of Training is awarded for completing all lessons within the course. An Accredited Certificate of Achievement is awarded if the learner passes the skills test at the end of the course. The skills test can be taken as many times as needed. The Certificate of Achievement will reflect the highest score achieved.

Format of Certification

Digital and Print

Professional Association/Affiliation

GoSkills is a member of the Continuing Professional Development Certification Service (CPD UK). GoSkills courses have been accredited by the CPD UK, which means that they meet the industry-wide guidelines for continuing professional development.

Method of Obtaining Certification

Once the learner has earned the certificate they can be downloaded from their GoSkills dashboard.  The certificates are in a pdf format, so they can be printed or emailed.  The certificate can also be added to LinkedIn if the learner has an account.

Additional Details

Upon successful completion of a course, the learner will earn Continuing Education Units (CEUs)
About Instructor:

Ken Puls - Excel MVP


Ken is a Certified Management Accountant (CMA) in Canada, who never remembers life without spreadsheets and computers! Since the late 1990s, he has spent his career in the hospitality and tourism industry, in the finance and IT fields. Ken is currently the Director of IT at a resort on Vancouver Island.

To this day, he dedicates a significant portion of his time to developing automated solutions and internal controls, as well as focusing time and energy on improving Business Intelligence systems. Through his work, he designs and develops new systems, using such technology as Excel spreadsheets and VBA (Excel's programming language), automating as many tasks as possible, and thereby saving significant costs and maximizing efficiencies. Ken says, “I love the power that Excel puts at my finger tips and I’m still amazed by the things it can do.”

Ken has worked as a freelance MS Office developer, mainly in Excel, but also with Access, Word and Outlook, and currently teaches courses whenever he can. Ken’s true passion lies with sharing his knowledge about Excel, and teaching people how to get the most from it.

Ken runs a popular site solely dedicated to Excel training. Even NASA has made use of it, using some of his PDFCreator examples to automate the production of PDF reports that monitor the power supply levels on the International Space Station!

Ken was awarded the prestigious Microsoft Most Valuable Professional – Excel award in 2006; a distinction he has won every year since! The Microsoft MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their high quality, real world expertise with others. In Microsoft's words, "MVPs are a highly select group of experts representing technology's best and brightest who share a deep commitment to community and a willingness to help others." Worldwide, there are over 100 million participants in technical communities; of these participants, there are fewer than 4000 active Microsoft MVPs. Of this pool of MVPs, fewer than 200 hold the distinction of MVP-Excel globally.


Course Outline

Pivot Tables open up your world to quickly summarize data and build solutions that others can explore.
Understanding how the life cycle of a Pivot Table solution is different than an ad-hoc reporting solution.
Creating your first Pivot Table is the first step to unlocking serious Excel power in data optimization.
Determining the Field Well options you’d like to use to view your Pivot Table data.
Setting up your data sets to ensure that they will be able to be consumed by a Pivot Table.
Choosing between building quick and dirty Pivot Tables or future proofing Pivot Tables for future update.
When you need to aggregate multiple tables or create new fields in order to display properly in a Pivot Table.
Pulling database data into Excel and Pivot Tables.
Use to turn totals and subtotals on/off where needed in your Pivot Table.
Determining the basic layout you’d like to use to display your Pivot Table data.
Use to group different row or column fields together for a more logical display.
When you wish to show different aggregation on your Pivot Table fields than what is provided by default.
When you need to display a running total on your Pivot Table.
When you need to display a value as the % of another value on your Pivot Table.
When you need to display values that are a difference from another value in a Pivot. This is very useful for showing growth/decline from previous periods.
When you need to display values that are a percentage of difference from another value in a Pivot. This is very useful for showing growth/decline from previous periods.
When you want to filter your Pivot Table to show the top/bottom x items or top/bottom x% of items in the data set.
Understanding how to create calculated fields in a Pivot Table.
Understanding how to create calculated items in a Pivot Table.
Various ways to display numbers in the values area of a Pivot Table.
How to force a Pivot Table to preserve cell formats and column widths when it is updated.
Using pre-defined styles with a Pivot Table.
Creating your own style to use with a Pivot Table.
Basics of applying conditional formats to a Pivot Table.
Basic sorting of row and column headers in a Pivot Table.
Creating Custom Sort Orders for a Pivot Table.
Sorting the values area of a Pivot Table.
Using Report Filters to narrow down results in a Pivot Table.
Using row and column filters to narrow down results in a Pivot Table.
Slicers are user-friendly filters for Pivot Tables.
Filtering multiple Pivot Tables at once with Slicers.
Using Show Details to extract details from a summarized value.
Using the GETPIVOTDATA function to extract specific fields from a Pivot Table.
Creating Pivot Charts out of a Pivot Table.
Automating Pivot Table refresh operations.
Items to consider before releasing your file to users.

DON'T HAVE TIME?

We can send you everything you need to know about this course through email.
We respect your privacy. Your information is safe and will never be shared.