Your browser is not supported. Please download another browser to be able to use all of the Maven features.

Self-Paced Course

Excel Pro Tips: Analytics

Sample some of Excel’s most powerful advanced analytics tools, including forecasting, outlier detection, optimization, Monte Carlo simulation, and more.

Course Hours2 hours
Skills Learned
Data Analysis
Tools
Excel
Course Level
Advanced
Credentials
Paths

Not Sure Which COURSE or PATH is right for you?

Take our customized survey to find the perfect courses & paths for your skill level and goals!

Course Description

The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.

In this course we'll dive into some of Excel's advanced analytics tools, using a variety of unique, real-world demos and case studies. We'll forecast stock prices and monthly temperatures, build our own outlier detection tools, solve complex optimization problems, design Monte Carlo simulation models, create reports using CUBE functions, and much more.

It's time to start working smarter, not harder. If you're ready to step up your analytics game and see what Excel is really capable of, this is the course for you.

Course Outline

WHO SHOULD TAKE THIS COURSE?

  • Excel users who want to build custom models for forecasting or scenario testing
  • Analysts or BI professionals looking to leverage Excel's advanced analytics techniques (optimization, outlier detection, simulation, etc.)
  • Anyone seeking to explore some of Excel's most useful analytics tools & techniques

WHAT ARE THE COURSE REQUIREMENTS?

  • Microsoft Excel 2007-2019+ or Office 365 for PC/Windows (some demos require Power Query and Power Pivot, and may be unavailable for Mac or Excel Online)
  • Completing the full Power Query, Power Pivot & DAX course is recommended, but not required

Are you ready to become a DATA ROCKSTAR? Start learning today with your FREE 7-Day trial!

Every subscription includes access to the following course materials

  • Interactive Project files
  • Downloadable e-books
  • Graded quizzes and assessments
  • 1-on-1 Expert support
  • 100% satisfaction guarantee
  • Verified credentials & accredited badges
Sign Up Today

Ready to become a

data rockstar?

Sign up today for a 7-Day Free Trial and start learning today!

Sign Up for Free