Advanced Excel and Analytics Course
Who is Dr. Wayne Winston
and how can his Advanced Course help you?
0 +
Tutorials
0 +
Hours Of Content
0 +
Downloadable Files
Why Should You Enroll in The Advanced Course?
Trusted by the most data driven companies worldwide
Get the Advanced Course for Just $397

This course builds upon his 40 years of experience helping virtually all of the Fortune 500 companies through his books or in person training.

Give us a try and if at anytime in the first 30 days you are unsatisfied, just reach out and we will give you a 100% refund.

No questions asked.

Unlock Lifetime Access
to this Course

Range Name Tricks
This video shows how to use a named row in a formula and create ranges based on Excel formulas.

Implicit Intersection
This video shows how to pick off an entry in an array by simply typing the row and column headings.

Clean Function
This video shows how to Use the CLEAN, FIND, and SUBSTITUTE functions to remove invisible characters from your data.

Clean Function
This video shows how to Use the CLEAN, FIND, and SUBSTITUTE functions to remove invisible characters from your data.

Flash Fill
This video shows how to use FLASH FILL in Excel 2013 and 2016 to automatically perform the work of text functions.

Control + E and Flash Fill
In this video we show how Control + E makes Flash Fill perform better.

The TEXT Function
In this video we show how the TEXT function can ensure that a value in one cell is converted in a different cell to any desired number format.

Auditing
This video shows how to use Precedents to see which cells are needed to compute a formula and using Dependents to find cells that are dependent on spreadsheet inputs.

Circular Reference
This video shows how circular references can be used and resolved.

Flatten Table
This video shows how to use IF statements to extract the data in a 20 row by 12 column table into 240 different rows.

Error Trap
This video shows how to use the IFERROR function to remove error messages from your spreadsheets. It also covers the AGGREGATE function which allows you to ignore error values in calculations.

IF Statements And Sales Commission Calculations Part Two
In this video we use VLOOKUP, MATCH, INDEX, And IF functions to model a complex sales incentive plan.

One Way Data Table
This video shows how to use a One Way Data Table to determine how changing a single spreadsheet input affects multiple outputs.

Two Way Data Table
This video shows how to use a Two way data table to determine how changes in two spreadsheet inputs affect a single output.

Mortgage Data Table
This video shows how to use a Two way data table to determine how the monthly payment on a loan depends on the loan size and annual rate.

Goal Seek
This video shows how Goal Seek can be used to determine the number of unit sales needed for a juice bar to break even.

Goal Seek Finance
This video shows how to use Goal Seek to determine the annual rate on a loan that makes the monthly payment hit a desired value.

Data Table Chart
In this video we show how to create a chart to summarize the numbers in a two-way data table.

Accordion Content
Accordion Content
Accordion Content
Accordion Content
Accordion Content
Accordion Content
Unlock Lifetime Access

Billing detail

Checkout ID not found

It seems that this is not the CartFlows Checkout page where you have added this shortcode. Please refer to this article to know more.

Best Course I've Taken

5/5

Best professor I’ve ever had. I’d take him for anything and think he could teach anything, but Decision modeling in spreadsheets was the best, most relevant (for a finance major like me at least) class I had as an MBA student. Hope you are well Professor Winston!

Todd Williams

Perfect Course!

5/5

Im on day 4 and already feeling more knowledgeable and empowered!

Jeff Skirvin

Amazing & Useful Content

5/5

Ive enjoyed the training very much. Ive been using excel for many years, but with Waynes training, Ive been able to do things quicker which saves me time and allows me to complete my projects faster. I recommend this training. Its awesome. Thanks Wayne.

Luis Arroyo

Frequently asked questions
Is there a guarantee?

Yes! We offer a 30 day, no questions asked, money back guarantee. So if at anytime during the first 30 days you arent 100% satisfied, just let us know and we will refund the investment.

How long will I have access to the course?

How does forever sound? All of our courses offer lifetime access. So just invest in yourself once, and have the course forever (including all future videos).

Are the files included in the course?

Yes! Once you enroll, you can download any of the more than 1,500+ files. The before and after files are included in the course which will help you be able to easily follow along. Please note that the videos can not be downloaded.

Can I pay monthly?

Currently we only have lifetime plans.

How up to date is the course?

We add new content regularly. With OFFICE 365, there are new functions being released quarterly. So as they are released, we will make new content covering the functions. These updates are included in the lifetime access.

Is this course right for me?

The master course is Dr. Winstons lifes work and covers all things Excel. Dr. Winston has over 40 years of experience teaching at the top universities and Fortune 500 companies in the world as. Take a look above at any of the course outlines to see EXACTLY what you will learn.