Mastering Pivot Table for Microsoft Excel: Advanced Features and Skills

Mastering Pivot Table for Microsoft Excel 2016 & 365 Users: Advanced Features & Skills


Course Information

Start Date 10 May 2024, Fri
Start Date
End Date10 May 2024, Fri
Time9.00am to 5.00pm
Mode
FeeSGD 680.00 (excluding GST)
Contact Eunice | 6720 3333 | training.aventis@gmail.com
Register Now
Get In-House Quotation
  • Overview

  • Learning Outcomes

  • Who Should Attend

  • Testimonials

  • Trainer's Profile

  • Course Outline

Learn Advanced Pivot Tables Features of Microsoft Excel

Pivot Tables is one of the most powerful and useful tools in Microsoft Excel application that you should learn to master, especially when dealing of large database. It allows you to analyse and visualise data in various ways that can provide deep insights. Using PivotTable will save you a lot of time by allowing you to quickly summarize large amounts of data into a meaningful report. Understanding exactly how a pivot table works will really help you unleash the full potential of this amazing tool.

Learn how to use Advanced Pivot Table and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel

Upon completion of the course, you would be able to understand the workings of Excel Pivot Tables, various techniques of summarizing data and create complex models for reporting. You will also learn how to create a Pivot Charts for presentation. Essentially, this 1 day course gives you a complete understanding of the use of Pivot Tables in Microsoft Excel.

Get the opportunities to practice with real world scenarios.  In this one day course, you will learn how to prepare dynamic source data for PivotTable, create and format PivotTable, filter and sort PivotTable data, create and format PivotChart, performs calculation in PivotTable using functions and calculated fields, connect Slicer and Timeline to multiple PivotTables, group dates, text and numbers in PivotTable, create table relationships, create PivotTable using Data Model, create interactive dashboard with slicer and etc….

Share this Course