Mastering Pivot Table for Microsoft Excel: Advanced Features and Skills
Course Information
Start Date | |
End Date | 19 Jun 2024, Wed |
Time | 9.30am to 4.30pm |
Mode | |
Fee | SGD 680.00 (excluding GST) |
Contact | Eunice | 6720 3333 | training.aventis@gmail.com |
Register Now | |
Get In-House Quotation |
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….