Use Visual Basic VBA/Macros for Daily Fantasy Sports
Learn how to Use Visual Basic VBA/Macros for Daily Fantasy Sports
Learn how to use visual basic programming of spreadsheets in this mini course!
In this course I go over how to use macros and VBA to improve your daily fantasy sports spreadsheets. I teach the basic concepts I use to help speed up processing and tasks you do for daily fantasy with relatable, useful examples.
Check out the course content below to see exactly what you will learn in this course.
This course will NOT turn you into an expert in VBA. It will NOT teach you all the tools you need to scrape data from websites. To learn all of that, you'd many hours of video. This course will make you very good at visual basic. It WILL teach you how to perform many of the tasks you do now, but with macro code. It will improve your research time.
What Comes with this Course:
- 90 to 120 minutes of video on VBA
- The spreadsheets I use in the video to follow along
- Cheatsheet I made to help you along the way.
- Email support if you get questions
- Money back guarantee
Get started now!
This course was amazing! It helped me learn so much! I just cut my research time in half!
Course Curriculum
-
StartIntro & File downloads (4:05)
-
Start1: How to Start with VBA code (2:26)
-
Preview2: Using Macro Building to Write VBA Code (1:06)
-
Start3: How to Edit & Run a Macro (3:54)
-
Start4: Declaring Variables (3:39)
-
Start5: Cell Reference (4:33)
-
Start6: IF Statements (4:20)
-
Start7: For Loops (4:46)
-
Start8: Insert Comments into your Code (2:49)
-
Start9: Code to Stop Screen Updating (2:12)
-
Start10: How to Create a pop up Message Box (1:29)
-
Start11: Call Another Macro in your code (3:15)
-
Start12: Password Protect VBA Code (1:49)
-
Start13: Shortcut keys and Buttons to trigger macros (2:17)
-
Start14: Debugging Errors (2:39)
-
Start15: Find Correct Code with Macro Builder (2:53)
-
Start16: Example - Run Certain Code based on Value of Cell (5:20)
-
Start17: Using Input Box to Get Data from User (3:33)
-
Start18: Example - Refresh Web Data (4:19)
-
Start19: Run Macro upon Opening Workbook (2:55)
-
Start20 - Example - Copy Daily Game stats to Complete Game Log List (9:48)
-
Start21 : Example - Save sheet as csv file (3:24)
-
Start22: Example - Email a worksheet (4:08)
-
Start23: Create User Defined Functions (13:33)
Frequently Asked Questions
I was already somewhat proficient with excel as i had taken it back in school but Joe's videos took me to a whole new level and really made me fall in love with spreadsheets and ive been building and tweaking them for a couple of years. Ive been building for pga, nfl, nba and mlb for the most part but really only update the one for mlb and pga on a regular basis. Ive gone from manually cutting and pasting data to making most everything automated (i have to update the FD and DK dats manually daily but the stats auto download which saves me hours daily). At any rate, thank you joe!! - Robby H
Your Instructor
I have used Excel spreadsheets for almost 20 years to analyze data and have incorporated that into the world of Daily Fantasy sports. I have created spreadsheet tools for the last 5 years that over 4000 people have used . I also have a Youtube channel where I post some helpful videos and it has over 300,000 views.
This is my 3rd video course I have create around Excel spreadsheets. The first was a course called Master Excel Functions to teach people how to use Excel Formulas and functions. The second was a video course http://www.spreadsheetSchoolDFS.com which teaches people like you how to do better research for daily fantasy much faster.
I am married and have two kids where I spend most of my time. But I love helping people learn Excel and I hope you give me the chance to teach you!