The Ultimate Microsoft Excel Business Intelligence Certification Bundle

4 Reviews
601 Enrolled
12 Courses & 42 Hours
$44.99$180.00
You save 75%

What's Included

Microsoft Excel: Advanced Formulas & Functions
  • Experience level required: Intermediate
  • Access 114 lectures & 8 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

114 Lessons (8h)

  • 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
  • Extra Bonus Functions
  • Wrapping Up

Microsoft Excel: Advanced Formulas & Functions

MA
Maven Analytics

Maven Analytics

4.6/5 Instructor Rating: ★ ★ ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★ ★ ★

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 of transforming 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 several ways. This is especially useful for including your portfolio or resume so that future employers can feel confident in your skillset.

4.6/5 average rating: ★ ★ ★ ★ ★ ★

  • Access 114 lectures & 8 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

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: intermediate
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2007 - 2019 or Office 365

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...