Excel Efficiency: Pivot Tables

Productivity - David Ringstrom

This course is intended to make it easier for you to transform raw data into the ideal required format for pivot table analysis, simplify pivot table maintenance by way of Excel's Table feature and contrast different methods for performing calculations within and outside of pivot tables. By the end of this course, you may expect to reduce the effort you put in creating reports and instantly generate required documents.

 

 

Learning Objectives:

  • Transform raw data into the ideal format for pivot table analysis
  • Simplify pivot table maintenance by way of Excel's Table feature
  • Contrast different methods for performing calculations within and outside of pivot tables

Instructor

David Ringstrom

Founder: Accounting Advisors, Inc.

David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at…

Training 5 or more people?

Get your team access to WIISE top 2,000 courses anytime, anywhere.

Try WIISE for Business

What will you cover?

Instructor

David Ringstrom

Founder: Accounting Advisors, Inc.

David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at…

Training 5 or more people?

Get your team access to WIISE top 2,000 courses anytime, anywhere.

Try WIISE for Business

Project Description

The image below shows the sample sales data collated from North wind access database.

Pivot Tables in Excel: Beginner’s Guide

You can download the sample Excel data here.

Task is to create a summary of customers, group all of their orders by product, and show the quantities, unit price and subtotals for all the transactions.

 

Attachments

Pivot table data