Blog
Library

Excel Data Analysis With Pivot Tables & Pivot Charts

This MS Excel Pivot Table tool is most important for many executives, administrative assistants, Managers, marketers, supervisors, Finance professinals, Accounting professionals and anyone needs to learn. Unlock your Excel Pivot Table skills from our Simpliv Learning.
  • Training Type
    Live Training
  • Category
    MS Excel
  • Duration
    3 Hours
  • Rating
    5/5
Excel Data Analysis With Pivot Tables & Pivot Charts

Microsoft Excel Pivot Tables Course Introduction

About Microsoft Excel Pivot Tables Course Online

In three hours you will learn the simplicity of Pivot Tables along with the power that they hold. You will see first-hand what all the fuss is about and what PivotTables are and why everyone needs them. If you are using Excel and want to harness the power of the tools available to you in this program this class is for you.  Learn, with ease, how to set up, calculate, summarize, and analyze your data. This is one tool many executives, Managers, supervisors, administrative assistants, marketers, or anyone and everyone using excel needs to learn.  

Microsoft Excel Pivot Tables Course Objective

Create a PivotTable to analyze worksheet data.

Arrange fields in a PivotTable.

Group and Ungroup Data in a PivotTable.

Filter data in a PivotTable.

Create PivotCharts.

How to use PivotTables in Interactive Dashboards.

Tips and Tricks for beginning to Advanced Users of PivotTables.

Who is the Microsoft Excel Pivot Tables Course Target Audience?

Anybody with basic knowledge of Microsoft Excel

What Basic Knowledge required to learn Microsoft Excel Pivot Tables Course?

Have some working knowledge of Microsoft Excel

Related Virtual Classroom
Have Any Queries
Call Us : +510-849-6155
Email : support@simplivlearning.com

Available Batches

13 Aug 2024 Tue ( 1 Day ) 12:00 PM - 03:00 PM (Eastern Time)
30 Sep 2024 Mon ( 1 Day ) 12:00 PM - 03:00 PM (Eastern Time)
16 Oct 2024 Wed ( 1 Day ) 12:00 PM - 03:00 PM (Eastern Time)

Pricing

Live
Single Attendee
149 249
Live Session
Recorded
Single Attendee
199 332
6 month Access for Rec
Live+Recorded
Single Attendee
249 416
6 month Access for Rec
Contact Support for Group Offers

Require a Different Batch?

Request a Batch For

Microsoft Excel Pivot Tables Course Curriculum
Total Duration : 3 Hours
Session
  • Table of Contents  

    Create PivotTables

    Organize Data Using the Field List

    Group and Ungroup Data

    Summarize and show values

    Use Slicers

    Sort and Filter Data

    Quickly Format PivotTables

    Change Data/Refresh Data

    Create Pivot Charts

    Interactive Excel Dashboards with slicers and Pivot Tables.

    PivotTables vs. PowerPivot

    Bonus: Pivot Tables Tips & Tricks!