Skip to main content
PivotTables and PivotCharts, by Hand and with AI
0%
Previous
Course data
Getting Started
Announcements
🟢 Start Here: How This Course Works
🟢 Download Your Course Files
From Flat List to First Answer
🟢 Overview
🟢 1.1 Every PivotTable Is a Sentence
🟢 1.2 Is Your Data Pivot-Ready?
🟢 1.3 Watch: Build Your First PivotTable
🟡 1.4 Try It: The PivotTable Sandbox
🟢 1.5 Watch: Change the Question
🔴 1.6 Watch: Say the Sentence to Copilot
🔴 1.7 Watch: Say the Sentence to Claude
🟢 1.8 Check the AI's Work
🟡 1.9 Try It: Spot the AI's Mistake
🟢 Exercise: Answer the Regional Manager
🟢 Recap
🔴 Knowledge Check
Show It: PivotCharts, Slicers and Dates
🟢 Overview
🟢 2.1 Pick the Chart That Answers the Question
🟢 2.2 Watch: Build a PivotChart With a Slicer
🟡 2.3 Try It: The Chart Picker
🟢 2.4 Watch: Ask AI for the Dashboard
🔴 2.5 Keep It Fresh
🟢 Exercise: Build the Monthly Dashboard
🟢 Recap
🔴 Knowledge Check
Many Tables: The Data Model and Power Pivot
🟢 Overview
🟢 3.1 Why One Table Is Not Enough
🟢 3.2 Watch: Relate the Tables
🟡 3.3 Try It: Connect the Tables
🟢 3.4 Measures in Plain Words
🔴 3.5 Watch: Let AI Write the Measure
🟢 Exercise: Margin by Manager
🟢 Recap
🔴 Knowledge Check
Orchestrate: Let AI Run the Workflow
🟢 Overview
🟢 4.1 From Clicking to Directing
🟢 4.2 Watch: One Brief, Whole Report
🟡 4.3 Make It Repeat
🟡 4.4 Try It: Which Tool for Which Job?
🟢 4.5 Guardrails for Agents
🟢 Exercise: Brief the Monday Report
🟢 Recap
🔴 Knowledge Check
Reviewer Notes
Next
Side panel
Categories
All categories
AI Learning Hub
AI Essentials
Level 1: Generative AI Foundation
Level 2: Grounding AI with your Data
Level 3: Automating AI Workflows
Copilot First-Step Kit
Claude
ChatGPT
Microsoft Copilot
M365
Office
Excel
Word
Outlook
PowerPoint
Power Platform
Power BI
Power Apps
Power Automate
SharePoint
Microsoft Official
Adobe
CompTIA
Holding
Webinars
Programming
WordPress
Accounting
Google
Upskilling Series
Home
Log in
Username
Username
Password
Password
Forgot your password?
Log in
Categories
Collapse
Expand
All categories
AI Learning Hub
AI Essentials
Level 1: Generative AI Foundation
Level 2: Grounding AI with your Data
Level 3: Automating AI Workflows
Copilot First-Step Kit
Claude
ChatGPT
Microsoft Copilot
M365
Office
Excel
Word
Outlook
PowerPoint
Power Platform
Power BI
Power Apps
Power Automate
SharePoint
Microsoft Official
Adobe
CompTIA
Holding
Webinars
Programming
WordPress
Accounting
Google
Upskilling Series
Home
Course info
PivotTables and PivotCharts, by Hand and with AI
Skill Level
:
Beginner