Back to Course

Advanced Excel and Analytics Course

0% Complete
0/0 Steps
  1. OVERVIEW

    Sample Lessons
  2. COURSE CONTENT
    Range Names
    2 Topics
  3. Text Functions
    4 Topics
  4. Auditing Tools, Circular References, and IF Functions
    5 Topics
  5. Data Tables, Goal Seek, and Scenario Manager
    6 Topics
  6. Conditional Counts and Sums
    11 Topics
  7. Conditional Formatting and Data Validation
    7 Topics
  8. Tables
    10 Topics
  9. Pivot Tables
    14 Topics
  10. Descriptive Statistics
    7 Topics
  11. Trend Curve, Correlation, and Regression to the Mean
    12 Topics
  12. Multiple Regression
    12 Topics
  13. Probability
    7 Topics
  14. Random Variables
    7 Topics
  15. Array Formulas
    17 Topics
  16. Offset and Indirect Functions
    13 Topics
  17. Optimization and the Excel Solver
    25 Topics
  18. Forecasting
    11 Topics
  19. Charting
    6 Topics
  20. Power View
    5 Topics
  21. Monte Carlo Simulation
    14 Topics
  22. Advanced Solver
    17 Topics
  23. Advanced Charts
    10 Topics
  24. Macros
    10 Topics
  25. Supply Chain
    14 Topics
Lesson 1 of 25
In Progress

Sample Lessons

Wayne Winston July 29, 2015

Here are the free topics. One from each lesson.