Excel Data Visualization Part 2: Advanced Demos

Go to class
Write Review

Free Online Course: Excel Data Visualization Part 2: Advanced Demos provided by Skillshare is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge. Excel Data Visualization Part 2: Advanced Demos is taught by Chris Dutton.

Overview
  • This class is Part 2 of a two part Excel data visualization series, designed to give you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques.

    This segment builds on the skills developed in Microsoft Excel: Data Visualization With Charts & Graphs (Part 1) by introducing a series of advanced demos and case studies that you won't find in ANY other Excel course, including:

    • Custom image-overlay charts
    • Automation with dynamic ranges
    • Scroll & zoom functionality with form controls
    • Dynamic dashboards
    • Advanced formatting techniques
    • Custom-built gauge charts
    • And more!

    What are the requirements?

    • Microsoft Excel, ideally 2016 for PC (some charts are not available in earlier versions of Excel)
    • Mac users are welcome, but note that the user experience will be significantly different across platforms

    What am I going to get from this course?

    • Exclusive data visualization tips, tricks, and best practices from an award-winning analytics expert
    • Unique, custom content that you won't find in ANY other course

    Who is the target audience?

    • Anyone looking to create beautiful, custom data visualizations in Excel
    • Excel users who want to master advanced charts, graphs & dashboards
    • Students looking for an engaging, hands-on, and highly interactive approach to training

Syllabus
    • Intro: Setting Expectations
    • Custom Image Overlay Charts
    • Adding Binary Values to Highlight Date Ranges
    • Automation with OFFSET, COUNTA & Named Ranges
    • Adding Scroll & Zoom Functionality with Form Control
    • Animating Changes Over Time
    • Building a Dynamic Dashboard Part 1
    • Building a Dynamic Dashboard Part 2
    • Value Based Dynamic Formatting
    • Dynamically Highlighting a Data Series
    • Building a Custom Pacing Chart
    • Designing a Custom Gauge Chart
    • Visualize a Percentage Using Array Functions
    • Conclusion