Spreadsheet School for Daily Fantasy Sports
Learn how to use Excel spreadsheets & Google Sheets to analyze Daily Fantasy stats
Winning at Daily Fantasy Sports is difficult. It takes a lot of time to research players and teams and construct your lineups. Even with extensive research, it is still very difficult to profit. There can be endless lineup possibilities which make difficult decisions.
Imagine if you had a way to speed up your research time...
Imagine if you had a way to make better, stat based decisions to build your lineups...
This course will take you from novice/Inexperienced Excel user to Advanced Excel user who can analyze Daily Fantasy data a lot faster than before...
We give you the knowledge to do better DFS research faster. This will help save you time and make smarter lineup decisions.
Your job in daily fantasy sports is to find players with competitive advantages to put in your lineups. One way to do this is through analyzing statistics. Learning history is a way to see what can happen in the future.
This is something the best DFS players in the world do daily. It can be real time consuming though.
Many people use spreadsheets to do this. They are a great analytical tool which allows you to find trends and perform statistical analysis and build lineups. This analysis can help you find great plays for the day.
However, it's not easy to know how to do this as Excel or Google Sheets can be complex.
That is why I created a course to teach Spreadsheets to daily fantasy sports players.
I have created many Youtube videos which have gotten incredible feedback so I decided to create a course of 75 plus videos together along with a 100 page write up to help explain these spreadsheets.
I go step by step so even beginners can follow. I also use many advanced techniques to teach even the advanced users some tricks.
This course will teach you ways to do your daily research in a quicker method while showing you how to find the stats that predict competitive advantages. I use specific Daily Fantasy examples and give you all the spreadsheet examples so you can follow along and LEARN!
So if you are interested in saving time and creating better lineups through spreadsheet research, read below what the course offers...
What Comes with this Course:
- Eight (8) hours of videos broken out into 75 to 80 bite sized video chunks of 5 to 10 minutes each
- 100 Page Ebook breaking out what you saw in the videos
- Top Priority Email Support from myself on questions you may get while going through this course.
- Facebook Group where people who bought this course can interact and discuss research and spreadsheets. I also get on it and answer questions and post content.
- All the examples spreadsheets I used during the videos so you can follow along better
- Usable Spreadsheet Optimizers for the Single Game slates for Fanduel and Draftkings
Bonus 1:Game Logs
You will get the game logs for the following sports and seasons, so you have data to do historical research. These gamelogs were copied right from the free websites online like NBA-Reference.com.
- NFL Football 4 seasons
- NBA Basketball 4 seasons
- NHL Hockey 2 seasons
- MLB Baseball 2 seasons
Bonus 2: Solver Examples
You get a spreadsheet with Solver set up to run lineups for most sports that Draftkings and Fanduel has.
Bonus 3: List of Sites to pull Data from
You get a list of websites that you can pull data from to use in your research.
Bonus 4: Learn the Basics of Excel Video course
Get free unlimited access to a beginner course in Excel to teach you the basics of Excel Functions. This is not geared towards daily fantasy but is a course to learn the basics of Excel over 75 minutes to get you up to speed in Excel if you have never used it before.
Module 1 - How to pull in Stats from the web
In this module I show you how to set up your spreadsheets to pull in stats from the web. I go into compiling multiple pages of stats into one page and also show how to use Google Sheets to pull in data along with the Excel Add in "Power Query". This will simplify the data collection process.
Module 2 - Finding Trends from Historical Data
In this module I show you how to research prior historical stats and game logs to find trends. These can be trends that all players are known for or individual trends. I show how to summarize this data and how to see which trends are statistically significant.
Module 3 - How to Make your Own Projections
In this module I show you how you can create your own projections based solely on statistical trends and your biases. I show how to apply the trends you found in module 2 and how to build your spreadsheets with advanced spreadsheet formulas.
Module 4 - Using Solver for Optimal Lineups
In this module I show how to use the Solver Add in to look at your data and create optimized lineups. I go over advanced features like stacking a team, or Including or excluding players, accounting for a flex spot and more.
Module 5 - Using Advanced spreadsheet Features for Stat analysis
In this module I go over advanced spreadsheet features and concepts like pivot tables, macros, and conditional formatting to review sports data. This analysis will help you determine various aspects of the game to help you make better player choices.
Module 6 - How to Analyze Past Draftkings Contest Data
In this module I show you how to take the export of Draftkings contests and analyze them. Knowing how the rest of people will pick will give you an advantage they don't have. I also show you how to find the top players and see their strategies in making multiple lineups. This can allow you to mimic certain strategies in your own contests.
Module 7 - How to Create Bulk Lineups withOut Using Solver
In this module I go step by step to creating bulk lineups/Optimal lineups based on salary and projection. These are created without using Solver but with using functions. This can be done in Google sheets or Excel. You can create 5000 lineups in 15 seconds if you wanted.
Module 8 - Single Game Slate
In this module I do a deep dive on the single game slates for the top sports. I show how to research past contests and I provide research reports from my research on tips on winning them. I also show how to build a lineup optimizer spreadsheet for the single game slate and give you a complete spreadsheet optimzer for Fanduel and Drafts for MLB, NFL, NHL, NBA and CFB.
Module 9 - How to make a Cheatsheet in Google Sheets
In this module I show you how to use Google Sheets to pull in stats from various websites to create a cheatsheet in Google Sheets. This can also be done in Excel. I use Baseball for the example in these videos but it can also be done in any of the sports with the same concepts.
Who is this course for?
- People who want to do their own research to find lineups but want to speed up their process
- People who don't want to use the "expert" picks that they are force fed
- People who enjoy working with data to do their research
- People who want to use past historical data to predict future outcomes
- People who want to advance their knowledge of spreadsheets to improve their odds of winning at daily fantasy
- People who want to save time in their research that they can spend with their family or hobbies.
Who this course is not for:
- People who want to push a button for their lineups and not do any research
- People who expect to win their first Million at daily fantasy without putting in effort
Winning at DFS isn't easy. It takes time and skill. This course will help you do your research faster and improve your odds of winning!
Get started now!
This course was amazing! It helped me learn so much! I just cut my research time in half!
I m writing to thank you. First of I had no knowledge of excel before I started dfs, I looked around for tools that would help me win. That's when I learned about optimizers, then I found out they have a monthly subscription. So I looked around and found your video on how to make an optimizer is the easiest to follow and understand out there. The knowledge you shared has also helped at work that I'm now proficient at excel to make spreadsheets that have greatly increased my productivity.
StartModule 1-1 - Pulling Web Data into your Spreadsheet (5:48)
StartModule 1-2 Pulling Salary Information (2:46)
PreviewModule 1-3 Combining Data into one Table (5:01)
StartModule 1-4 Using a Names tab to Eliminate Spelling Issues (5:39)
StartModule 1-5 Getting rid of error messages (1:54)
StartModule 1-6 - How to Manipulate the Pulled data (5:56)
StartModule 1-7 Using Google Sheets to Pull Web Data (4:15)
StartModule 1-8 Using Power Query to Pull Web Data (5:56)
StartModule 2-1 - Introduction to Finding Trends (1:43)
StartModule 2-2 - Sorting the Data Before Finding Trends (1:38)
StartModule 2-3 - Reviewing your data to Search for Possible Trends (1:49)
PreviewModule 2-4 How to Research Universal Trends (3:37)
StartModule 2-5 Calculating Running Average of Player points (4:36)
StartModule 2-6 -Checking the Type of Player to Narrow our Research (4:49)
StartModule 2-7 - Create a Summary Sheet (8:13)
StartModule 2-8 Creating New Columns of Stats to Test (6:23)
StartModule 2-9 - Options to Increase Excel's Speed (2:58)
StartModule 2-10 - Researching Individual Player Trends (9:38)
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 videos are nicely done and very thorough. I'm not very good at computers but I was able to follow along with your instructions! Thank you!
Thank you very much for this course. I've learned more so much about spreadsheets that I now have my own projection system. It's helped me to win money in my last few days of NBA games!
I've created this course to help the average Daily Fantasy Player increase their odds of winning and also cut down on time in their research. I've heard from so many people who do a lot of manual work in preparing their lineups, I felt this knowledge can help save them some time in life!
Crunching the numbers and analyzing past data is an excellent way towards winning at Fanduel or Draftkings. Many people know some of the basics of spreadsheets, but if you are truly serious about winning at DFS and want to save time in the process, it may be worth spending a little bit of time and money now to learn spreadsheets better and how to apply that towards daily fantasy.
Have a look at the inside of the course!! See this video, I show you what you will see when you enroll:
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!
This course will show you how to best use your time to build competitive lineups. It will take you from creating your research spreadsheet, to showing how to populate it, how to make projections based on research from past gamelogs and how to build lineups fast. It will also show you how to research past contests and other advanced techniques to get that edge you need.
If you are still on the fence, I just wanted to let you know you won't be doing this alone. This course comes with a Facebook group where you can ask questions to other people just like you who are trying to better their spreadsheet skills. I also jump into that group daily to reply to comments.
If you have any last minute reservations about joining, just send me an email ([email protected])!
***Last updated June 2020