Excel PivotTables

Learning Objectives

• To insert Pivot Table from a data table
• To build reports, sort, filter, and group data using pivot table
• To insert slicers
• To insert Pivot Chart

Course Description

Excel is used by an estimated 750 million people worldwide and Satya Nadella has proclaimed it as Microsoft’s most important consumer product. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.

Sometimes, the data will be huge and there needs to be a simpler way to express the data. In such a situation, a Pivot table comes handy. It is one of the basic data analysis tools. Pivot Tables can quickly answer many important business questions. One of the reasons we build Pivot Tables is to pass information. We would like to support our story with data that is easy to understand, easy to see.

Join this excel CPE webinar to understand your Excel data instantly by turning endless rows & columns of numbers into stunning visuals. We’ll manipulate vast amounts of data by creating Pivot Table.

You’re Just Seconds Away from Leveraging Microsoft Excel, Pivot Tables, Pivot Charts, and Slicers That Will Make It Possible for YOU To:

• Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
• Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
• Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE webinar will work similarly in Excel for PC and Mac

Overview

• What is a Pivot table?

  3 mins
• How to create a Pivot table

  7 mins
• Modification in the report

  17 mins
• Filter data

  19 mins
• Pivot chart

  26 mins
• Slicers

  29 mins