Description
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/