How to Build a Fantasy Football Spreadsheet
4.6 (5 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.
19 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

How to Build a Fantasy Football Spreadsheet

Learn How to Import Stats and Play Like a Champion
4.6 (5 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.
19 students enrolled
Created by Nick Marsh
Last updated 11/2016
English
Current price: $12 Original price: $145 Discount: 92% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 37 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Automatically imports stats into your spreadsheet.
  • Easily see good plays by color coding stats.
  • Predict who will have a big game and win!
  • Build multiple lineups and compare side-by-side.
View Curriculum
Requirements
  • Work a computer mouse and keyboard at a beginner level.
Description

Ever wonder why a fantasy 'expert' likes a certain player?  What makes that guy such a great play?  Here you can finally learn how to make your own Fantasy Football spreadsheet.  This will walk you through how to import stats that update automatically for you.  Stop paying 'experts' for yearly subscriptions.  Using Google Spreadsheets (FREE!) you will build your spreadsheet to import projected points for each player, how the defense they are facing ranks, targets, rushing attempts, and any other stats you choose.  It is fully customizable and will show you the equations needed to import stats of your choosing!  Then it will go over how to color code those stats so you can easily see great plays, fast!  You can't afford to play Fantasy Football without it!

Who is the target audience?
  • All Fantasy Football players.
Compare to Other Fantasy Football Courses
Curriculum For This Course
+
Preview of the Sheet
3 Lectures 04:03
+
Starting the Spreadsheet
4 Lectures 06:21

How to export players from DraftKings and bring them into your spreadsheet.

Preview 02:24

How to create separate pages for each position.

Preview 02:29

Setting up your Flex position page and sorting data to make life easier.

Preview 00:51
+
Importing Stats
13 Lectures 26:32

This is what you came here for!  This is an introduction to the equation needed to make your spreadsheet work.

How to Import Stats Automatically.
00:38

How to get Player IDs to easily pull stat for each of them.

Getting Player IDs
01:28

Pull the Player ID to the 'Paste' screen.

Bringing the IDs to Exported Players
01:23

What equations to use that will pull the IDs to the QB page.

Player IDs to the Quarterback Page
01:41

How to quickly get each player's ID and team on all of your position pages.

Player ID and Team to Each Position
00:50

Importing Projected Points
03:52

Projected Points to All Positions
01:39

Projected Points Continued
02:35

Vegas Odds Page
02:55


Vegas Odds to Position Pages
04:31

Build a Lineups Page!
04:25

About the Instructor
Nick Marsh
4.2 Average rating
25 Reviews
80 Students
2 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!