There are more than a few ways you can use Excel to help you conquer Daily Fantasy Sports. You will see an overview of a feature you can use to compare Daily Fantasy Sports players to the players on the opposing team. The tool compares the players’ projections.
The tool consist of dropdown menus, Index and Match formulas and the use of nested IF statements to achieve the results that make this comparison tool useful. It will compare Daily Fantasy Sports players by position. For example, it would compare the Washington Wizards’ points with the Boston Celtics’ point guards. It will use the defense of each team to ensure you obtain the correct projections for each player.
Many people will ask why do people use Excel spreadsheets to create Daily Fantasy Sports lineups. I like using spreadsheets because it allows me to customize my data that will hopefully get the best players into a draft pool. Many of you probably have looked at the various YouTube videos to help build a basic Daily Fantasy Sports football optimizer. Whatever helps, you get the basics, but you really start unleashing the power of Excel in fantasy sports when you start to ask the correct questions.
The use of the Index and Match formula is great help when creating an Excel worksheet for you Daily Fantasy Sports data. The use of the Left function in Excel greatly improves the Match portion of the Index Match formula when names of sports teams differ in how they are represented on each site.
Watch the video to learn more. The
In the video below, you will learn how I use the Index and Match formula to create a worksheet filled with various sports data from various Excel spreadsheets. There are will be another video to follow to help you with the Match portion of the Index and Match formula.
You can subscribe to my YouTube Channel The Sporty Mouth to learn more. A subscribe button is located within the video.
The video below is a brief analysis of few players that you may want to add to your fantasy roster. It is also the first video for the NBA Regular Season for the Sporty Mouth Blog. I hope everyone has great day, and please subscribe to my YouTube Channel the Sporty Mouth. I will bring more videos to help with your daily fantasy sports success.