Excel 2016: The Basics of PivotTables

Learn to create PivotTables to make analyzing your data quick and easy and save hours at work every day | taught by Sam McIntire Watch Intro Video

Course description

PivotTables are one of the most commonly-referenced features of Excel for analysts at high-performing firms. Simply put, they're an easy way to summarize large quantities of data quickly and easily. But using PivotTables can be daunting, and, although powerful, they don't work very well unless your input data is properly-formatted and as granular as possible.

You'd love to know what PivotTables are and be able to use them to be more efficient and productive at work. But finding where to begin can be daunting, and getting started is awfully complex!

That's where this course comes in. With a series of succinct but comprehensive videos paired with engaging exercises, it will quickly get you up to speed on everything you need to know to get started using PivotTables in Excel. Armed with the knowledge in this course, you'll be well-equipped to interview confidently at a new job — or to get that big promotion.

Hands-on exercises

At Deskbright, we believe in learning by doing. That's why all of our courses come with a set of hands-on challenges that let you practice your newly-learned skills on your own. Each exercise comes with a comprehensive answer key so that you can check your work and learn through experience.

Satisfaction guarantee

We offer a 100%, unconditional, 30-day money-back guarantee on all of our courses. If you aren't satisfied for any reason, you can let us know within 30 days of your purchase to get your money back — no questions asked. This means that there's absolutely no risk on your end!

What are the requirements?

  • Microsoft Excel 2007 or later — Windows or Mac!

What will I get from this course?

Over the course of 4 bite-sized videos and 3 in-depth text tutorials, you'll learn everything you need to know to make PivotTables in Excel, including:

  • What a PivotTable is and why it's useful;
  • How to format input data before you create a PivotTable;
  • Creating one-dimensional Pivots to summarize data using the SUM function;
  • Creating multi-dimensional Pivots to break data out at a more granular level;
  • Summarizing data by functions other than SUM (like AVERAGE or COUNT); and
  • Grouping column headings within a PivotTable to organize data more effectively.

Who is the target audience?

This course is designed for the intermediate spreadsheet user who is already familiar with Excel's interface, but has never used PivotTables before. Knowledge of the basic SUM, AVERAGE, and COUNT functions is a plus, but not a requirement for this course.

Although this course is recorded on a Windows computer, the formulas and functions we'll learn also work great on a Mac.

Who is the instructor?

This course is taught by career expert and master Excel instructor Sam McIntire of Deskbright. With years of experience teaching students around the world advanced Excel skills, his easy-to-follow style is perfect for beginners to advanced learners alike. Sam:

  • Has helped thousands of students learn the Excel formulas and functions they need to succeed at work;
  • Is an experienced management consultant who learned Excel on-the-job at a top tier firm;
  • Has been featured in top business publications like Fast Company, Business.com, and Forbes;
  • Has received hundreds of positive reviews and 'thank you' e-mails from students whose work was transformed by his lessons.
Sam McIntire
Sam McIntire
Founder

Sam McIntire is a master Excel instructor and founder of Deskbright. His internationally-known tutorials have helped thousands of students around the world learn the Excel skills they need to succeed.

Sam started out as a management consultant, where he learned Excel on the job in one of the country's highest-performing firms.

Course Curriculum

Prerequisites
07:36
Getting started
Working with rows, columns, and cells
Number formats
Working with hotkeys
Show Content
What is a PivotTable?
02:28
What is a PivotTable?
Show Content
Prepping the data
04:38
Follow along: Preparing the data
Preparing the data
Exercise: Preparing the data
Show Content
Creating the PivotTable
03:35
Follow along: Creating a simple PivotTable
Creating a simple PivotTable
Exercise: Creating a PivotTable
Show Content
Advanced PivotTable capabilities
04:33
Follow along: Two-dimensional PivotTables
Two-dimensional PivotTables
Exercise: Two-dimensional PivotTables
Filtering PivotTable data
Summarizing by other functions
Grouping column headings
Show Content