Excel Data Analysis Masterclass - Data Visualization
Learn how to use Pivot Tables to streamline and revolutionize your workflow in Excel
Created by John Bura
01
Skill level
All levels
02
Sections
9
03
Lectures
55
04
Instructor
John Bura
What's inside
This course includes.
✓
9
Sections
✓
55
Lectures
✓
55
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ 01. Introduction to the Course 5 lectures
1.1 Introduction To The Course
Locked
1.2 Introduction Of The Instructor
Locked
1.3 Course Requirements
Locked
1.4 How To Get Excel
Locked
Source files 01
Locked
+ 02. Dashboards Introduction 7 lectures
2.1 What Will We Learn In This Section
Locked
2.2 What Are Dashboards
Locked
2.3 Answers You Need Before You Start A Dashboard
Locked
2.4 Best Practices For Dashboard Layout
Locked
2.5 Best Practices For Dashboard Colors
Locked
2.6 Section Summary
Locked
Source Code 02
Locked
+ 03. Build a Dashboard Project 6 lectures
3.1 What Will We Learn In This Section
Locked
3.2 Build A Wireframe In Excel
Locked
3.3 Prepare Raw Data For Dashboard
Locked
3.4 Prepare Calculation Sheet
Locked
3.5 Section Summary
Locked
Source Code 03
Locked
+ 04. Scrolling Data Table 8 lectures
4.1 What Will We Learn In This Section
Locked
4.2 Build A Combo Box
Locked
4.3 Complex Lookup
Locked
4.4 Build A Scrolling Data Table
Locked
4.5 Conditionally Format Actual Values Vs Budgeted Values
Locked
4.6 Conditional Headers
Locked
4.7 Section Summary
Locked
Source Code 04
Locked
+ 05. Show Top Indicators 6 lectures
5.1 What Will We Learn In This Section
Locked
5.2 Show Top Matches Over And Under Budget
Locked
5.3 List Box To Select Indicators
Locked
5.4 Toggle Between Top Over Or Under
Locked
5.5 Section Summary
Locked
Source Code 05
Locked
+ 06. Scrollable Line Chart 8 lectures
6.1 What Will We Learn In This Section
Locked
6.2 Prepare Data For Scrolling Chart
Locked
6.3 Scrollable Line Chart
Locked
6.4 Remove Crashing Lines
Locked
6.5 Toggle Visibility Of Line Series
Locked
6.6 Finetune The Line Series
Locked
6.7 Section Summary
Locked
Source Code 06
Locked
+ 07. Interactivity 8 lectures
7.1 What Will We Learn In This Section
Locked
7.2 Add Interactivity To Reports With Pivot Slicers
Locked
7.3 Column Chart Controlled By Slicer
Locked
7.4 Pivot Slicer Sorting
Locked
7.5 Select Only 1 Slicer
Locked
7.6 Dynamic Comments With Slicers
Locked
7.7 Section Summary
Locked
Source Code 07
Locked
+ 08. Finetune the Dashboard 6 lectures
8.1 What Will We Learn In This Section
Locked
8.2 Add Calculations For Variances In Pivot Tables
Locked
8.3 Conditional Formatting In Pivot Tables
Locked
8.4 Refresh Pivot Table With Easy Vba
Locked
8.5 Section Summary
Locked
Source Code 08
Locked
+ 09. Course Summary 1 lecture
9.1 Course Summary And Next Steps
Locked
Description
About this course.
**Welcome to the Course: Excel Data Analysis Masterclass - Data Visualization**
Embark on a journey of mastering data analysis and visualization in Excel with this comprehensive masterclass. This course is designed for individuals seeking to enhance their skills in harnessing the power of Excel for insightful data visualization, creating interactive dashboards, and making data-driven decisions.
**Who is this course for?**
- Excel users aiming to elevate their data analysis and visualization skills.
- Professionals seeking to create impactful dashboards for data-driven decision-making.
- Anyone interested in harnessing the full potential of Excel for insightful data representation.
**Why Take this Course?**
- **Practical Application:** Gain hands-on experience through real-world dashboard projects.
- **Comprehensive Learning:** Cover a wide range of data visualization techniques and dashboard building strategies.
- **Career Advancement:** Acquire skills that are highly sought after in various industries for effective data analysis.
By the end of this masterclass, you'll have the knowledge and practical expertise to excel in Excel data analysis and visualization. Join us in the "Excel Data Analysis Masterclass - Data Visualization" and unlock the full potential of Excel for transforming raw data into actionable insights.
Instructors
Taught by people who ship.
John Bura
Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.
Ready to start building?
Learn how to use Pivot Tables to streamline and revolutionize your workflow in Excel