Show navigation


  • 90 minutes

Discover the Secrets of Microsoft® Excel® PivotTables


If you don’t know how to create an Excel® Pivot Table - you will by the end of this program.

Any Excel® user who maintains database like data invariably needs tools to manage and analyze the data beyond mere sorting and filtering. Excel's® PivotTable feature gives you a quick and powerful way to create summary cross-totals combined with an enormous flexibility to restructure your results with simple dragging of fields. Whether you need the ability to create a quick look at the data for that important meeting or need more detailed analysis for a printed report, a PivotTable will meet your needs. This feature also lets you create a summary of data gathered from more than one worksheet. There’s a great visual companion feature as well, a pivot chart, that further enhances your presentation possibilities. To create good, quick summary information for analytical purposes, nothing beats a PivotTable. This video demonstrates the use of PivotTables in Excel® version 2016 (with occasional references to the 2013 and 2010 versions).
Runtime: 89 minutes
View Video

More Program Information


View Video

More Program Information


Dennis Taylor

Dennis Taylor

Taylor Associates

  • Founder of Taylor Associates
  • More than 20 years of experience working with Excel®
  • Taught thousands of classes and seminars throughout the United States and Canada
  • Presented more than 700 Excel® webinars and is the author or co-author of six books on spreadsheet software
View Video

More Program Information

All of your training, right here at Lorman.

Pay once and get a full year of unlimited training in any format, any time!

  • Live Webinars
  • OnDemand Webinars
  • MP3 Downloads
  • Course Manuals
  • Audio Recordings*
  • Executive Reports
  • White Papers and Articles
  • Sponsored Live Webinars

Additional benefits include:

  • State Specific Credit Tracker
  • Members Only Newsletter
  • All-Access Pass Course Concierge

* For audio recordings you only pay shipping

Questions? Call 877-296-2169 to speak with a real person.

Sign Up Today
With This Course

Access to all training products for one year

Unlimited Lorman Training

With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!

Easy Registrations

Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.

Invest in Yourself

You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.