Data Management Analytics with Pivot Tables (Excel 2016)IT Short Courses

Enquire MoreRegister NowCorporate Courses

DurationOne day
Course Dates09 Jan 2024 9:00am - 09 Jan 2024 5:00pm
26 Apr 2024 9:00am - 26 Apr 2024 5:00pm
26 Jul 2024 9:00am - 26 Jul 2024 5:00pm
14 Oct 2024 9:00am - 14 Oct 2024 5:00pm

Course Fee

Member $324.30
Non-Member $381.50
  • Members enjoy a 15% discount before GST
  • Group Discount (5 or more participants) - 10%
  • Course fees updated with 9% GST for 2024

Funding Available

  1. COMPANY-SPONSORED PARTICIPANT
    SDF GRANT REIMBURSEMENT (Non-WSQ)
    SDF Grant Amount: S$14.00
    Course Reference No.: TGS-2020500823
     
  2. INDIVIDUAL PARTICIPANT
    SkillsFuture Credit
    (Individual Singaporean aged 25 and above)
    Pre-approved SkillsFuture funding of S$500.00

Click HERE for more info on SkillsFuture.

Introduction

The pivot table is one of the most powerful features of Excel, yet few users use them in their day-to-day activities. PivotTable reports are especially well-suited for taking large amounts of data and summarizing it into useful reports.

For some, pivot tables have always been too intimidating and for others, pivot tables are still unknown. With a little instruction and guidance, you will be able to use pivot tables to accomplish routine analysis and reporting that you have never ever thought of.

This course will begin with basic pivot tables and progresses to advanced pivot table topics covering insights into the inner workings of Pivot Tables, enabling analysis and preparation of reports to solve pressing business needs.

Key Takeaways

Upon completion of this workshop, participants will be able to;

  • Understand how and when to use pivot tables
  • Automate pivot tables by connecting them to external databases
  • Create basic and advanced Excel pivot tables
  • Create cross-tabulations and other associated advanced features
  • Customise fields in a pivot table
  • Format and print your pivot table report
  • Group and perform calculations and its associated advanced options
  • Perform calculations within pivot tables
  • Building and automating business performance dashboards
  • Structure and format your tables of raw data to easily allow for data analysis using pivot tables and pivot charts

Who Should Attend

Anyone who needs to use Pivot Table Analysis Techniques to more complex data sets. Managers and Executives who have to manage, analyse and prepare reports will find this course most beneficial.

Participants should have a strong grounding in Excel basic to intermediate knowledge, i.e. Navigate around a worksheet, format Cells, Auto Filter, Sorting, Simple Template Creation and Enter Simple Formulas.

Programme Outline

 

Module 1: Database / List Operations

  • Introduction to Excel Databases
  • Using Tables
  • Sorting and Filtering Records
  • Removing Duplicates
  • Database Functions
  • Summarize Data Using Subtotals

Module 2: Importing Data

  • Import Delimited Data
  • Text to Columns Function
  • Managing Data Connections

Module 3: Basics of Pivot Tables

  • Understanding Pivot Tables
  • Building a Pivot Table
  • Pivot Table Formatting
  • Table Layout
  • Field Options
  • Changing Numeric Formats
  • Sort Order
  • Setting Top / Bottom Values
  • Extract Pages and Records

Module 4: Grouping Data

  • Grouping Date / Time Fields
  • Grouping Numbers
  • Manual Grouping

Module 5: Using Slicers

  • Inserting and Using Slicers
  • Formatting Slicers
  • Sharing Slicers

Module 6: Creating Calculations

  • Adding Multiple Summaries
  • Showing Values As
  • Inserting Calculated Fields
  • Inserting Calculated Items
  • Using Get Pivot Data Function

Module 7: Generate Pivot Chart Reports

  • Create Pivot Charts
  • Adding Chart Analysis Tools

Module 8: Multiple Data Ranges

  • Consolidate Multiple Data Ranges
  • Design of Page Fields

Module 9: Presenting Reports

  • Using Dashboard Techniques

Methodologies

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for this course. 

If you are interested in this corporate programme, please complete the following form and one of our representatives will get back to you as soon as possible.

I would like to receive marketing, advertising and promotional messages via:
(Please untick if you do not wish to receive)

MDIS values your privacy and we are committed to safeguarding your personal data in compliance with the Personal Data Protection Act 2012. By providing your personal details, you have authorised MDIS to share with you our marketing, advertising and promotional materials.

Quick Information

The pivot table is one of the most powerful features of Excel, yet few users use them in their day-to-day activities. PivotTable reports are especially well-suited for taking large amounts of data and summarizing it into useful reports.

Contact Details

  +65 6842 6666
  mdc@mdis.edu.sg