EAF #104: Use Excel to create a GPS Session Report

This video shows how you can use Excel to create a GPS session report with references to position and team averages, match data and session-specific targets. Tricks used include CHOOSE, AVERAGEIFS, INDEX, MATCH, VLOOKUP, Table References, Data Validation, Dynamic Charts. If you are interested in more Excel tutorials check out my three series on Vimeo for S&Cs and Sport Scientists https://vimeo.com/ondemand/athletemonitoring https://vimeo.com/ondemand/strengthtemplate https://vimeo.com/ondemand/excelforstrengthcoaches Discount codes below (note the different codes for US v rest of world) Intro to Excel for S&Cs Tricks or TricksUS = 50% Excel Tricks for Sports: Create an Athlete Monitoring System Track or TrackUSA = 50% Excel Tricks for Sports - Strength Training Manager ET4S or ET4SUSA = 50% If you are a performance analyst then consider this video series and other excellent resources from the videoanalyst http://thevideoanalyst.com/courses/excel-for-analysts/