Advanced Excel and Analytics Course
My Total Course Time:
My Course completion time:
Course Overview:If you have been using Excel for a while and struggled to accomplish some things your job requires and/or you want to learn a lot about the “analytics revolution”, then this course is for you. We cover advanced functions such as GETPIVOTDATA, OFFSET, and the INDIRECT function.
With regards to analytics, we cover all Excel statistical functions, the Excel Solver including the advanced Evolutionary Solver and GRG Multistart Engines, Monte Carlo Simulation, Multiple Regression, Logistic Regression, Classification, and Forecasting.
Overview:
- 26 Hours
- 500+ Files
- Nearly 250 videos
- Includes content from 20+ other courses
- Syllabus
Who Will Benefit?
Any professional that uses Microsoft Excel and wants to become more efficient with their time.
Course Content
Expand All
OVERVIEW
COURSE CONTENT
Range Names
2 Topics
Expand
Text Functions
4 Topics
Expand
Lesson Content
0% Complete
0/4 Steps
Lesson Content
0% Complete
0/5 Steps
Lesson Content
0% Complete
0/6 Steps
Tables
10 Topics
Expand
Pivot Tables
14 Topics
Expand
Lesson Content
0% Complete
0/14 Steps
Lesson Content
0% Complete
0/7 Steps
Lesson Content
0% Complete
0/12 Steps
Lesson Content
0% Complete
0/12 Steps
Probability
7 Topics
Expand
Lesson Content
0% Complete
0/7 Steps
Random Variables
7 Topics
Expand
Lesson Content
0% Complete
0/7 Steps
Array Formulas
17 Topics
Expand
Lesson Content
0% Complete
0/17 Steps
Lesson Content
0% Complete
0/25 Steps
Forecasting
11 Topics
Expand
Lesson Content
0% Complete
0/11 Steps
Charting
6 Topics
Expand
Lesson Content
0% Complete
0/6 Steps
Power View
5 Topics
Expand
Lesson Content
0% Complete
0/5 Steps
Lesson Content
0% Complete
0/14 Steps
Advanced Solver
17 Topics
Expand
Lesson Content
0% Complete
0/17 Steps
Advanced Charts
10 Topics
Expand
Lesson Content
0% Complete
0/10 Steps
Macros
10 Topics
Expand
Lesson Content
0% Complete
0/10 Steps
Supply Chain
14 Topics
Expand
Lesson Content
0% Complete
0/14 Steps
About Instructor
Wayne Winston
7 Courses
Preview this Course

Login
Accessing this course requires a login. Please enter your credentials below!