When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

Excel Data Visualization Part 2: Advanced Demos

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Excel Data Visualization Part 2: Advanced Demos

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon2 hours 5 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Excel Data Visualization Part 2: Advanced Demos

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

What You Will Learn?

  • 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:.
  • What are the requirements?.
  • What am I going to get from this course?.
  • Who is the target audience?.