Course curriculum

  • 1

    Catching errors & building trust with Excel

  • 2

    Excel as the path to exceptional teamwork

    • The stress Excel can cause and the stress it can eliminate

    • Building your team to leverage the tool

    • Maintaining a personal sense of integrity through the work

    • Thinking up and down the Excel “chain of custody”

    • Scrutinizing teamwork with the Socratic method
  • 3

    The 3 most common business challenges and how to handle them

    • Challenge 1: We've got a problem... What do we do about it?

    • Challenge 2: We want to do X... Can we justify it?

    • Challenge 3: We really want to avoid Y... Can we?

    • Presenting findings with strength and confidence

    • Preparing to defend your findings

    • How to walk your client through a thinking process
  • 4

    VBA: Powers and limitations

    • When to use VBA

    • When NOT to use VBA

    • How to approach learning VBA
  • 5

    Code Alongs

    • Code Along: Securing shared spreadsheets

    • Code Along: Securing data within a spreadsheet

    • Code Along: Solving complex problems in reverse
  • 6

    Bonus Content

    • BONUS: Manipulating data with VBA

    • BONUS: Automating term sheets