How to Analyze Sports with Excel - Part 1: Simple Macros, IF/ELSE statements and Loops
Excel Document: https://docs.google.com/spreadsheets/d/11oaW1SLveX7216FsVlQ5WHP53omkoVmgFbRHLO7TAhg/edit?usp=sharing
Macros(Paste into Visual Basic Editor): https://docs.google.com/document/d/1vGQJT0huoIr8xvRfyM3UJA9F5T9pE2N_XtYQDV3eudI/edit?usp=sharing
A lot of people do not know where to begin when it comes to deeper analysis of sports which is what you need to be able to do in order to have a chance to be successful at betting on sports. Microsoft Excel is a great program for beginners and advanced analysts alike to be able to crunch numbers and deeply analyze the stats.
This video series is about teaching people how to analyze sports with Excel from the ground up. This first video is a true 101 beginner level video teaching two important concepts of Excel - IF/ELSE statements and Loops. The IF statements can be done in Excel Functions or in Macros and we teach the concept of loops for Macros. You will need to learn how to do macros in order to really get the most out of your analysis.
While the sport I am using for this series is NBA the purpose of this video isn't so much as how to analyze basketball as it is teaching the concepts of how to use Excel at a more advanced level for analyzing sports.
Видео How to Analyze Sports with Excel - Part 1: Simple Macros, IF/ELSE statements and Loops канала Sports Betting Truth
Macros(Paste into Visual Basic Editor): https://docs.google.com/document/d/1vGQJT0huoIr8xvRfyM3UJA9F5T9pE2N_XtYQDV3eudI/edit?usp=sharing
A lot of people do not know where to begin when it comes to deeper analysis of sports which is what you need to be able to do in order to have a chance to be successful at betting on sports. Microsoft Excel is a great program for beginners and advanced analysts alike to be able to crunch numbers and deeply analyze the stats.
This video series is about teaching people how to analyze sports with Excel from the ground up. This first video is a true 101 beginner level video teaching two important concepts of Excel - IF/ELSE statements and Loops. The IF statements can be done in Excel Functions or in Macros and we teach the concept of loops for Macros. You will need to learn how to do macros in order to really get the most out of your analysis.
While the sport I am using for this series is NBA the purpose of this video isn't so much as how to analyze basketball as it is teaching the concepts of how to use Excel at a more advanced level for analyzing sports.
Видео How to Analyze Sports with Excel - Part 1: Simple Macros, IF/ELSE statements and Loops канала Sports Betting Truth
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Analyze Sports with Excel - Part 2: Data Structuring](https://i.ytimg.com/vi/RVzgHc9uNko/default.jpg)
![](https://i.ytimg.com/vi/4sdrd4eovps/default.jpg)
![How to Easily Make Your Own NHL Betting Odds Using Excel or Google Sheets.](https://i.ytimg.com/vi/lwzVPmyRObk/default.jpg)
![College Basketball Betting Model - Daily Routine on How I Use it to Make Bets](https://i.ytimg.com/vi/iLjQlgh6zmE/default.jpg)
![How to Build Power Ratings for Any Sport](https://i.ytimg.com/vi/Yp4ZX0WkPoU/default.jpg)
![Creating a Sports Betting Model 101: Basics of Testing & Backtesting](https://i.ytimg.com/vi/il-o1Muvaw4/default.jpg)
![Creating a Sports Betting Model 101 - Intro to Linear Regression (The simplest model ever created!)](https://i.ytimg.com/vi/t8ViRP2zZ3A/default.jpg)
![How I got banned from sports betting... - Arbitrage Betting Explained](https://i.ytimg.com/vi/TGinzvSDayU/default.jpg)
![Making a Modeler S1E1 - Making your first easy Monte Carlo Model](https://i.ytimg.com/vi/dRjrMbk8-u4/default.jpg)
![Creating NFL Power Ratings & Sports Betting Model in 2021 - Simple & Easy for Beginners](https://i.ytimg.com/vi/9u62DOHoZLE/default.jpg)
![How To Track All Your Bets, Win/Loss %, And ROI With A Bet Tracker Spreadsheet (FREE DOWNLOAD!)](https://i.ytimg.com/vi/oddNbP0TjMA/default.jpg)
![Intro to Power Ratings: Ep 1 - Creating an ELO Rating System](https://i.ytimg.com/vi/BzaS4Tb0fX4/default.jpg)
![Make A Killing Betting The NFL With This Teaser Strategy](https://i.ytimg.com/vi/zbTEXO9kqb0/default.jpg)
![Football Betting Model Basics - The Keys to a (Potentially) Successful Football Betting Approach](https://i.ytimg.com/vi/kfKb1v0cmG8/default.jpg)
![How to Analyze Sports With Excel - Part 3: Averages, Advanced Stats, and Home Advantage](https://i.ytimg.com/vi/J-2ZG6HMLnY/default.jpg)
![NFL Football Sports Betting Model Excel Template (Version 1)](https://i.ytimg.com/vi/NFjhnfAFQQw/default.jpg)
![Excel Interview Questions For Data Analyst](https://i.ytimg.com/vi/b9XKNjPEJsE/default.jpg)
![$10K TO $1,000,000. EPISODE 1 | Jonas Gjelstad - Professional Sports Bettor](https://i.ytimg.com/vi/5KC9Vxi52lg/default.jpg)
![How I got banned from sports betting (Using Maths) | Arbitrage Betting Explained](https://i.ytimg.com/vi/2kDTwP6SBx4/default.jpg)
![Monte Carlo 101 - A Primer to Using a Monte Carlo Simulation for Sports Betting Purposes](https://i.ytimg.com/vi/D9ngAdd2mkY/default.jpg)