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

Microsoft Power BI: Advanced Data Analysis and Visualisation
Cloudswyft via FutureLearn Advanced Data Modeling
Meta via Coursera Advanced Monitoring and Optimizing with DynamoDB (Simplified Chinese)
Amazon Web Services via AWS Skill Builder Advanced Monitoring and Optimizing with DynamoDB (Japanese)
Amazon Web Services via AWS Skill Builder Advanced Monitoring and Optimizing with DynamoDB (German)
Amazon Web Services via AWS Skill Builder