Business Charts in Excel
Turn data into stories that capture every colleague's attention
Please visit: https://www.xelplus.com/course/business-excel-charts/ for more details about this course.
Course Curriculum
Introduction
Available in
days
days
after you enroll
📊 Section 1: Excel Chart Basics
Available in
days
days
after you enroll
-
Start❓ How to Pick the Right Chart (Answer these questions) (8:36)
-
StartCreating Excel Charts: Data Structure, Multiple Series (12:32)
-
StartImproving Charts: Adding Elements & Formatting (14:01)
-
StartEssential Practices for Creating Standout Visuals (8:36)
-
Start🤔 Quiz - Chart Basics
-
Start📝 Key Takeaways Chart Basics
🔃 Section 2: Mastering Dynamic Charts in Excel
Available in
days
days
after you enroll
-
PreviewCreating Charts that Update Themselves (3:03)
-
StartExcel Tables & Slicers for Dynamic Charts (8:22)
-
StartLast 12 Months Dynamic Charts (No more Manual Updates!) (7:20)
-
StartConnecting Charts to a Drop-down (6:42)
-
Start💪 Exercise: Switching Units in Charts with a Drop-Down
-
StartDynamic Chart Titles: Add Clarity with Real-time Updates (10:53)
-
StartAdding Context with Text Boxes and Labels like The Economist (9:26)
-
Start🔥 Challenge: Interactive Chart with Slicer and Dynamic Text (10:05)
-
StartAutomatic Sorting in Charts for Better Reporting (5:09)
-
StartPositioning Axis Labels to Avoid Overlap with Negative Values (10:14)
-
StartPivotCharts with Slicers and Timelines (11:16)
-
StartPivotTable Data to Power Standard Charts with Slicers (10:00)
-
StartBonus: More Interactive Charts with New Excel Features
-
Start📝 Key Takeaways Dynamic Charts