Google, IBM & Microsoft Certificates — All in One Plan
Foundations of Data Visualization - Self Paced Online
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
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