Video Source from https://www.youtube.com/watch?v=UsdedFoTA68 for your reference only
Schedule Available
4 April 22 ( Mon) @ 9:00 am – 6:00 pm @ Holiday Inn, Orchard
11 July 22 (Mon) @ 9:00 am – 6:00 pm @ Holiday Inn, Orchard
——————————————————————————————————————————
Excel’s most powerful analytical tool is the PivotTable.
In this course, you’ll be taught how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.
This course shows you how to navigate the complexity of PivotTables while taking advantage of their power.
You will learn how to
- build PivotTables from single data source,
- add calculated fields,
- filter your results, and
- format your layout to make it more readable.
Course Objectives
- Preparing data source to use in Pivot Table
- Preparing data source to use in Pivot Table
- Get data from external source
- Summarizing multiple data fields
- Managing subtotals and grand totals
- Grouping PivotTable fields
- Filtering with selections, rules, search filters, slicers, and timeline
- Applying PivotTable styles
- Formatting cells with conditional formatting
- Show different calculations in PivotTable value fields
- Create calculated fields using formulas
- Create calculated items with combined fields
- Creating PivotCharts
Prerequisite
- Must have attended Excel Basic or has been using Excel for the past three years continuously
- Must know how to use Excel basic functions
- Basic knowledge on Excel chart
Who Should Attend
- People who want to learn how to create Pivot Table in a proper way
- People who want to go beyond the basic Pivot Table like using formulas to create calculated fields
- People who want to summarize their data in different ways
- People who want to generate more reports which are hard to achieve in a normal spreadsheet
- People who want to generate a chart that can be changed easily using Pivot Table
Methodology
This is a one-day hands-on course.
The trainer will explain the topic and then guide you through with step-by-step practice. You will be provided with real-life scenarios for individual topics so that you can apply what is being taught. After the hands-on practice on every topic, you’ll have a short Q & A session.
Things to bring during the course
- A laptop (preferable your personal laptop)
- Laptop power adaptor
- A USB mouse
- Software requirement:
- Microsoft Word and Excel version 2013-2019 or Office 365