Excel Pro Tips: Analytics
Sample some of Excel’s most powerful advanced analytics tools, including forecasting, outlier detection, optimization, Monte Carlo simulation, and more.
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!
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 Structure & Outline
- DOWNLOAD: Course Resources
- Setting Expectations
- Quick Analysis Tools
- Scenario Manager
- Optimization with Goal Seek
- Basic Forecasting
- Outlier Detection
- Automated Data Tables
- Power Query Tools
- Data Modeling 101
- CUBE Functions
- Monte Carlo Simulation
- Advanced Optimization with Solver
- Analysis ToolPak (Preview)
- QUIZ: Analytics Tips
- Next Steps
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
Ready to become a
Start learning for free, no credit card required!