Your Cart

Processing order...

The Personal & Business Finance Super Bundle

Name: The Personal & Business Finance Super Bundle
Brand: Jordan Goldmeier
Price: 34.99 USD
Availability: InStock
Rating: 5 (2 reviews)

2 Reviews

162 Enrolled

12 Courses & 68 Hours

Deal Price$34.99

Suggested Price

$108.00

You save 67%

What's Included

$9.00 Value

Advanced Excel Dashboards & Data Visualization Masterclass

Jordan Goldmeier

85 Lessons (6h)

Lifetime

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 GoldmeierJordan 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 an 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

$9.00 Value

Accounting in Only ONE Hour! Learn all 3 Financial Statements

Son Han

17 Lessons (1h)

Lifetime

$9.00 Value

Tax Accounting

Skill UP

11 Lessons (2h)

Lifetime

$9.00 Value

Financial Accounting: Payroll

Robert Steele

43 Lessons (6h)

Lifetime

$9.00 Value

QuickBooks Desktop Pro Personal Tax Tracking Tricks

Robert Steele

36 Lessons (4h)

Lifetime

$9.00 Value

Personal Finance Masterclass

Phil Ebiner

102 Lessons (6h)

Lifetime

$9.00 Value

Excel Financial Analysis

John Bura

29 Lessons (5h)

Lifetime

$9.00 Value

Introduction to Finance, Accounting, Modeling and Valuation

Chris Haroun

44 Lessons (4h)

Lifetime

$9.00 Value

Hedge and Mutual Fund Careers: The Complete Guide

Chris Haroun

99 Lessons (7h)

Lifetime

$9.00 Value

The Personal Finance Course: Save, Protect, Make More

Chris Haroun

107 Lessons (12h)

Lifetime

$9.00 Value

The Beginners Guide to Personal Finance & Wealth Building

Bryan Guerra

140 Lessons (13h)

Lifetime

$9.00 Value

Financial Mathematics: Concepts, Calculations & Applications

Starweaver Group

30 Lessons (2h)

Lifetime

Terms

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

2 Reviews

5/ 5

All reviews are from verified purchasers collected after purchase.

Low Huan Seng

Verified Buyer

I love the products so much, it really worth of money. It consist most of the financial knowledge I'm exploring.

Feb 14, 2021

David onyango

Verified Buyer

This fast-paced world is full of uncertainty. It provides me with the knowledge that I can obtain because of time constraints.

Jan 31, 2021

The Personal & Business Finance Super Bundle

2 Reviews

162 Enrolled

12 Courses & 68 Hours

Deal Price$34.99

Suggested Price

$108.00

You save 67%

What's Included

$9.00 Value

Advanced Excel Dashboards & Data Visualization Masterclass

Jordan Goldmeier

85 Lessons (6h)

Lifetime

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

Description

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 an 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

$9.00 Value

Accounting in Only ONE Hour! Learn all 3 Financial Statements

Son Han

17 Lessons (1h)

Lifetime

$9.00 Value

Tax Accounting

Skill UP

11 Lessons (2h)

Lifetime

$9.00 Value

Financial Accounting: Payroll

Robert Steele

43 Lessons (6h)

Lifetime

$9.00 Value

QuickBooks Desktop Pro Personal Tax Tracking Tricks

Robert Steele

36 Lessons (4h)

Lifetime

$9.00 Value

Personal Finance Masterclass

Phil Ebiner

102 Lessons (6h)

Lifetime

$9.00 Value

Excel Financial Analysis

John Bura

29 Lessons (5h)

Lifetime

$9.00 Value

Introduction to Finance, Accounting, Modeling and Valuation

Chris Haroun

44 Lessons (4h)

Lifetime

$9.00 Value

Hedge and Mutual Fund Careers: The Complete Guide

Chris Haroun

99 Lessons (7h)

Lifetime

$9.00 Value

The Personal Finance Course: Save, Protect, Make More

Chris Haroun

107 Lessons (12h)

Lifetime

$9.00 Value

The Beginners Guide to Personal Finance & Wealth Building

Bryan Guerra

140 Lessons (13h)

Lifetime

$9.00 Value

Financial Mathematics: Concepts, Calculations & Applications

Starweaver Group

30 Lessons (2h)

Lifetime

Terms

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

2 Reviews

5/ 5

All reviews are from verified purchasers collected after purchase.

Low Huan Seng

Verified Buyer

I love the products so much, it really worth of money. It consist most of the financial knowledge I'm exploring.

Feb 14, 2021

David onyango

Verified Buyer

This fast-paced world is full of uncertainty. It provides me with the knowledge that I can obtain because of time constraints.

Jan 31, 2021

The Personal & Business Finance Super Bundle | StackSocial