Excel Pro Tips: Analytics Tools

Explore powerful analytics tools like forecasting, optimization, and monte carlo simulation

What's Inside

ABOUT THE COURSE



This course is part of the Excel PRO TIPS series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs.

The series includes six separate Excel courses, including:

  • Excel Pro Tips: Productivity Tools
  • Excel Pro Tips: Formatting
  • Excel Pro Tips: Formulas & Functions
  • Excel Pro Tips: Data Visualization
  • Excel Pro Tips: PivotTables
  • Excel Pro Tips: Analytics Tools

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.



IMPORTANT NOTES:

  • This is a non-linear series, so you can jump to individual courses or lectures freely. Each video is an independent and self-contained demo, to help you learn with quick, bite-sized lessons.
  • Course includes a PDF ebook and downloadable Excel project file containing all demos and datasets, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick access.

COURSE REQUIREMENTS:

  • Microsoft Excel 2007-2019 or Office 365 recommended (some tips may not apply to all versions)
  • This course is designed for PC users (some tools may not be available for Mac)

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

Get started now!



Certificate Available
46724+ Students
20 Lectures
2+ Hours of Video
Lifetime Access
24/7 Support
Instructor Rating
Maven Analytics

Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers.

Named one of the top 10 education companies revolutionizing the industry, Maven's award-winning Guided Learning model allows users to create personalized learning plans, build public portfolios, connect with expert instructors and career coaches, and join a community of world-class analytics talent.

We've helped 1,000,000+ students build job-ready skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundation for a successful career.

Start learning and build your FREE portfolio at www.mavenanalytics.io

Popular Bundles