Excel: Analytics Tips

Offered By: LinkedIn Learning

Tags

Data Analysis Courses Forecasting Courses Data Modeling Courses Monte Carlo Simulation Courses Power Query Courses Outlier Detection Courses Goal Seek Courses

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

1. 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

Conclusion: Analytics tips

Taught by

Chris Dutton

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Math behind Moneyball
University of Houston System via Coursera La gestión de los riesgos y la administración de los cambios en el proyecto
University of California, Irvine via Coursera Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera Managing Uncertainty in Marketing Analytics
Emory University via Coursera