Advanced Pivot Table Techniques in Microsoft Excel
Course Objective – Advanced Pivot Table Techniques in Microsoft Excel
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.

At the end of the 1 day course, you will learn 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