Comprehensive Toolset

Access a range of tools including Excel, Python, Action Tracker, and PowerPoint to boost your Streamliners performance.

Expert Guidance

Learn from industry experts to enhance your skills and streamline your workflow effectively.

Hands-On Experience

Gain practical experience and apply your knowledge in real-world scenarios to maximize your productivity.

About the Course

Welcome to the Streamliners Toolbox - your gateway to mastering essential tools for success at Streamliners. This course equips you with the skills and knowledge you need to excel in your Streamliners journey. From Excel to Python, our Action Tracker, and PowerPoint, discover the key to unlocking your full potential in the Streamliners environment. Join us and take your performance to the next level! Enroll now to begin your transformation.

Meet Your Instructor

Hi, I'm Andreas Haag, your guide on this exciting learning journey. With years of experience in Streamliners and a passion for teaching, I'm here to share my expertise and help you succeed. Join me in exploring the Streamliners Toolbox and unleash your true potential. Let's embark on this educational adventure together!

Curriculum

6 Chapters · 68 Lessons

  1. 1

    Toolbox 1: Spreadsheet Basics

    1. (Included in full purchase)

      Introduction to Spreadsheets

    2. (Included in full purchase)

      Spreadsheet Layout

    3. (Included in full purchase)

      Identifying Cell Values

    4. (Included in full purchase)

      Spreadsheet Functions

    5. (Included in full purchase)

      SUM function

    6. (Included in full purchase)

      Commonly Used Functions

    7. (Included in full purchase)

      Simple single parameters functions

    8. (Included in full purchase)

      Common multiple parameters functions

    9. (Included in full purchase)

      Advanced Functions

    10. (Included in full purchase)

      SUMPRODUCT Function

    11. (Included in full purchase)

      IF Function

    12. (Included in full purchase)

      Working with Data Files

    13. (Included in full purchase)

      Part 1: Median Sales

    14. (Included in full purchase)

      Part 2: Coefficient of Variation

    15. (Included in full purchase)

      Part 3: Total Cost

    16. (Included in full purchase)

      Part 4: Counting Big Sellers

    17. (Included in full purchase)

      Solutions for sample spreadsheets

  2. 2

    Toolbox 2: Introduction to Python Basics

    1. (Included in full purchase)

      Using Google Colab

    2. (Included in full purchase)

      Variables and Types

    3. (Included in full purchase)

      Creating and Overwriting Variables

    4. (Included in full purchase)

      Types

    5. (Included in full purchase)

      Printing

    6. (Included in full purchase)

      Printing the Output of Operations

    7. (Included in full purchase)

      Strings

    8. (Included in full purchase)

      String Formatting

    9. (Included in full purchase)

      Operators

    10. (Included in full purchase)

      Strings and Mathematical Operators

    11. (Included in full purchase)

      Common Mathematical Operations

    12. (Included in full purchase)

      Data Structures

    13. (Included in full purchase)

      Concatenating Lists

    14. (Included in full purchase)

      Lists

    15. (Included in full purchase)

      Dictionary

    16. (Included in full purchase)

      Data Structure Functions

    17. (Included in full purchase)

      Looping and Iteration

    18. (Included in full purchase)

      For Loop

    19. (Included in full purchase)

      While Loops

    20. (Included in full purchase)

      List Comprehension

    21. (Included in full purchase)

      Functions

    22. (Included in full purchase)

      Functions

    23. (Included in full purchase)

      Pip, Importing, and Help

    24. (Included in full purchase)

      Methods and Classes

  3. 3

    Toolbox 3: Wolfram Alpha

    1. (Included in full purchase)

      Contents

    2. (Included in full purchase)

      Video 1: Basics

    3. (Included in full purchase)

      Video 2: Special Cases

  4. 4

    Toolbox 4: Regression in Excel

    1. (Included in full purchase)

      Contents

    2. (Included in full purchase)

      Recitation 1E: Excel | Data Analysis in Excel

    3. (Included in full purchase)

      Recitation 2E: Excel | Regression in Excel Part 1

    4. (Included in full purchase)

      Recitation 3E: Excel | Regression in Excel Part 2

  5. 5

    Toolbox 5: Hypothesis Testing Step-by-Step

    1. (Included in full purchase)

      Contents

    2. (Included in full purchase)

      Question 1 - Prediction and Confidence Intervals

    3. (Included in full purchase)

      Solution to Question 1 - Prediction and Confidence Intervals

    4. (Included in full purchase)

      Question 2 - Two-tailed Hypothesis Test

    5. (Included in full purchase)

      Solution to Question 2 - Two-tailed Hypothesis Test

    6. (Included in full purchase)

      Question 3 - Right-tailed Hypothesis Test

    7. (Included in full purchase)

      Solution to Question 3 - Right-tailed Hypothesis Test

  6. 6

    Toolbox 6: Optimization using Spreadsheets

    1. (Included in full purchase)

      Optimization using Spreadsheets

    2. (Included in full purchase)

      Blink Problem: Part 1

    3. (Included in full purchase)

      Video 1 - Solving Part 1

    4. (Included in full purchase)

      Blink Problem: Part 2

    5. (Included in full purchase)

      Video 2 - Solving Part 2

    6. (Included in full purchase)

      Blink Problem: Part 3

    7. (Included in full purchase)

      Video 3 - Solving Part 3

    8. (Included in full purchase)

      Blink Problem: Part 4

    9. (Included in full purchase)

      Video 4 - Solving Part 4

    10. (Included in full purchase)

      Blink Problem: Part 5

    11. (Included in full purchase)

      Video 5 - Solving Part 5

    12. (Included in full purchase)

      Blink Problem: Key Takeaways

    13. (Included in full purchase)

      How to Debug your Optimization Model

Ready to Elevate Your Streamliners Skills?

Join now to access the Streamliners Toolbox and revolutionize your approach to Streamliners.

Please contact us for access. (opens email in new window)