Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add How to Build a Fantasy Basketball Spreadsheet to your Wishlist.

Add to Wishlist

How to Build a Fantasy Basketball Spreadsheet

The Complete Guide to Advanced Research in Daily Fantasy Basketball
4.0 (27 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.
252 students enrolled
Created by Nick Marsh
Last updated 2/2016
English
$10 $55 82% off
5 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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!

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.
Students Who Viewed This Course Also Viewed
What Will I Learn?
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.
View Curriculum
Requirements
  • Just a computer and internet connection.
  • No need to buy Excel or any other software!
Curriculum For This Course
Expand All 23 Lectures Collapse All 23 Lectures 44:45
+
Introduction
1 Lecture 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!

Preview 01:05
+
Starting Your Spreadsheet
2 Lectures 04:01

This will show you how to start your Google spreadsheet.

Preview 02:04

Make your spreadsheet easy to read.

Preview 01:57
+
Creating Position Pages
1 Lecture 03:56

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

Preview 03:56
+
Automatically Import Stats from the Web
1 Lecture 01:08

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

Intro to ImportHTML
01:08
+
Import Rankings and Projections
1 Lecture 01:46

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

Import Point Projections
01:46
+
Get Stats to the Position Pages
2 Lectures 04:38

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

Index and Match Equation
03:35

Matching the projections to all players.

Projected Points to all Positions
01:03
+
Vegas Odds and Daily Schedule
8 Lectures 13:46

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

Projected Team Totals
01:32

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

Preview 01:16

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

Team Grid
02:06

Copy and paste this into your Blueprint.

Team Grid
00:11

Abbreviations needed to get stats to different pages.

Opponent and DraftKings Abbreviation
02:18

Team Projections to Position Pages
03:01

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

Opponent Projected Totals
02:32

Copying projected team totals to all position pages.

Team Projections for all Positions
00:50
+
Using Defense vs. Position
2 Lectures 03:20

Importing Defense vs. Position stats to your spreadsheet.

DvP Page
01:14

DvP Column in Position Pages
02:06
+
Conditional Formatting
1 Lecture 02:34

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

Conditional Formatting
02:34
+
Build a Lineups Page
2 Lectures 07:36

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

How to Build a Lineups Page
06:08

How to use this page.

Building Lineups
01:28
2 More Sections
About the Instructor
4.1 Average rating
46 Reviews
279 Students
3 Courses
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!

Report Abuse