How to Optimize Your Daily Fantasy Football Lineup with Excel and VBA

Jordan Williams, Excel/VBA Teacher for Fun, Useful Projects

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
14 Lessons (48m)
    • 1. Introduction

      0:49
    • 2. Data Input

      1:51
    • 3. Data Validation

      2:00
    • 4. Filter Data Paste

      3:42
    • 5. Filter VBA

      6:19
    • 6. Button Assignment

      3:30
    • 7. Transfer

      3:59
    • 8. Transfer1

      1:48
    • 9. Formulas1

      3:18
    • 10. Pivot

      3:56
    • 11. Finishing Touch

      4:50
    • 12. Formulas

      5:01
    • 13. Sorter

      3:09
    • 14. Solver

      3:27

About This Class

This class is for all skill levels in Excel as it is a step by step process.
This project is designed to teach you valuable skills in Excel and VBA while working on an interesting project that will impress your friends and family. I am not a proponent of spending hours on definitions or really trivial things that have no real world use. I believe in doing the work to learn something.
In this class, you will use IF formulas, Data Validation Tools, SumProduct formulas, Macro Recorders, and VBA editing. This class is designed for those that are interested in the functionality of Excel and not the theory.