In the first video, we get to grips with a typical dataset that football traders like you might use. Keyboard shortcuts will get you using Excel like a pro and we learn and apply our first ones  - make sure you write them down! We take a simple system - always backing the home team - and use an IF formula to calculate winnings (and losses!) We also deal with how to efficiently copy down a formula and cover relative and absolute references.  Yes, you'll learn how to use those dollar signs! $$$

Topics And Techniques

  • Integrate A Formula Into A Dataset
  • Formula To Calculate Single Bet Profit / Loss
  • Relative And Absolute References In Excel
  • IF Formula
  • SUM Formula
  • Excel Keyboard Shortcuts