Learn Microsoft Excel Pivot Tables

Learn the basics of using Microsoft Excel Pivot Tables during this course.

Want to learn how to use Excel Pivot Tables? You can!

During this introductory course on Pivot Tables, we’ll teach you the basics for working with them – in both Microsoft Excel 2010 and Excel 2013.

We’ll start with some basic concepts and terminology. Then we’ll provide an easy to follow example using some fairly straightforward data and develop a pivot table and a pivot chart. We’ll then move into some of the more advanced aspects of Pivot Tables and Pivot Charts to show how powerful both are.

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.


Your Instructor


Simon Sez IT
Simon Sez IT
Simon Sez IT makes business and technical software simple to learn.

Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.

This is why more than a million learners have relied on Simon Sez IT since 2008.

Frequently Asked Questions


Do you offer discounts for non-profits or educational institutions?
Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact [email protected] for more information.
Do you provide any group discounts?
Yes, we offer group discounts or multiple users. Contact [email protected] for more information.
How long have you been in business?
We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 60 courses, with tens of thousands of satisfied customers in over 100 countries.
Where is Simon Sez IT located?
Simon Sez IT is located in sunny Los Angeles, California.
Do you offer Certificates of Completion?
We offer Certificates of Completion for courses that offer an online quiz (currently over 50% of our courses). The Certificates of Completion are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content.
Do you offer any online quizzes or testing tools?
We offer online testing for over 50% of our courses. Testing is also available with our newly published courses. The course tests can be simply used as testing tools or to earn a Certificate of Completion for a given course. The Certificate of Completion can be earned with a passing grade of 70%.
Will your videos work with iPhone, iPads, and Android devices?
All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course.
Will your videos work with Mac computers?
All of our courses are compatible with both Windows (PC) and Mac computers.
Can I interact with others who are taking the same course?
Yes, you can interact with others by using the discussion section offered for each course.
What if I have questions or problems while I am watching my tutorial?
Should you have any problems using the system, we offer free technical support to customers. Just send an email to [email protected] and we will respond promptly.
Can I try a course I am interested in before I purchase a course?
Absolutely. The first set of videos for each course is free. Our thinking is that this allows you to hear the teacher's voice and see the visuals. To watch a free video, just click onto the course of interest. Then click the video lesson that has the \“Preview\” button.
Do you offer a subscription option?
Yes, we offer a monthly or annual membership. Any monthly or annual subscription includes unlimited access to all StreamSkill.com courses including new courses released while your subscription is active. Click here http://streamskill.com/course/streamskill-membership/ to get additional details about the Ultimate Training Library membership.
Can I get my money back if I am not satisfied?
We offer an unconditional 14-day full money back guarantee – with no questions asked. As a result, you can rest assured that you can make your purchase in complete confidence. Our motto is \“If you don't learn, you don't pay.\” Thanks to our 14 days risk-free offer, you can test-drive a course and make sure it's what you had in mind. We are committed to your total satisfaction!
How long do I have access to the class that I purchased?
After purchase, you will have unlimited access to this course for as long as you like - across any and all devices you own.
When does the class start and finish?
The class starts now and never ends! It is a completely self-paced online class - you decide when you start and when you finish.

Get started now!