The All-In-One Microsoft Excel Certification Training Bundle

11 Reviews
1419 Enrolled
10 Courses & 52 Hours
$33.99$150.00
You save 77%

What's Included

Advanced Excel Dashboards & Data Visualization Masterclass
  • 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
  • 2 - Thinking Outside the Cell
  • 3 - Working with Formulas
  • 4 - Advanced Formulas for Dashboards & Decisions
  • 5 - Excel Tables are the Best!
  • 6 - Sorting and Decision Functions
  • 7 - Form Controls for Interactivity
  • 8 - Formula-driven Development
  • 9 - Creating an Interactive Legend Dashboard
  • 10 - Creating an Interactive Chart Dashboard
  • 11 - Interactive Tornado Dashboard with Drill Downs
  • 12 - Data Visualization
  • 13 - Special Charts
  • 14 - Bullet Charts
  • 15 - Infographics in Excel
  • 16 - Conclusion

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

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
11 Reviews
4.6/ 5
All reviews are from verified purchasers collected after purchase.
DH

David Higgins

Verified Buyer

This is really good. I know excel reasonably well but haven't used it properly for a while. This is a really good refresher course but the later more tricky stuff is really comprehensive and I'm learning a lot. The only slight problem is that it's geared up for windows users. On my Mac its a slight problem so particularly with keyboard shortcuts one has to find workarounds. All in all though, a really good course and a great price from Macworld.

Nov 8, 2022
RB

Robert Boyle

Verified Buyer

This is an unbelievable course. I love it. It’s so simple to follow along, and you can take your time with it too. I do about 10 mins every morning, and my excel skills have seen a significant increase ever since. I feel like an expert!! I haven’t even tapped into the other courses that are available yet (PowerBi etc), so I’m very excited about these too!

Oct 25, 2021
CW

Chris Welman

Verified Buyer

So comprehensive, and the videos are very well paced and explained, along with example documents to follow in.

Jul 23, 2021
WM

William Mills

Verified Buyer

Fantastic instructor with a great teaching pace. I've learned things about Excel that I never knew existed.

Jun 28, 2021
TT

Thomas Theodorus Rogers

Verified Buyer

The explanations are clear and easy to understand and follow. Enjoy the fact that I can watch any portion over and over until I know what to do and why it is important. The exercise files are also great.

Jun 28, 2021
Hugh Rafferty profile picture

Hugh Rafferty

Verified Buyer

Very easy to follow and a great future reference. I would recommend this to both beginners and experienced users of Excel. Very satisfied.

Jun 26, 2021
Your Cart
Your cart is empty. Continue Shopping!
Processing order...