The Ultimate Microsoft Excel Certification Training Bundle

377 Reviews
106197 Enrolled
6 Courses & 33.5 Hours
$42.99 CAD$68.00 CAD
37% Off

What's Included

Microsoft Excel: Advanced Excel Formulas & Functions
Microsoft Excel: Advanced Excel Formulas & Functions
Microsoft Excel: Advanced Excel Formulas & Functions
  • 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)

  • Your First Program
  • 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

Note: Software NOT included.

Specs

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Microsoft Excel required
  • Have questions on how digital purchases work? Learn more here

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.
377 Reviews
4.7/ 5
All reviews are from verified purchasers collected after purchase.
KW

Kenneth Whitted

Verified Buyer

Great product and excellent training!! I'm extremely satisfied with my purchase and had no issue redeeming the code and getting started on the training. The remote learning sessions are high quality and stream smoothly -- with no issues. The instructor is excellent; he's easily understood and conveys the material in a clear and concise manner. Even though I consider myself an 'intermediate level' user of EXCEL, I happily discovered a lot of valuable tips & tricks in the first two lessons which I was unaware of. Although I'm still early in the training bundle, I'm excited and looking forward to acquiring an "ADVANCED" level of proficiency using the techniques available in my EXCEL 2019 product. Kenneth W. Omaha, NE

Jun 26, 2024
FB

Fernando Bonillas

Verified Buyer

The video is very detailed and explained clearly. Each one of the options being taught is concise and to the point. Thank you.

Feb 14, 2023
KF

Kimberly Forrest

Verified Buyer

The Lessons were very easy to follow along great courses from the introduction all the way to the expert courses. will be using for more courses.

Jan 7, 2023
A2

Az 22

Verified Buyer

A very valuable bundle of courses. You'll learn a lot about Excel formulas and functions, Data Analysis, Macros and VBA. The courses are labeled as for all levels, but I personally think you'll need a little experience with Excel as the courses are mostly for intermediate users, in my opinion.

Dec 3, 2022
BS

Bela Sveda

Verified Buyer

It is very good training for Excel. Even though i am advanced, there are things that i didn't know. Great course to take for any level.

Oct 11, 2022
GH

Gloria Hughes

Verified Buyer

It's got everything that I've been wanting to learn or refresh on. It has the beginning and advanced courses, then you can proceed to the more advance options. Being able to pick and choose the course or doing it in the order you want

Jul 5, 2022
Your Cart
Your cart is empty. Continue Shopping!
Processing order...