Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Computer Applications Microsoft Microsoft Excel - Pivot Tables
Return to Microsoft
excel-pivot-tables-online-class

Microsoft Excel - Pivot Tables

Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities. 

Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. Whether you're new to pivot tables, need a refresher, or want to become the pivot table guru within your organization, this course is for you!

6 Weeks / 24 Course Hrs
Starting November 8, 2017

Offered in Partnership with your Preferred School

UMBC Training Centers Why this school? It's been chosen based on your location or if you've visited this school's website.

Change School

Learning Method

Instructor-led Confirm your Start Date in Cart

Microsoft Excel - Pivot Tables

Learning Method

Instructor-led Confirm your Start Date in Cart

Microsoft Excel - Pivot Tables Reviews

Microsoft Excel - Pivot Tables Details + Objective

Course Code: pts

You Will Learn
  • Learn how to work with the numerous pivot table options and system settings
  • Become skilled in developing useful analysis models and reports
  • Learn how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers
  • Discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items
  • Learn how to efficiently manage changes to the pivot table's source data in order to avoid reporting mistakes when data is added or deleted
How the course is taught
  • Instructor-led course
  • 6 weeks in duration
  • Courses begin each month
  • 2 lessons released each week
  • 24 course hours
How you will benefit
  • Learn advanced techniques and become more valuable to your organization
  • Become more confident in your ability to report accurate data efficiently using Microsoft Excel
  • Open the door to new career opportunities in data analysis and reporting
Microsoft Excel - Pivot Tables Outline
Expand All
Week 1

Develop a solid understanding of the requirements to use pivot tables. Cover the foundational elements you need to understand, and take a peek into the sometimes-intimidating Pivot Table Fields task pane and pivot table-specific Ribbon tabs. You’ll also learn what's required to make sure your data is organized well enough to be used in a pivot table.

Week 2

Understand how the different pivot table features are grouped and what each one provides which is a must if you want to consider yourself a master pivot table user. Learn how to format cells and numbers, as well as how to handle empty cells or errors in your source data. In addition, you'll get some exposure to renaming fields and how to sort and filter data within your pivot table report.

Week 3

Learn how to use some of the more obscure settings in the Pivot Table Options and Field Settings dialog boxes which can be extremely useful. You’ll also learn the Values section of a pivot table report which has unique settings and summarization options. Once you learn how to use these lesser-known settings, you'll go from an average pivot table user to an expert.

Week 4

Learn to group ordinary pivot table fields, which will create new fields that you can use within the pivot table or as a Slicer. In addition, you'll learn how to expand and collapse fields to help in summarizing the pivot table data. Then learn how to locate data anomalies in large data sets and the proper use of report filters which can assist in any data investigation as well as a great tool for creating multiple reports from a single pivot table report.

Week 5

Routinely, it's necessary to create different versions of reports, but the best way to do so isn't as straightforward as you might think and you discover the secrets here. Then learn to use Excel's Calculated Items and Fields feature which provides you with a way to create items that are missing from the source data or that you need for a one-time analysis.

Week 6

In order to create an effective dashboard, a pivot table and pivot chart controlled by multiple Slicers is a must, and you’ll learn how in this lesson. Finally, you’ll learn about some of the many interactive tools and techniques available to make pivot tables and pivot charts fun to use.

View All Sections
Microsoft Excel - Pivot Tables Instructors
Chad Wambolt

Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales ranging from $500 million to $3 billion. Through the course of his career, Chad has become an expert user of Microsoft Excel. His knowledge of Excel's capabilities has helped organizations streamline processes and save countless hours of labor. Chad has taught Excel to students of varying skill levels since 1997.

Microsoft Excel - Pivot Tables Requirements / Prerequisites

There are no prerequisites for this course.

Microsoft Windows 7, Microsoft Windows 8.x, or Microsoft Windows 10

Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Office 2016

A free 30-day trial of Office 365 Home Premium may be available at Office Online. Then, a subscription can be purchased for as little as $6.99 per month. Please be sure to install the software on your computer before the course begins.

Note: This course is not suitable for Macintosh users who are using the Office Mac Home versions or for users of older versions of Microsoft Excel.

"Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.

Microsoft Excel - Pivot Tables Frequently Asked Questions
Expand All
When can I get started?

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work?

Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

How long do I have to complete each lesson?

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

What if I need an extension?

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Browse All