Course Objectives

• Data Ranges comparison to Data Tables
  • The advantage of one over the other
• Data Cleanup and Preparation
  • Get your data ready for multiple summaries in a PivotTable
• Data Structural Design Concepts
  • Learn about good practices and about avoiding common pitfalls
• Building and working with PivotTables
  • Learn the specifics of where everything goes and gain control over the outcome
• Deciphering and understanding the Data at Hand
  • Utilize PivotTables to translate your vision into reality

Course Content

One of the main improvements made to Excel in recent years is its capability to accumulate and to house an ever-growing data deposit. But the challenges go beyond amassing and managing an influx of data, they carry onto delivering meaningful summaries that aid us in reaching well-informed data-driven business decisions.

Dubbed as Excel most powerful tool, PivotTables at first glance can be tricky and somewhat overwhelming. But that couldn’t be any farther from the truth. With a little understanding of simple data concepts and logical data structural designs, you will realize that PivotTables are truly one of the easiest tools to utilize, and that is where this course comes in play! It delivers on the promise to simplify through relatable analogies the idea behind PivotTables and their functionality.

At completion, participants will have a deep understanding of PivotTables, as well as PivotCharts, and their working particulars.

Learn how to clean and prepare the data, build the PivotTable and modify its layouts and summaries to suit your needs, and add visualizations to it all with PivotCharts.

Who should attend

PivotTable is an advanced topic that requires a certain level of comfort in Excel mastery. You do not need to be an expert at it, but an intermediate-level knowledge base is required to maximize on time and be able to advance through course topics.

Prerequisites

Please be in good command of the following:

• Basic Number, Dates, and Worksheet Formatting
• Writing Formulas and using Built-in Functions – Sum / Average / Max / Min / Count
• Sorting and Filtering Data Lists
• Basic understanding of Subtotals and Grouping
• Basic Knowledge of Charts

These skills will allow us to focus on the big topics at hand and will minimize being sidetracked with the entry-level workings of Excel. Possession of these skills will ensure keeping the class flow going smoothly.