YoVDO

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

Clustering Geolocation Data Intelligently in Python
Coursera Project Network via Coursera Mining Data to Extract and Visualize Insights in Python
Coursera Project Network via Coursera 【キカガク流】人工知能・機械学習 脱ブラックボックス講座 - 中級編 -
Udemy Integrating Tableau and R for Data Science
LinkedIn Learning Tableau and R for Analytics Projects
LinkedIn Learning