Microsoft Power BI

    Excel Topic 2: Creating and Working with Pivot Tables

    Course Duration: 90 Minutes

    Target Audience:

    This session is intended for Excel users who wish to use Pivot Tables and Pivot Charts to analyse and summarise data quickly and effectively.

    Course Objectives:

    A Pivot Table is a reporting tool that produces 3D reports from spread sheet data. This session will explain the core concepts of Pivot Tables, and how to create, and manage a them.

    Course Outline:

    Course Introduction

    Steps in Creating a Pivot Table

    Selecting the Required Fields for the Pivot Table

    Editing the Pivot Table

    Formatting the Pivot Table

    Updating and Refreshing a Pivot Table

    Adding Data Fields and Change the Calculation Method

    Showing Multiple Totals Across Columns

    Grouping Fields for Data Analysis

    Creating a Pivot Chart

    Discussion and Question Time

    View Schedule
    Contact Us