Learn how to master Microsoft Excel PivotTables in this comprehensive 49-minute tutorial. Explore the creation of PivotTables from scratch, understand their elements, and discover techniques for pivoting fields, adding totals, formatting numbers and errors, selecting report layouts, and applying formatting styles. Practice your new skills with included exercises and downloadable Excel files. Navigate through various topics using provided timestamps, covering everything from basic explanations to advanced features like grouping data and customizing layouts. Perfect for Excel 2021 and Excel 365 users looking to enhance their data analysis capabilities.
Overview
Syllabus
- Intro
- PivotTables Explained
- Creating PivotTables from Scratch
- Pivoting the PivotTable Fields
- Subtotals and Grand Totals
- Number Formatting
- Show Values As and Summarize Values By
- Grouping PivotTable Data
- Formatting Error Values and Empty Cells
- Choosing a Report Layout
- Applying PivotTable Styles
- Exercise 06
Taught by
Simon Sez IT
Related Courses
-
Excel PivotTables: Advanced PivotTable Techniques for Analyzing and Presenting Data Faster
-
Conditional Formatting, Tables and Charts in Microsoft Excel
-
Explore Data with PivotTables in Microsoft Excel
-
Pivot Table Excel Tutorial
4.0 -
Microsoft Excel for Your Business
-
Microsoft Excel - Data Analytics Power Query and PivotTables
