The Ultimate Microsoft Excel Certification Training Bundle

12 Reviews
2967 Enrolled
6 Courses & 33.5 Hours
$33.99$120.00
You save 71%

What's Included

Microsoft Excel: Advanced Excel Formulas & Functions
Microsoft Excel: Advanced Excel Formulas & Functions
Microsoft Excel: Advanced Excel Formulas & Functions
  • Certification included
  • Experience level required: All levels
  • Access 93 lectures & 6 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

93 Lessons (6h)

  • Getting Started
  • Excel Formulas 101
  • Conditional Statements & Logical Operators
  • Statistical Functions
  • Lookup & Reference Functions
  • Text Functions
  • Date & Time Functions
  • Formula-Based Formatting
  • Basic Array Formulas
  • Badass Bonus Functions
  • Wrapping Up

Microsoft Excel: Advanced Excel Formulas & Functions

EM
Excel MavenChris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Description

It's time to show Excel who's boss! Whether you're starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Through hands-on, contextual examples, you'll learn why these formulas are awesome and how they can be applied in a number of ways. This is especially useful for including in your portfolio or resume, so future employers can feel confident in your skill set.

  • Access 93 lectures & 6 hours of content 24/7
  • Easily build dynamic tools & Excel dashboards to filter, display, & analyze your data
  • Go rogue & design your own formula-based formatting rules
  • Join datasets from multiple sources in seconds w/ lookup, index, & match functions
  • Pull real-time data from APIs directly into Excel
  • Manipulate dates, times, text, & arrays
  • Automate tedious & time-consuming analytics tasks using cell formulas and functions in Excel

Specs

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Microsoft Excel required

Compatibility

  • Internet required

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
12 Reviews
4.8/ 5
All reviews are from verified purchasers collected after purchase.
Michael Anderson profile picture

Michael Anderson

Verified Buyer

It’s a complete Excel course. It seems like all of the Excel procedures and tricks were covered. Full understandable explanations and thorough exercises.

Feb 7, 2022
SF

Stephen Fort

Verified Buyer

With this instruction it took a lot of the mystery away and made things a lot easier to understand. I would recommend this bundle of courses to anyone that wants to improve themselves. Regardless the level of experience beginner to advanced.

Jul 7, 2021
JP

James Potts

Verified Buyer

Great training tool. ................... Very Good Product.................. Easy to use........................................

Mar 3, 2021
JM

Jessica Morrell

Verified Buyer

I’ve only started the first module, but I have already learned so much. This is a great way to enhance and build upon your current excel knowledge. The videos/modules are easy to follow and work along with. I’m very happy with this purchase!

Dec 29, 2020
EH

Erin Huston

Verified Buyer

I've always wanted to learn more about formulas and pivot tables. For the price, this was a no-brainer!

Sep 9, 2020
DS

David Sullivan

Verified Buyer

Well developed Excel training for people that have not used Excel professionally. Good training to use to expose yourself to Excel and become proficient.

Jun 2, 2020
Your Cart
Your cart is empty. Continue Shopping!
Processing order...