Setup Menus in Admin Panel

Ask people what comes to mind when they think of Excel, and odds are they’ll say “spreadsheets”. The truth is, Excel is an incredibly powerful, robust, and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts — and I’m here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel’s latest data visualization tools and techniques. I’ll show you when, why, and how to use each chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and exercises every step of the way.
We’ll kick things off by exploring each of the 20+ chart types that Excel 2016 has to offer, including:
  • Bar & Column charts
  • Histograms & Pareto charts
  • Line charts & trend lines
  • Area charts
  • Pies & Donuts
  • Scatter plots & Bubble charts
  • Box & Whisker charts
  • Tree Maps & Sunbursts
  • Waterfall & Funnel charts
  • Radar & Stock charts
  • Heat maps, 3-D Surface & contour charts
  • Chloropleths & Geospatial maps
  • Custom combo charts & graphs
  • Sparklines
  • And more…
From there we’ll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren’t “textbook” demos that you can find on YouTube; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times. I’ve built my analytics career around data visualization, and I can help you do the same.
Whether you’re looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your data visualization game in a major way, this course is for you. In fact, if you don’t learn something brand new in this course, I will make sure you get your money back AND give you a virtual high-five for checking it out. You literally can’t lose.

Course Curriculum

1.1 Course Structure & Outline
1.1 Course Structure & Outline 00:00:00
1.2 Resource Files and Datasets
1.2 Resource Files and Datasets 00:00:00
2.2 The Good, The Bad, and The Ugly
2.2 The Good, The Bad, and The Ugly 00:00:00
2.3 The 3 Key Questions
2.3 The 3 Key Questions 00:00:00
3.1 Setting Expectations
3.1 Setting Expectations 00:00:00
3.2 Chart Elements, Layouts, Colors & Styles
3.2 Chart Elements, Layouts, Colors & Styles 00:00:00
3.3 Chart Formatting Options
3.3 Chart Formatting Options 00:00:00
3.4 Changing Chart Types & Adding a Secondary Axis
3.4 Changing Chart Types & Adding a Secondary Axis 00:00:00
3.5 Creating, Modifying & Applying Custom Templates
3.5 Creating, Modifying & Applying Custom Templates 00:00:00
4.1 Bar & Columns Charts
4.1 Bar & Columns Charts 00:00:00
4.2 Histograms & Pareto Charts
4.2 Histograms & Pareto Charts 00:00:00
4.3 Line Charts & Trendlines
4.3 Line Charts & Trendlines 00:00:00
4.4 Area Charts
4.4 Area Charts 00:00:00
4.5 Pies, Donuts & Race Tracks
4.5 Pies, Donuts & Race Tracks 00:00:00
4.6 Scatter Plots
4.6 Scatter Plots 00:00:00
4.7 Bubble Charts
4.7 Bubble Charts 00:00:00
4.8 Box & Whisker Charts
4.8 Box & Whisker Charts 00:00:00
4.9 Tree Maps & Sunburst Charts
4.9 Tree Maps & Sunburst Charts 00:00:00
4.10 Waterfall Charts
4.10 Waterfall Charts 00:00:00
4.11 Funnel Charts
4.11 Funnel Charts 00:00:00
4.12 Radar Charts
4.12 Radar Charts 00:00:00
4.13 Stock Charts
4.13 Stock Charts 00:00:00
4.14 Heat Maps
4.14 Heat Maps 00:00:00
4.15 Surface & Contour Charts
4.15 Surface & Contour Charts 00:00:00
4.16 Geo-Spatial Maps with Power Map
4.16 Geo-Spatial Maps with Power Map 00:00:00
4.17 Basic Combo Charts
4.17 Basic Combo Charts 00:00:00
4.18 Sparklines
4.18 Sparklines 00:00:00
5.1 Setting Expectations
5.1 Setting Expectations 00:00:00
5.2 Demo Custom Image Overlay Charts
5.2 Demo Custom Image Overlay Charts 00:00:00
5.3 Demo Adding Binary Values to Highlight Date Ranges
5.3 Demo Adding Binary Values to Highlight Date Ranges 00:00:00
5.4 Demo Automation with OFFSET, COUNTA & Named Ranges Preview
5.4 Demo Automation with OFFSET, COUNTA & Named Ranges Preview 00:00:00
5.5 Demo Adding Scroll & Zoom Functionality with Form Controls
5.5 Demo Adding Scroll & Zoom Functionality with Form Controls 00:00:00
5.6 Demo Animating Changes Over Time
5.6 Demo Animating Changes Over Time 00:00:00
5.7 Demo Building a Dynamic Dashboard (Part 1)
5.7 Demo Building a Dynamic Dashboard (Part 1) 00:00:00
5.8 Demo Building a Dynamic Dashboard (Part 2)
5.8 Demo Building a Dynamic Dashboard (Part 2) 00:00:00
5.9 Demo Value-Based Dynamic Formatting
5.9 Demo Value-Based Dynamic Formatting 00:00:00
5.10 Demo Dynamically Highlighting a Data Series
5.10 Demo Dynamically Highlighting a Data Series 00:00:00
5.11 Demo Building a Custom Pacing Chart
5.11 Demo Building a Custom Pacing Chart 00:00:00
5.12 Demo Designing a Custom Gauge Chart
5.12 Demo Designing a Custom Gauge Chart 00:00:00
5.13 Demo Visualizing a Percentage Using Array Functions
5.13 Demo Visualizing a Percentage Using Array Functions 00:00:00
6.1 Additional Resources & Next Steps
6.1 Additional Resources & Next Steps 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 year
0 STUDENTS ENROLLED
    Copyright @2019