The All-In-One Microsoft Excel Certification Training Bundle

11 Reviews

1402 Enrolled

10 Courses & 52 Hours

$33.99$150.00

You save 77%

What's Included

$15.00 Value

Advanced Excel Dashboards & Data Visualization Masterclass

Jordan Goldmeier

85 Lessons (6h)

Lifetime

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
Preview

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

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
Have questions on how digital purchases work? Learn more here

Requirements

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

$15.00 Value

Google Sheets for Excel Users

Yoda Learning

10 Lessons (1h)

Lifetime

$15.00 Value

Master all the MS Excel Macros and the basics of Excel VBA

Yassin Marco

20 Lessons (4h)

Lifetime

$15.00 Value

Microsoft Excel: Intro to Power Query, Power Pivot & DAX

Maven Analytics

90 Lessons (7h)

Lifetime

$15.00 Value

Microsoft Excel: Advanced Formulas & Functions

Maven Analytics

113 Lessons (8h)

Lifetime

$15.00 Value

Up & Running with Power BI Desktop

Maven Analytics

116 Lessons (10h)

Lifetime

$15.00 Value

Microsoft Excel: Data Analysis with Excel Pivot Tables

Maven Analytics

85 Lessons (5h)

Lifetime

$15.00 Value

Data Science with Stocks, Excel and Machine Learning

Mammoth Interactive

46 Lessons (4h)

Lifetime

$15.00 Value

Microsoft Excel (365): Crash Course

Earn and Excel

84 Lessons (6h)

Lifetime

$15.00 Value

Excel for HR Dashboard and Analytics

Yoda Learning

8 Lessons (1h)

Lifetime

Terms

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

Your cart is empty. Continue Shopping!

Processing order...