Description
This video demonstrates how you can extract summary data from your database using formula. It allows you to choose cycle durations of 1-week, 2-weeks, 4-weeks, 8-weeks etc with the click of a drop down list.
Uses VLOOKUP, SUMIFS, AVERAGEIFS, DATA VALIDATION, TABLES, DYNAMIC CHARTS, CONDITIONAL FORMATTING.
For a copy of the file please email exceltricks4sports@gmail.com
This channel is all about excel for people who work in sport and use Excel.
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/athletemon...
https://vimeo.com/ondemand/strengthte...
https://vimeo.com/ondemand/excelforst...
Discount codes below (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/ex...