How to Build a Fantasy Basketball Spreadsheet

The Complete Guide to Advanced Research in Daily Fantasy Basketball
4.1 (21 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.
239 students enrolled
$19
$55
65% off
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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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.

What 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.

Curriculum

Section 1: Introduction
01:05

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
02:04

This will show you how to start your Google spreadsheet.

01:57

Make your spreadsheet easy to read.

Section 3: Creating Position Pages
03:56

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

Section 4: Automatically Import Stats from the Web
01:08

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

Section 5: Import Rankings and Projections
01:46

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

Section 6: Get Stats to the Position Pages
03:35

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

01:03

Matching the projections to all players.

Section 7: Vegas Odds and Daily Schedule
01:32

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

01:16

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

02:06

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

Article

Copy and paste this into your Blueprint.

02:18

Abbreviations needed to get stats to different pages.

Team Projections to Position Pages
03:01
02:32

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

00:50

Copying projected team totals to all position pages.

Section 8: Using Defense vs. Position
01:14

Importing Defense vs. Position stats to your spreadsheet.

DvP Column in Position Pages
02:06
Section 9: Conditional Formatting
02:34

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

Section 10: Build a Lineups Page
06:08

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

01:28

How to use this page.

Section 11: Having a Template
00:43

Setting up your daily research in 2 minutes!

Section 12: Questions?
Twitter
Preview
00:11

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