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 Hours3 hours

Skills Learned

Data Analysis

Tools

Excel

Course Level

Advanced

Credentials

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 CURRICULUM:

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

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

Meet Your Instructor

Chris Dutton

Founder & Lead Instructor

Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.

Qualifications

Best-selling Analytics & BI instructor
Certified Microsoft Excel Expert

Testimonials

"The 5-star tips are challenging, but incredibly powerful. Even though I'm a fairly frequent Excel user and have been for several years, I learned quite a bit that I can immediately apply to my work as a data analyst!"

- David G.
"Great course. Really diverse but well organized collection of tips and tools to bring the potential of Excel to life. As always, Chris is engaging and fun, while professionally delivering clear and concise explanations and examples."

- Gary F.
"I took this course specifically for the 16 minute segment on CUBE formulas, and it did not disappoint! It was awesome. Thank you, Chris, can't wait to dive into the rest!"

- Joseph T.

Ready to become a

data rockstar?

Start learning for free, no credit card required!