The Personal & Business Finance Super Bundle

2 Reviews
147 Enrolled
12 Courses & 68 Hours
$34.99$2,388.00
You save 98% -

What's Included

Advanced Excel Dashboards & Data Visualization Masterclass
  • Certification included
  • Experience level required: Intermediate
  • Access 85 lectures & 6 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

85 Lessons (6h)

  • Your First Program
  • 1 - Introduction
    1.1 Introduction0:49
    1.2 Why Even Use Excel?7:35
    1.3 Why Dashboards + Datavis?5:23
    1.4 Interactive Dashboards in Excel10:19
    1.5 Quiz
  • 2 - Thinking Outside the Cell
    2.1 Thinking Outside the Cell6:47
    2.2 Why develop differently3:40
    2.3 Inserting the camera tool2:57
    2.4 How to use the camera tool7:54
    2.5 Development Principles12:49
    2.6 Quiz
  • 3 - Working with Formulas
    3.1 Formula Editing Tips11:52
    3.2 Excel Calculation Engine9:08
    3.3 Writing Better Formulas11:10
    3.6 Quiz
  • 4 - Advanced Formulas for Dashboards & Decisions
    4.1 Lookup Functions2:44
    4.2 How to use VLOOKUP3:24
    4.3 How to use INDEX/MATCH6:28
    4.4 Combining formulas4:24
    4.5 How to use Array Formulas2:49
    4.6 Array Formulas Demo20:44
    4.7 Section Review2:20
    4.8 Quiz
    4.9 Practice
  • 5 - Excel Tables are the Best!
    5.1 Introduction to Excel Tables3:43
    5.2 Inserting a New Excel Table8:35
    5.3 Working with Tables7:29
    5.4 Excel Tables Demo4:34
    5.5 Rules for using Excel Tables2:35
    5.6 Quiz
    5.7 Practice
  • 6 - Sorting and Decision Functions
    6.1 Introduction to Sorting Functions19:20
    6.2 Creating Filters with SUMPRODUCT1:38
    6.3 Filtering on Excel Tables17:26
    6.4 Data Aggregation13:26
    6.5 Section Summary2:12
    6.6 Quiz
    6.7 Practice
  • 7 - Form Controls for Interactivity
    7.1 The DEVELOPER Tab1:32
    7.2 Excel Form Controls3:44
    7.3 Form Controls Demo14:55
    7.4 Form Control Basics1:59
    7.5 Creating a Scrollable Table7:26
    7.6 Quiz
    7.7 Practice
  • 8 - Formula-driven Development
    8.1 Introduction to Formula-driven Development29:11
    8.2 The Information-Transformation-Presentation Dynamic5:06
    8.3 Quiz
  • 9 - Creating an Interactive Legend Dashboard
    9.1 Section Introduction1:50
    9.2 Creating an Interactive Legend7:18
    9.3 Perfecting the Interactive Legend16:50
    9.4 Maintaining the Interactive Legend3:11
    9.5 Practice
  • 10 - Creating an Interactive Chart Dashboard
    10.1 Section Introduction0:38
    10.2 Setting up an Interactive Chart6:56
    10.3 Formatting the Interactive Chart5:04
    10.4 Maintaining the Interactive Chart2:51
    10.5 Practice
  • 11 - Interactive Tornado Dashboard with Drill Downs
    11.1 Section Introduction0:41
    11.2 Setting up the Interactive Dashboard15:27
    11.3 Formatting the Interactive Dashboard1:49
    11.4 Maintaining the Interactive Dashboard2:58
    11.5 Practice 1
    11.6 Practice 2
  • 12 - Data Visualization
    12.1 Introduction to Visual Perception8:22
    12.2 The Gestalt Laws of Grouping4:37
    12.3 Preattentive Attributes2:34
    12.4 The Problem with Pie Charts1:45
    12.5 Introduction to Infographics2:01
    12.6 Quiz
  • 13 - Special Charts
    13.1 Expanding the Chart Library0:26
    13.2 Dual Axis Band Chart4:21
    13.3 Shaded Area Banded Chart4:31
    13.4 Limit and Control Charts3:11
  • 14 - Bullet Charts
    14.1 Introduction to Bullet Charts in Excel1:28
    14.2 Bullet Chart Demo7:00
    14.3 Horizontal Bullet Chart Trick4:03
    14.4 Practice
  • 15 - Infographics in Excel
    15.1 Introduction to Infographics in Excel1:17
    15.2 Progress Meter Chart8:44
    15.3 Donut Chart6:01
    15.4 "Waffle" Chart5:58
    15.5 Bringing it all together with the CAMERA2:13
    15.6 Practice
  • 16 - Conclusion
    Continue Learning!2:38

Advanced Excel Dashboards & Data Visualization Masterclass

JG
Jordan Goldmeier

Jordan Goldmeier | Chief Data Anarchist

4.3/5 Instructor Rating: ★ ★ ★ ★ ★ ★

Jordan Goldmeier is an internationally recognized analytics professional and data visualization expert, author and speaker. A former chief operations officer at Excel.TV, he has spent years in the data training trenches. He is the author of Advanced Excel Essentials and Dashboards for Excel, and currently working on this 3rd book, Becoming a Data Head (Wiley, 2021), on helping managers communicate, challenge, and understand data science with a common language and expectation.

Description

In this course, you will take a quick dive into concepts such as Array Formulas and formula-driven developments. As you progress, you will see how each module builds from top to bottom. Also, you will be exposed to often overlooked features such as Excel's form controls, which can drive tremendous interactivity. At the same time, you will run through the rules of data visualization, making sure that what you build communicates its message. By the end of this course, you won't just be good at data visualization and dashboards, but also, you will become a master Excel builder.

4.3/5 average rating: ★ ★ ★ ★ ★ ★

  • Access 85 lectures & 6 hours of content 24/7
  • Learn advanced skills to create dashboards & data visualizations in Excel
  • Quickly create dashboards, reports & interactive applications without macros
  • Use Microsoft Excel with confidence
  • Get downloadable Excel workbooks to practice on
  • Attain personal Excel support from professional Excel trainers
  • Become expert at creating interactive analysis
  • Be more productive at using Microsoft Excel
  • Increase your Microsoft Excel skills & knowledge within hours
  • Test your skills with different real life quizzes, homework, practice activities, & assignments
Note: Software NOT included

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Excel for Windows 2010, 2013, 2016, 2019
  • Office 365
  • Excel for Mac 2011 and 2016

Terms

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