EAF #99 - Criteria-based analysis of a large fitness testing data set
2,293 views · Published 2 August 2017 · 29:24 · Indexed 29 September 2026
Channel: ExcelTricksforSports · 2017 · Science & Technology
Part 1 of 2: This video demonstrates how you can calculate criteria based averages, maximums and minimums of a large fitness testing data set. Uses COIUNTIFS, AVERAGEIFS, MAXIFS, AGGREGATE, TODAY, NOW For a copy of the file please email [email protected] This channel is all about excel for people who work in sport and use Excel for 2016 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 (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/
More from this channel
-
9:47
EAF # 10D - Build an Athlete Training Diary - Part 4
-
6:36
EAF#25 - Using Evernote to be Awesome at Excel
-
6:17
EAF#31 - Creating and Using the Personal Macro Workbook in Excel 2010
-
8:50
EAF #40 - Updated Body Composition Manager
-
15:07
EAF #41 - Using Excel Like SportsCode
-
17:50
EAF 45 - Manage Athlete Notes using Excel VBA Userforms
-
6:55
EAF #63 - Excel for Mac 2011 - Simple Personal Trainer Session Monitoring Sheet
-
12:47
EAF #65 - Sports Injury Surveillance System - A Practical Application of VLOOKUP