How to Build a Fantasy Basketball Spreadsheet

The Complete Guide to Advanced Research in Daily Fantasy Basketball
4.1 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
251 students enrolled
Take This Course
  • Lectures 23
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

You can stop going from site to site researching. Bring all the stats to you immediately. You'll learn how to import stats, projections, Vegas odds. daily schedule, defense vs. position matchups, and how to build a lineups page. This will save you SO much time and take your research to the next level!

What are the requirements?

  • Just a computer and internet connection.
  • No need to buy Excel or any other software!

What am I going to get from this course?

  • Import stats, rankings, and projections automatically from the web.
  • Use Conditional Formatting to easily spot the best players for that day.
  • Build a Lineups Page with up to the minute projections.
  • Be a Google Spreadsheet master!
  • Win consistently in fantasy sports
  • Know why someone is a great play vs. trusting an "expert's" picks.

Who is the target audience?

  • Daily fantasy sports players looking to take their skills to a professional level.
  • Fantasy players with limited time for research.
  • People looking to become advanced using Google Spreadsheets in the workplace.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction

The skills you learn will work for all sites and sports! This course will focus on DraftKings and the NBA. You'll be able to import your favorite stats, see great plays, and build multiple lineups! Customizing your daily fantasy sports spreadsheet is incredibly fun and addicting!

Section 2: Starting Your Spreadsheet

This will show you how to start your Google spreadsheet.


Make your spreadsheet easy to read.

Section 3: Creating Position Pages

You will learn how to sort data by position, and start pages for each position.

Section 4: Automatically Import Stats from the Web

The secret to your spreadsheet! The formula to import stats.

Section 5: Import Rankings and Projections

This will get you up to the minute projections for each player!

Section 6: Get Stats to the Position Pages

How can you pull stats from one sheet to another for each player?


Matching the projections to all players.

Section 7: Vegas Odds and Daily Schedule

This will get you the schedule of games for the day and the Vegas projected team totals.


How to split information in one cell to get the information you need.


Team names, cities, and abbreviations to get projected team totals and pull stats to other pages.


Copy and paste this into your Blueprint.


Abbreviations needed to get stats to different pages.

Team Projections to Position Pages

How to get the opponent's projected total points for each player.


Copying projected team totals to all position pages.

Section 8: Using Defense vs. Position

Importing Defense vs. Position stats to your spreadsheet.

DvP Column in Position Pages
Section 9: Conditional Formatting

Change the color of a cell based on the data in it.

Section 10: Build a Lineups Page

Be able to compare multiple lineups, side by side, with up to the minute projections.


How to use this page.

Section 11: Having a Template

Setting up your daily research in 2 minutes!

Section 12: Questions?

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Nick Marsh, Certified Google Educator, Fantasy Blueprint

I've been playing Fantasy sports for 15 years.  MLB is my absolute favorite and I count down the days to Spring Training. I've played Fantasy Baseball, Football, Basketball, Hockey, Golf, and Bass Fishing (really). I'm a Certified Google Educator and have been using Google Sheets for years. I will help you build an amazing fantasy spreadsheet!

Ready to start learning?
Take This Course