Excel: Analytics Tips
Offered By: LinkedIn Learning
Course Description
Overview
Leverage some of the most powerful analytics techniques for Excel. Learn how to conduct outlier detection, perform Monte Carlo simulations, use CUBE functions, and more.
Syllabus
Introduction
- About the Pro Tip series
- Analytics tips
- Quick Analysis toolset
- 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)
- Conclusion: Analytics tips
Taught by
Chris Dutton
Related Courses
Microsoft Excel Pro Tips: Excel from Beginner to AdvancedUdemy Excel Básico Avançado 5 Cursos - Formação Especialista
Udemy Data Analytics for Pricing Analysts in Excel
LinkedIn Learning Learning Excel What-If Analysis
LinkedIn Learning Excel: Top 10 Tips to Become Better in Excel
Skillshare