Excel Advanced Charts Mini Course

Microsoft Excel, Excel Dashboard

What you'll learn

How to create interactive charts using the Rollover Method to add a new dimension of engagement.

Techniques to build a Facebook-inspired Rollover Chart for instant data insights on hover.

Step-by-step guidance to replicate a Google Analytics-style chart in Excel, ideal for visualizing web traffic trends.

Skills to use a few simple formulas and a bit of VBA for dynamic, advanced charting without over-complicating.

Practical, hands-on strategies to present data visually in ways that captivate and inform, going beyond Excel's default charts.

Requirements

Basic Excel Knowledge: Familiarity with Excel's interface, basic functions, and general charting skills.

Interest in Advanced Charting: A desire to learn how to create interactive, professional-quality charts.

Access to Excel: Excel 2016 or later is recommended for following along with the course examples and labs.

Willingness to Experiment: No need for advanced VBA skills—just a readiness to try out simple code and formulas for chart enhancements.

Description

You're no stranger to Excel. You might even be comfortable creating dashboards and using standard line or bar charts. But if you're like I was, you know that Excel's default charts can feel limiting—especially when you're aiming to present data in ways that truly engage and inform. Basic charts just don't always do the job.Sound familiar? You're not alone.That's exactly why I created the Advanced Charts Mini Course. This course is for Excel users ready to move beyond the basics, diving into advanced charting techniques that will set your data presentations apart. You probably already know how to make a simple chart—but what if you could create dynamic, interactive visuals that adapt to your data without complex tools or time-consuming VBA coding?In this course, we'll explore:Rollover Method: Learn how to make your charts interactive so they respond to mouse hovers, adding a layer of depth and engagement to your data presentation that instantly captivates.Facebook Views Rollover Chart: Master a Facebook-inspired chart style using rollover techniques that allow viewers to see detailed data points at a glance, making your visuals more intuitive and professional.Google Analytics Chart: Create a Google Analytics-style chart in Excel, mimicking the design and functionality of professional web analytics dashboards, ideal for presenting web traffic data and trends.This course is designed to help you deliver clean, engaging visuals that convey the right insights without unnecessary clutter. It's about practical, impactful charting that enhances the quality of your data storytelling.If you're ready to elevate your Excel charting skills and make a lasting impact with your data, then this is the course for you.See you there!

Overview

Section 1: Course Introduction

Lecture 1 Course Introduction

Section 2: Rollover Method

Lecture 2 Rollover Method Introduction

Lecture 3 Rollover Method Demo Instruction

Section 3: Facebook Views Rollover Chart

Lecture 4 Facebook Views Rollover Example

Section 4: Google Analytics Chart

Lecture 5 Introduction - Google Analytics Chart

Lecture 6 Building the Heatmap

Lecture 7 Implementing the Rollover

Lecture 8 Implementing the Hover Box

Excel Power Users: Those who use Excel regularly and want to expand their charting capabilities.,Data Analysts: Professionals seeking to improve their data visualization skills with advanced charts.,Business Analysts: Individuals who frequently present data and want to make a memorable impact with unique, engaging charts.,Managers and Decision Makers: Leaders looking to elevate the visual quality of their reports to communicate data insights more effectively.,Students and Professionals: Anyone aiming to stand out by adding advanced Excel charting skills to their resume.