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!