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 140 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:
- Twelve (12) hours of videos broken out into 140 bite sized video chunks of 5 to 10 minutes each
- 100 Page Ebook breaking out what you saw in the videos in the first 4 modules
- Top Priority Email Support from myself on questions you may get while going through this course.
- 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
- 6 Years of Gamelogs for NFL, NHL and NBA (2016-2021)
- All the video files and spreadsheet files for you to save to your computer so you can watch them whenever you want.
Bonus : 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.
Course Description
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.
Module 10 – How to use Visual Basic for DFS Excel
In this module I show you how to code visual basic in macros to make your spreadsheet be able to do way more functionality than you thought possible.
Module 11 – Analyze large Gamelog Datasets
In this Module I go over how to take a large dataset of gamelogs and use Excel functionality to analyze it and create reports from it. I show how to turn the player gamelogs into team gamelogs and more.
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!
Testimonial:
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.
-mera
Course Curriculum
Introduction and Downloads
Introduction and Downloads (0:45)
Module 1 – Pulling in DFS Web Data
Module 1-1 – Pulling Web Data into your Spreadsheet (3:57)
Module 1-2 Pulling Salary Information (2:46)
PreviewModule 1-3 Combining Data into one Table (5:01)
Module 1-4 Using a Names tab to Eliminate Spelling Issues (5:39)
Module 1-5 Getting rid of error messages (1:54)
Module 1-6 – How to Manipulate/Change the Pulled data (5:56)
Module 1-7 Using Google Sheets to Pull Web Data (4:15)
Module 1-8 Using Power Query Editor when Pulling Web Data (5:56)
Module 2 – Finding & Backtesting Trends from Historical Data
Module 2-1 – Introduction to Finding Trends (1:29)
Module 2-2 – Sorting the Data Before Finding Trends (1:38)
Module 2-3 – Reviewing your data to Search for Possible Trends (1:49)
PreviewModule 2-4 How to Research Universal Trends (3:37)
Module 2-5 Calculating Running Average of Player points (4:36)
Module 2-6 -Checking the Type of Player to Narrow our Research (4:49)
Module 2-7 – Create a Summary Sheet (8:13)
Module 2-8 Creating New Columns of Stats to Test (6:23)
Module 2-9 – Options to Increase Excel’s Speed (2:58)
Module 2-10 – Researching Individual Player Trends (9:38)
Module 2-11: Adding Running Average without Sorting First (2:45)
Module 3 – Making your own Projections
Module 3-1 Make your own projections (8:27)
Module 3-2 – How to Look at Defensive Rankings (5:06)
Module 3-3 How to Analyze Vegas Odds for Spreadsheet Projections (4:38)
Module 3-4 – Setting up a Nested IF to Condense your Projections (4:46)
Module 3-5 – Set up a Table for Projection Adjustments (4:38)
Module 3-6 How to make NBA Projections with Fantasy Pts per minute (6:39)
Module 4 – Using Solver for Optimal Lineups
Module 4-1 Overview on Using Solver for Optimal Lineups (15:03)
Module 4-2 – Adding the Solver Add in (0:53)
Module 4-3 Displaying Solver Results Easier (9:46)
Module 4-4 – How to Stack a Team in Solver (3:45)
Module 4-5 Apply Site Limits to Solver Constraints (5:38)
Module 4-6 – Using the Flex Spot in Solver (4:47)
Module 4-7 Getting Solver to Choose Multiple Positions (5:04)
Module 4-8 – How to Include or Exclude Players (4:39)
Module 4-9 – How to Choose your own Flex spot (2:18)
Module 4-10 – How to Run Multiple Lineups with Solver (7:10)
Module 5 – Using Advanced Excel Features for Greater Stat Analysis
Module 5-1 Pivot Tables for Determining Best Home Run Ballparks (9:01)
PreviewModule 5-2 – Determining the type of players by Standard Deviation (8:43)
Module 5-3 Conditionally Formatting cell based on Stat Values (2:45)
Module 5-4 – Removing Duplicates (2:23)
Module 5-5 How to Use Macros to Automate Tasks (5:54)
Module 5-6 How to pull out parts of a cell into a new cell with Formulas (8:38)
Module 5-07 How to pull in Twitter Feeds into your Spreadsheet for last minute Injuries (7:41)
Module 5-08 How to use Numberfire’s projections (2:58)
Module 5-10 How to use IFERROR to get rid of errors on your spreadsheet (2:01)
Module 5-11 How to combine multiple cells into one cell (2:20)
Module 5-12 How to Determine if a player is Home or Away in your spreadsheet (3:57)
Module 5-13 How to Rank Def vs Position or any range of numbers (3:25)
Module 5-14 How to pull in Injury news and Adjust Projections based on it (7:02)
Module 5-15 How to pull in NBA Season Stats into Google Sheets (3:07)
Module 5-16 How to calculate how many times salary a player scores (2:52)
Module 5-17: Use XLOOKUP for DFS (6:16)
Module 5-18: Pull over List of Teams from Salary Export using Formulas (6:44)
Module 5-19: Conditionally Format DFS data to stand out (4:50)
Module 5-20: Build Interactive Dashboard in Excel for DFS Stats (22:31)
Module 6 – How to analyze a completed Draftkings Contest
Module 6-01 How to pull the Data you need to Analyze contest results (3:34)
Module 6-02 How to format the contest data before Analyzing (7:03)
Module 6-03 How to analyze team stacks and team usage in contests (12:05)
Module 6-04 How to Track the strategies of the Top Users (6:04)
Module 6-05 How to Analyze winnings and losses from Tournaments (15:32)
Module 7 – How to create Bulk Lineups withOUT Solver
Introduction – Running Bulk Lineups without Solver (2:20)
Module 7-1 Copying in the Fanduel Salary export (1:11)
PreviewModule 7-2 Add in Player info (1:50)
Module 7-3 Calculate Projected points per Dollar (2:22)
Module 7-4 Rank each position based on Pts/$ (4:09)
Module 7-5 Create a Player Pool of the top players (7:37)
Module 7-6 Randomly Choose Players (3:45)
Module 7-7 Add in Salary columns for each player (1:52)
Module 7-8 Add in Projected points for each position (1:49)
Module 7-9 Add in formula to check for Duplicate Lineups (3:49)
Module 7-10 Add in length of player names to a new column (2:34)
Module 7-11 Display only Valid Lineups (3:57)
Module 7-12 Copy down all the Lineups (2:24)
Module 7-13 Copy and Paste Special the Final Lineups (1:05)
Module 7-14 Sort the lineups (1:11)
Module 7-15 Remove Duplicate Lineups (1:17)
Module 7-16 Delete rows for lineups you don’t want to keep (0:43)
Module 7-17 Delete all rows on Lineups tab except for top row (2:11)
Module 7-18 Make a csv lineup Tab (2:46)
Module 7-19 Find actual Player’s used percentage (2:14)
Module 7-20 Editing the Macro and running it (3:20)
Extras: 7-21 to 7-27
Module 7-21: How to Exclude players from Lineups (0:59)
Module 7-22: Set Minimum Salary for your Lineups (3:20)
Module 7-23: What to do if you get Low Lineup Salaries (3:57)
Module 7-24: Team Player Limits (5:53)
Module 7-25: Stacking Teams (6:42)
Module 7-26: Dual Positions in Draftkings (6:14)
Module 7-27: Lock Players into Lineups (6:05)
Module 7-28 – How to account for flex spot (2:56)
Module 8 – Single Game Slate
Introduction (3:33)
Spreadsheet Downloads
How to use the Fanduel Spreadsheet Optimizer tool (6:18)
How to use the Draftkings Spreadsheet Lineup Optimizer (7:14)
Draftkings Showdown Basics (2:00)
Fanduel Showdown Basics (2:20)
NBA Research Report (10:19)
MLB Research Report (12:22)
PreviewNFL Research Report (7:56)
NHL Research Report (6:56)
How to Build a Single Game lineup Builder Spreadsheet (30:50)
How to Research Past Single Game Contests (38:46)
How to Research User Data in Past Contests (11:38)
Where to get Projections from to Use with this Tool (2:20)
How to use Rotogrinders Results DB to research Past Contests (9:10)
Module 9 – How to make DFS Model/Cheatsheet in Google Sheets (Baseball Example)
Introduction (2:19)
1 – Pull in Fanduel Salary Data (2:49)
2- Create the Cheatsheet tabs and link Fanduel Data (3:27)
3- Create naming convention tab (3:14)
4-Pull in Draftkings Salary data (3:51)
5 – Add in batter and pitcher’s hand (4:07)
6 – Pull in opposing pitcher to the batter’s cheatsheet (3:59)
7 – How to Pull in Fangraphs data (9:26)
8 – Manipulate Cheatsheet to create Custom Stats (5:28)
9 – How to Rank Columns of Data Easily (3:15)
10 – How to Conditionally Format Cell Data (2:48)
11 – How to pull in Team stats (4:36)
12 – How to pull in Weather data to the Cheatsheet (11:58)
13 = How to pull in Vegas lines to your Cheatsheet (6:10)
14 – Your finished Cheatsheet (1:05)
Module 10 – VBA for Daily Fantasy
Intro & File downloads (4:05)
Module 10-1: How to with VBA code (2:26)
Module 10-2: Using Macro Building to Write VBA Code (1:06)
Module 10-3: How to Edit & Run a Macro (3:54)
Module 10-4: Declaring Variables (3:39)
Module 10-5: Cell Reference (4:33)
Module 10-6: IF Statements (4:20)
Module 10-7: For Loops (4:46)
Module 10-8: Insert Comments into your Code (2:49)
Module 10-9: Code to Stop Screen Updating (2:12)
Module 10-10: How to Create a pop up Message Box (1:29)
Module 10-11: Call Another Macro in your code (3:15)
Module 10-12: Password Protect VBA Code (1:49)
Module 10-13: Shortcut keys and Buttons to trigger macros (2:17)
Module 10-14: Debugging Errors (2:39)
Module 10-15: Find Correct Code with Macro Builder (2:53)
Module 10-16: Example – Run Certain Code based on Value of Cell (5:20)
Module 10-17: Using Input Box to Get Data from User (3:33)
Module 10-18: Example – Refresh Web Data (4:19)
Module 10-19: Run Macro upon Opening Workbook (2:55)
Module 10-20 – Example – Copy Daily Game stats to Complete Game Log List (9:48)
Module 10-21 : Example – Save sheet as csv file (3:24)
Module 10-22: Example – Email a worksheet (4:08)
Module 10-23: Create User Defined Functions (13:33)
Frequently Asked Questions
More Testimonials
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!
“I’m a big fan of your work. You’re sharing valuable knowledge in a digestible way and covering a lot of the same topics that I would cover if I were to ever make a course!”
– Jack
“I recently used your NBA Player Simulator Tool and I won $2000 in a recent NBA contest. ———I have been participating in DFS tournaments for years and I have spent $1000s on optimizers in search of the big win. I am intrigued by your use of Excel in performing some of the same functions as some of the expensive and overpriced optimizers. I am comfortable using Excel and I have purchased some of your products. Using your tools gives me an understanding of how the stats can be used to predict performance and how to “fine tune” the spreadsheets to give me a competitive advantage.”
– Don
“I’m really a big fan of your work and have truly learned a lot from you ! I’ve been working hard trying to learn my own processes. Your stuff really helps l. Looking forward to the videos. “
– Dean
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:
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 (Excelbyjoe@gmail.com)!