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
Course Level

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


  • 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


  • 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

Start learning for FREE, no credit card required!

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?

Start learning for free, no credit card required!

Sign Up for Free