Spreadsheet School for Daily Fantasy Sports

Learn how to use Excel spreadsheets to analyze Daily Fantasy stats

Sports are a game of skill but also of calculated odds. When you have two elite players or teams facing each other, many times it comes down to something other than skill to determine the outcome.

Daily Fantasy Sports is about trying to find those players who have a good chance to do well. Sometimes just knowing a baseball player always does good after a days rest or a basketball player is horrible in their 3rd straight road game is enough to win a tournament.

Your job in daily fantasy sports is to find these players with competitive advantages.

One way to do this is through analyzing statistics.

This is something the best DFS players do daily. It can be real time consuming though.

One tool that many people use are spreadsheets. They are a great analytical tool which allows you to find trends and perform statistical analysis. This analysis can help you find great plays for the day.

However, it's not easy to know how to do this.

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 40 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. While 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.

So if you are interested in saving time and creating better lineups through spreadsheet research, read below what the course offers...




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.

Class Curriculum


  Introduction and Downloads
Available in days
days after you enroll

Frequently Asked Questions


How will your course help me with daily fantasy sports?
This course will teach you ways to pull in data, perform research over spreadsheets, create projections and create lineups easier. This will end up saving you time in your research instead of doing it on paper. It will also help you to locate the good matchups and spot trends easier, which will let you pick winning players more often.
Do I need to be an expert in Excel to use this?
No you do not. I go over things slowly and break them down over video and Ebook so you can follow along, no matter your experience level.
Can I ask questions if something is confusing?
Yes, of course you can! I will do my best to answer all questions about the course material as fast as I can. I also have a member only forum to post and view Q&A.
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
You get Lifetime access. After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
Will I get example spreadsheets to follow along with what you are showing us?
Yes you will! I give you spreadsheets to follow along and spreadsheets with the completed work on them.
Will there be any quizzes to help us learn more?
Yes there will be! I have practice examples for you to work on at the end of each of the first 4 modules.
I already know Excel pretty well. Is this course for me?
Yes, even more advanced users can benefit from this course. While you may know advanced techniques, I apply this knowledge to daily fantasy sports and how to best use it for it.

This course was amazing! It helped me learn so much! I just cut my research time in half!

Very cool, good job and thanks!

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:


Your Instructor


Joe Z
Joe Z

I have used Excel spreadsheets for 15 years to analyze data and have incorporated that into the world of Daily Fantasy sports for the last 4 years. I have created spreadsheet tools for the last 1.5 years that over 2500 people have used to create lineups for their tournaments. I also have a Youtube channel, "Excelbyjoe" where I post some helpful videos on using spreadsheets for Daily Fantasy sports. It has over 100,000 views.


Get started now!