Udemy - PivotTables with Excel
PivotTables with Excel
https://WebToolTip.com
Published 10/2026
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 3h 50m | Size: 3.05 GB
PivotTables A-Z: Building, Formatting, Styling, Calculating, Visualizing, Dashboards, Power Pivot & AI
What you'll learn
Create, customize, and apply Excel Pivot Tables from scratch in typical business scenarios
Analyze large datasets quickly by sorting, filtering, and grouping data, and by using totals, percentages, and calculated fields
Design and format professional Pivot Tables and visualize results with conditional formatting and suitable Pivot Charts
Build interactive dashboards using Slicers and Timelines
Use Power Pivot and a data model to connect and analyze multiple tables
Automate recurring Pivot Table tasks with macros and VBA, including support from ChatGPT
Recognize and avoid common mistakes when creating Pivot Tables
Refresh, print, and share your reports and analyses efficiently
Requirements
Microsoft Excel installed on your computer (ideally version 2016 or newer, e.g. Microsoft 365). Power Pivot is not available in all Excel versions.
Basic Excel skills (cells, simple formulas, working with tables) are helpful but not required
No prior knowledge of Pivot Tables, Power Pivot, or VBA is needed. You will learn everything step by step.
A free ChatGPT account is needed for the AI section (sign-up is shown in the course)