- Видео 140
- Просмотров 2 164 615
ExcelTricksforSports
Новая Зеландия
Добавлен 18 окт 2011
This channel is made by a sport scientist, sports analyst and strength and conditioning coach working with Olympic athletes. The videos will demonstrate techniques and systems used when preparing training programs, managing training and monitoring data and preparing reports. All videos have accompanying files that can be requested by email. You can use these demonstrations and files to help guide your practices, give you ideas or just develop some new excel skills.
Some of the files include Athlete Fitness Profiles and Dashboards, Training Program development, Fitness Test Reporting and i use Excel for PC, Excel for Mac and Excel Online. Occasionally i dabble in VBA too. Email me on exceltricks4sports@gmail.com if you want to make contact. I tweet occasionally on @athletefitness
If you like my work and would like to help me make more videos then consider buying me a coffee
www.buymeacoffee.com/CkiIh7tJ5
Some of the files include Athlete Fitness Profiles and Dashboards, Training Program development, Fitness Test Reporting and i use Excel for PC, Excel for Mac and Excel Online. Occasionally i dabble in VBA too. Email me on exceltricks4sports@gmail.com if you want to make contact. I tweet occasionally on @athletefitness
If you like my work and would like to help me make more videos then consider buying me a coffee
www.buymeacoffee.com/CkiIh7tJ5
EAF #78F - Basic VBA Debugging and Error Checking your Loop
Use break points, line-by-line step through of code, hover, and the immediate window to check your VBA. This is a video that is connected to videos 78 and 78B
Просмотров: 1 496
Видео
EAF #111 - Using Lookup Tables
Просмотров 3,8 тыс.4 года назад
Using lookup tables to add references to your data set is quick and easy. Convert to Tables and then apply INDEX&MATCH functions to extract what you need.
EAF #110 - GPS DATA & WORKING WITH MAX VELOCITY TO IDENTIFY HAMSTRING INJURY RISK
Просмотров 2,4 тыс.4 года назад
This video shows how you can use Excel to manipulate GPS data and extract maximum velocity and speed threshold information. Tricks used include MAXIFS, AGGREGATE, COUNTIFS. If you are interested in more Excel tutorials check out my three series on Vimeo for S&Cs and Sport Scientists vimeo.com/ondemand/athletemon... vimeo.com/ondemand/strengthte... vimeo.com/ondemand/excelforst... Discount codes...
EAF #109 - RANKING SCORES WITH NEW DYNAMIC ARRAYS
Просмотров 3,7 тыс.4 года назад
This video covers traditional and new methods of ranking scores including SORT, FILTER, PIVOT TABLES, MAX, LARGE. The new dynamic arrays formula in Excel are a game-changer. 00:45 MAX, LARGE, INDEX, MATCH 15:45 Pivot Tables 18:45 Dynamic Arrays formula FILTER, SORT
EAF #108 - Monitoring report with variable duration cycles
Просмотров 3,8 тыс.4 года назад
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...
EAF #107 - VBA Loop to Delete Blank Rows
Просмотров 1,5 тыс.4 года назад
If you would like to support me in making more videos then you can buy me a coffee www.buymeacoffee.com/CkiIh7tJ5 Simple VBA loop that checks each row and deletes any that are blank. Key trick is to start the loop from the bottom of the data set and work back to the top. See my channel for Excel Tips for Fitness Trainers, Sports Analysts and Sport Scientists Use functions and built in features ...
EAF #106 - Random Strength Session Generator
Просмотров 3,4 тыс.5 лет назад
Use INDEX and the RANDBETWEEN function to make a strength template that can instantly make a strength session plan.
EAF #78D - Use VBA to Extract Records to New Workbook
Просмотров 1,3 тыс.5 лет назад
Loop through rows and extract records that meet criteria. Results end as a sheet in a new workbook
EAF #105 - Data Validation tricks for an Athlete Performance Plan
Просмотров 1,8 тыс.5 лет назад
Creating an individual performance plan for an athlete is easy if you can build connected data validation lists and create a hierarchy of targets, goals and strategies.
EAF #78C - Excel VBA to search and extract records to new sheet
Просмотров 3,3 тыс.5 лет назад
A follow up to video #78. You have a data set with 1000 records and you want to return the records that match your criteria. Each time you run a search it creates a new sheet to paste the matching records into
EAF #78B - Excel VBA to search and extract records using multiple criteria
Просмотров 22 тыс.6 лет назад
A follow up to video #78. You have a data set with 1000 records and you want to return the records that match your criteria. This video shows how you can search for 3-4 names at the same time
EAF #104: Use Excel to create a GPS Session Report
Просмотров 14 тыс.6 лет назад
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 vimeo.com/onde...
EAF #103: Use formula or VBA to colour each column in a chart
Просмотров 1,5 тыс.6 лет назад
This video shows two methods of conditionally colouring each column in a chart. The first method uses an IF function to split the series into groups and the second uses VBA to individually colour each column using RGB codes. If you are interested in more Excel tutorials check out my three series on Vimeo for S&Cs and Sport Scientists vimeo.com/ondemand/athletemonitoring vimeo.com/ondemand/stren...
EAF #102 - Top10 Excel Tricks for Sport Science
Просмотров 22 тыс.6 лет назад
If you would like to support me in making more videos then you can buy me a coffee www.buymeacoffee.com/CkiIh7tJ5 Video Contents: Navigation 4:02 Data Entry 9:40 Dates and Times 27:50 Names 37:00 Data Validation 44:00 Tables 52:0 Pivot Tables 56:40 Formula 1:03:55 Charts 1:25:30 GoTo File 1:35:45 Email exceltricks4sports@gmail.com to get start and end files that you can play with yourself Thank...
EAF #101 - Are Excel Radar Charts Useful?
Просмотров 12 тыс.7 лет назад
This video talks about Excel Radar charts (also known to some as Spider charts). After a demo of how to make them the video walks through the 3 ways that you can scale your data to prepare for charting and some of the alternate options. For a copy of the file please email exceltricks4sports@gmail.com and mention video 101 This channel is all about excel for people who work in sport and use Exce...
EAF #100 - Searching and Extracting from a large fitness testing data set
Просмотров 2,7 тыс.7 лет назад
EAF #100 - Searching and Extracting from a large fitness testing data set
EAF #99 - Criteria-based analysis of a large fitness testing data set
Просмотров 2,1 тыс.7 лет назад
EAF #99 - Criteria-based analysis of a large fitness testing data set
EAF #98 - Athlete Performance Dashboard Project - Part3 - Extras
Просмотров 6 тыс.7 лет назад
EAF #98 - Athlete Performance Dashboard Project - Part3 - Extras
EAF #97 - Athlete Performance Dashboard Project - Part2
Просмотров 11 тыс.7 лет назад
EAF #97 - Athlete Performance Dashboard Project - Part2
EAF #96 - Athlete Performance Dashboard Project - Part1
Просмотров 22 тыс.7 лет назад
EAF #96 - Athlete Performance Dashboard Project - Part1
EAF# 94 - Performance Analysis Sportscode Project Finished File - Momentum
Просмотров 4 тыс.7 лет назад
EAF# 94 - Performance Analysis Sportscode Project Finished File - Momentum
EAF #93 - Using Excel to Code Sport - Part 5 - Assessing Form and Expected Performance
Просмотров 1,8 тыс.7 лет назад
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
Просмотров 1,9 тыс.7 лет назад
EAF #92 - Using Excel to Code Sport - Part 4 - Using Reference Data
EAF #91 - Using Excel to Code Sport - Part 3 - Match Database
Просмотров 3,4 тыс.7 лет назад
EAF #91 - Using Excel to Code Sport - Part 3 - Match Database
EAF #90 - Using Excel to Code Sport - Part 2 -Assign Position Specific Ratings
Просмотров 5 тыс.7 лет назад
EAF #90 - Using Excel to Code Sport - Part 2 -Assign Position Specific Ratings
EAF#75C - Making Sense of Training Load Calculations and Applying the Data
Просмотров 31 тыс.7 лет назад
EAF#75C - Making Sense of Training Load Calculations and Applying the Data
EAF #88 - How to Make an Excel Database (For Anything)
Просмотров 76 тыс.8 лет назад
EAF #88 - How to Make an Excel Database (For Anything)
EAF #87 - Use Excel to Automatically Create Reports - Part 5: Use a Scroll Bar
Просмотров 3,6 тыс.8 лет назад
EAF #87 - Use Excel to Automatically Create Reports - Part 5: Use a Scroll Bar