ExcelTricksforSports

20.6K subscribers

140 videos

This channel is made by a sport scientist, sports analyst and strength and conditioning coach working with Olympic athletes. The videos will demonstrate tech...

Latest Videos

EAF #78F - Basic VBA Debugging and Error Checking your Loop

EAF #111 - Using Lookup Tables

EAF #110 - GPS DATA & WORKING WITH MAX VELOCITY TO IDENTIFY HAMSTRING INJURY RISK

EAF #109 - RANKING SCORES WITH NEW DYNAMIC ARRAYS

EAF #108 - Monitoring report with variable duration cycles

EAF #107 - VBA Loop to Delete Blank Rows

EAF #106 - Random Strength Session Generator

EAF #78D - Use VBA to Extract Records to New Workbook

EAF #105 - Data Validation tricks for an Athlete Performance Plan

EAF #78C - Excel VBA to search and extract records to new sheet

EAF #78B - Excel VBA to search and extract records using multiple criteria

EAF #104 Use Excel to create a GPS Session Report

EAF #103 Use formula or VBA to colour each column in a chart

EAF #102 - Top10 Excel Tricks for Sport Science

EAF #101 - Are Excel Radar Charts Useful

EAF #100 - Searching and Extracting from a large fitness testing data set

EAF #99 - Criteria-based analysis of a large fitness testing data set

EAF #98 - Athlete Performance Dashboard Project - Part3 - Extras

EAF #97 - Athlete Performance Dashboard Project - Part2

EAF #96 - Athlete Performance Dashboard Project - Part1

EAF # 95 - Power BI Quick Demo

EAF# 94 - Performance Analysis Sportscode Project Finished File - Momentum

EAF #93 - Using Excel to Code Sport - Part 5 - Assessing Form and Expected Performance

EAF #92 - Using Excel to Code Sport - Part 4 - Using Reference Data

EAF #91 - Using Excel to Code Sport - Part 3 - Match Database

EAF #90 - Using Excel to Code Sport - Part 2 -Assign Position Specific Ratings

EAF #89 - Using Excel to Code Sport

EAF#75C - Making Sense of Training Load Calculations and Applying the Data

EAF #88 - How to Make an Excel Database (For Anything)

EAF #87 - Use Excel to Automatically Create Reports - Part 5 Use a Scroll Bar