Microsoft Excel – Advanced Pivot Table Techniques
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. You will also learn how to navigate the complexity of PivotTables to take advantage of their power.
By the end of the course, you will be able to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable.
PREREQUISITES
Intermediate in Excel
TARGET GROUP
People who wants to learn how to create Pivot Table in a proper way
Duration
1 Day (7 hours)
Course Achievement
Certificate of Completion by Training Provider
At the end of the course, you will be able to:
• Prepare data source and create a PivotTable
• Summarize multiple data fields, Manage subtotals and grand totals,
• Create Grouping of PivotTable fields
• Perform filter with selections, rules, search filters, slicers, and timeline
• Apply PivotTable styles and format cells with conditional formatting
• Show different calculations in PivotTable value fields
• Create calculated fields using formulas and create calculated items with combine fields
• Create PivotCharts
BENEFITS OF Microsoft Excel – Advanced Pivot Table Techniques TRAINING
Advanced data analysis capabilities
Deeper understanding of pivot table features
Enhanced data visualization and reporting
Efficient data analysis workflows
View Course Outline
Getting Started
• Introduction to PivotTable
• Preparing data source to be use in PivotTable
• Creating the PivotTable
• Using external data source in PivotTable
• About PivotTable Fields Pane
• About PivotTable structure
• Building up the PivotTable
• Pivoting the PivotTable
• Show report filter pages
• Removing field from the PivotTable
• Managing PivotTable
• Grouping fields
• Sorting and filtering PivotTable data
• Refreshing PivotTable
• Formatting the PivotTable
• Summarizing PivotTable Data
• Working with PivotChart
• Printing PivotTables & PivotChart
• Grouping problem and solution
• Calculation in PivotTable
Calculated field
Calculated Item
Calculations in Show Value As
• Converting a crosstab data into normal data list (optional)
• Using multiple source data (optional)
Pre requisite & Methodology
You must have attended Excel Basic or has been using Excel for the past three years continuously with basic knowledge on Excel chart. You must also know how to use Excel basic functions.
This is a one-day hands-on course. The trainer will explain on the topic and then guide you through with step-by-step practice. You will be provided with real life scenario 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.
Who should attend:
• People who wants to learn how to create Pivot Table in a proper way
• People who wants to go beyond the basic Pivot Table like using formula to create calculated fields
• People who wants to summarize their data in different ways
• People who wants to generate more reports which is hard to achieve in normal spreadsheet
• People who wants to generate chart that can be change easily using Pivot Table
