The Become A Solopreneur Expert Bundle

624 Enrolled
10 Courses & 66.5 Hours
$39.00$1,813.99
You save 97% -

What's Included

Microsoft Excel: Data Visualization with Excel Charts & Graphs
  • Certification included
  • Experience level required: Beginner
  • Access 61 lectures & 4 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

61 Lessons (4h)

  • Getting Started
    Course Structure & Outline1:27
    Bonus Homework Exercises
    Setting Expectations2:02
  • Data Visualization Best Practices
    Key Principles & The 10-Second Rule2:45
    The Good, The Bad & The Ugly3:44
    Three Key Questions1:49
  • Chart Formatting & Customization
    Chart Elements, Layouts & Styles6:20
    Chart Formatting Options5:26
    Changing Chart Types & Adding a Secondary Axis3:03
    Creating, Modifying & Applying Custom Templates4:06
    QUIZ: Chart Customization
  • Mastering Basic Charts & Graphs
    Bar & Column Charts8:49
    HOMEWORK: Bar & Column Charts
    Histogram & Pareto Charts5:58
    HOMEWORK: Histogram & Pareto Charts
    Line Charts & Trendlines5:16
    HOMEWORK: Line Charts & Trendlines
    Area Charts4:41
    HOMEWORK: Area Charts
    Pies, Donuts & Race Tracks12:04
    HOMEWORK: Pies, Donuts & Race Tracks
    Scatter Plots7:30
    Bubble Charts6:36
    HOMEWORK: Scatter Plots & Bubble Charts
    Box & Whisker Charts6:05
    HOMEWORK: Box & Whisker Charts
    Tree Maps & Sunbursts6:36
    HOMEWORK: Tree Maps & Sunbursts
    Waterfall Charts3:17
    Funnel Charts3:42
    HOMEWORK: Waterfall & Funnel Charts
    Radar Charts7:56
    HOMEWORK: Radar Charts
    Stock Charts7:18
    HOMEWORK: Stock Charts
    Heat Maps4:41
    HOMEWORK: Heat Maps
    Surface & Contour Charts7:35
    HOMEWORK: Surface & Contour Charts
    Geospatial Maps with Power Map5:28
    HOMEWORK: Power Map
    Basic Combo Charts7:57
    HOMEWORK: Combo Charts
    Sparklines2:07
    HOMEWORK: Sparklines
    QUIZ: Basic Charts & Graphs
  • Next-Level Data Viz Demos
    Setting Expectations1:40
    DEMO: Custom Image Overlay Charts6:01
    DEMO: Adding Binary Values to Highlight Ranges5:02
    DEMO: Automation with OFFSET & COUNTA7:08
    DEMO: Adding Interactive Elements with Form Controls12:30
    DEMO: Animating Changes Over Time14:20
    DEMO: Building a Dynamic Dashboard (Part 1)16:10
    DEMO: Building a Dynamic Dashboard (Part 2)12:08
    DEMO: Dynamic Value-Based Formatting10:09
    DEMO: Dynamically Highlighting a Data Series10:26
    DEMO: Building a Custom Pacing Chart10:22
    DEMO: Building a Custom Gauge Chart9:58
    DEMO: Visualizing Percentages with Arrays7:16
    QUIZ: Next-Level Data Viz
  • Wrapping Up
    Resources & Next Steps2:38

Microsoft Excel: Data Visualization with Excel Charts & Graphs

EM
Excel Maven

Instructor

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Description

Ask people what comes to mind when they think of Excel and odds are they'll say, "spreadsheets". However, Excel is an incredibly powerful, robust, and dynamic data visualization platform. This course will give you a deep, comprehensive understanding of Excel's data visualization tools and techniques. You'll learn when, why, and how to use each chart type, discover key data visualization best practices, and learn through interactive, hands-on demos and exercises every step of the way.

  • Access 61 lectures & 4 hours of content 24/7
  • Explore each of the 20+ chart types that Excel 2016 has to offer
  • Dive into a series of 12+ advanced Excel demos guaranteed to turn you into a data visualization pro

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Downloadable for offline viewing
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner

Requirements

  • Internet access required

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.