Excel (VBA) For Football Traders - Member Question Videos
- Buy now
- Learn more
#1 - Ian D - How To Work With Scores In Excel

Member Video #1.mp4
Value Database Simple START.xlsx
Value Database Simple END.xlsx
#2 - Various - Dynamic Data Ranges Using INDIRECT

Member Video #2.mp4
Dynamic Ranges Data File START.xlsm
Dynamic Ranges Data File END.xlsm
Dashboard Download File Simplified.xlsm
#3 - Jorgen B - How To Collate Data Into One File

Member Video #3
#4 - Various - Dynamic Data Ranges Using OFFSET

Member Video #4.mp4
Dynamic Ranges With Offset START.xlsm
Dynamic Ranges With Offset END.xlsm
#5 - Jorgen - How To Collate Data Into A Single File 2

Member Video #5.mp4
#6 - Neil - Return Row And Column Headers For Maximum Value In A Table

Member Video #6.mp4
Member Question #6 v2.xlsm
#7a - Alan - Working Out Long Formulae And Finding Alternatives

Member Video #7a.mp4
Sample File Vid 1 End.xlsm
Sample File Vid 1 Start.xlsm
#7b - Alan - Using DSUM To Substitute A Long Formula

Member Video #7b.mp4
Sample File Vid 2 Start.xlsm
Sample File Vid 2 End.xlsm
#7c - Alan - Writing 'Pseudo Code' For A VBA Macro

Member Video #7c
Sample File Vid 3 Start.xlsm
Sample File Vid 3 End.xlsm
#7d - Alan - Implementing, Testing And Improving A VBA Macro

Member Video #7d
Sample File Vid 4 Start.xlsm
Sample File Vid 4 End.xlsm
#8 - Chris - Creating A File Summary With INDIRECT

Member Video #8.mp4
EFT Content Navigator 220223.xlsm

Sample File Vid 3 End.xlsm

Lesson unavailable

Please login to your account or buy the course.