Part 1 - Session 1: Fast Formula Building - Your First Data Analysis
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
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
2 Lessons