The Professional Microsoft Excel Certification Training Bundle

70 Reviews
14264 Enrolled
8 Courses & 45 Hours
$39.00$1,600.00
You save 97%

What's Included

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

Course Curriculum

101 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 Formulas & Functions

CD
Chris Dutton

Instructor

Chris 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. Upon completion of this course, and all courses included in the bundle, you'll also receive a certification of completion validating your new skills! This is especially useful for including in your portfolio or resume, so future employers can feel confident in your skill set.

  • Access 101 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
  • Includes a certification of completion

Specs

Important Details

  • 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

Requirements

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

Lee McKee

Verified Buyer

It will teach me more about Excel. I need to know more about Pivot Tables, and all of the formulas that are involved in this MS product.

Apr 13, 2022
TO

Thomas Owens

Verified Buyer

Great Product!!! This is a fantastic tool to learn and expand your excels knowledge. You do not know what you do not I is.

Mar 27, 2022
MB

Monica Bosquez

Verified Buyer

awesome instruction with material included, and good practice helped me understand excel better and work more efficiently.

Mar 27, 2022
JJ

Joshua Jones

Verified Buyer

I love the price point of the product. I also like that this is a professional certificate and not just additional training.

Feb 22, 2022
JB

Joaquim Bento

Verified Buyer

I have been using Excel for a while now but it was anazing to learn some new amazing and useful tips and tricks just in the beggining of the course...power query/pivot couldn't have come in a better moment...I have been putting it to use right away! ☆☆☆☆☆

Feb 17, 2022
DM

Danza Martin

Verified Buyer

Seems To be a great course so far. It’s extensive and lots of info. Glad I purchased. We use a lot of excel at work so this is a plus to have!

Nov 8, 2021
Your Cart
Your cart is empty. Continue Shopping!
Processing order...