Excel-tricks-for-sports

excel-tricks-for-sports




EAF #102 - Top10 Excel Tricks for Sport Science

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 ...
Read more




EAF#1 - Create Fitness Programme with Excel

Excel Tips for Fitness Trainers and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Todays video demonstrates Named ...
Read more




Building a Sports Science Database on Excel - (Part 1 of 4) Moving Data

Part of the Building a Sports Science Monitoring System on Excel series for ThatSportScienceBlog.com. The video tutorial takes you through using and moving ...
Read more




5 Mental Skills For Sports & Performance

http://mentaltoughnesstrainer.com Building confidence, developing extreme focus, getting that "never-give-up" attitude, becoming aggressive when you need ...
Read more




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.
Read more




EAF#75B Basic Athlete Load Monitoring - Part 2

Vimeo Course (Excel for S&Cs): https://vimeo.com/ondemand/excelforstrengthcoaches Vimeo Course (Strength Template): ...
Read more




EAF #97 - Athlete Performance Dashboard Project - Part2

This video demonstrates some of the tricks you might use to pull different athlete data streams into a single performance dashboard. Data sets for Match ...
Read more




EAF #47 - Create a Multi-Week Strength Program Template

Use these ideas to create a template that allows you to build multi-week strength programs with just the click of a few drop down boxes INDEX, INDIRECT, ...
Read more




Excel Tricks for Sports - Introduction Video

Not just another youtube channel for Excel! This channel deals only with fitness and sports examples such as strength program writing, fitness testing data, GPS ...
Read more




EAF#75C - Making Sense of Training Load Calculations and Applying the Data

Part 3 of a video series looking at the collection of basic training load data, how to calculate rolling loads, acute and chronic loads, monotony and strain etc.
Read more




EAF #89 - Using Excel to Code Sport

Excel for Performance Analysts Training Course http://thevideoanalyst.com/courses/excel-for-analysts/ This is Part 1 of a series of videos for Performance ...
Read more




EAF #93 - Using Excel to Code Sport - Part 5 - Assessing Form and Expected Performance

Excel for Performance Analysts Training Course - Click below http://thevideoanalyst.com/courses/excel-for-analysts/ This is a 10 hour series of tutorial videos ...
Read more




EAF #96 - Athlete Performance Dashboard Project - Part1

This video demonstrates some of the tricks you might use to pull different athlete data streams into a single performance dashboard. Data sets for Match ...
Read more




EAF# 27 - Athlete Wellness Dashboard

Description Excel Tips for Fitness Trainers and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Dashboard creation ...
Read more




Top 10 Useful Excel Functions for a Sports Scientist

My most used and useful Top 10 functions on Excel as a Sport Scientist. Would be helpful to any Sport Scientist just starting to use Excel. Includes: Sum ...
Read more




EAF #15 - Excel 2010 Pivot Table and Slicer Quick Tutorial

Description Excel Tips for Sports Analysts and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Use Pivot Tables to do ...
Read more




EAF #88 - How to Make an Excel Database (For Anything)

Four examples of how you can use excel 2016 to make a database. The key is structure (rows, columns, descriptors and data). Time links and content are ...
Read more




EAF #98 - Athlete Performance Dashboard Project - Part3 - Extras

This video demonstrates a few extra things that you might consider for your dashboard. The first 2 videos of the project looked at how you can pull multiple data ...
Read more




EAF#26 - The Excel IF Function (Easy, Medium and Hard Examples)

Description Excel Tips for Sports Analysts and Sport Scientists Use functions and built in features of excel 2010 to make your life easier This video looks at 3 ...
Read more




EAF #100 - Searching and Extracting from a large fitness testing data set

Part 2 of 2: This video demonstrates how you can extract criteria based records from a large fitness testing data set e.g. the 3 best scores, the 3 most recent.
Read more




EAF #64 - The basics of VLOOKUP

One of the must-know formula that will help you build awesome excel tools to manage your sports data VLOOKUP INDEX MATCH DATA VALIDATION.
Read more




EAF# 42 - Advanced Data Validation Trick - VLookup & Indirect

Description Excel Tips for Fitness Trainers and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Set Up Data Validation ...
Read more




Annual Planner for Sports with Monitoring

Annual Planner for Sports with Monitoring - http://tinyurl.com/h5dxc44 In this video you can find the very simplistic monitoring system implemented in Annual ...
Read more




EAF# 29 - Excel 2010 Option Buttons for Surveys

Excel Tips for Fitness Trainers and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Option buttons (Form Controls)
Read more




EAF# 28 - Dashboard Conditional Formatting with Excel Formula

Description Excel Tips for Fitness Trainers and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Using complex formula ...
Read more




EAF #101 - Are Excel Radar Charts Useful?

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 ...
Read more




EAF #37 - Excel VBA Loop to Find Records Matching Search Criteria

Use VBA to write a short procedure that searches a database to find all records that match a search criteria Excel 2010 tricks for sport scientists.
Read more




EAF# 61 - Part B - Building a Strength Load Monitoring Tool

Part 2 of 4 videos Create a database-type system to collect and extract predicted or actual 1RM for key lifts in your athlete training programs Topics are: dataset ...
Read more




EAF #65 - Sports Injury Surveillance System - A Practical Application of VLOOKUP

An Excel-based Sports Injury Tracking system using the Orchard Codes Another Excel Tool created for Sport Scientists and S&C's.
Read more




EAF# 58 - Listbox Selector

Make the selection of an athlete or test variable a breeze with a form control list box. Excel Tricks for Sports is a channel designed to help Sport Scientists, S&C's ...
Read more




EAF#50 - Excel Dynamic Chart. Shrink and Grow Dataset with Drop Down Lists

Use drop down lists to control the size of the dataset that gets charted INDEX, OFFSET, DYNAMIC RANGES, DYNAMIC CHARTS, MATCH, CHECKBOX Excel ...
Read more




EAF # 17 - Mac2011 - Index, Match, VLookup and HLookup

Description Excel Tips for Sports Analysts and Sport Scientists Use functions and built in features of Excel to make your life easier Pull records from a table using ...
Read more




EAF# 61 - Part A - Building a Strength Load MonitoringTool

Part 1 of 4 videos Create a database-type system to collect and extract predicted or actual 1RM for key lifts in your athlete training programs Topics are: dataset ...
Read more




EAF #83 - Use Excel to Automatically Create Reports - Part 1: Lookups

Vimeo Course Links https://vimeo.com/ondemand/athletemonitoring [Discount code: Track or TrackUSA] https://vimeo.com/ondemand/strengthtemplate ...
Read more




EAF #48 - Strength Template with Training Load Calculations

Some tricks to allow you to calculate training loads when designing strength training sessions INDIRECT, VLOOKUP, NAMED RANGES, &, DATA VALIDATION ...
Read more




EAF #18 - Mac2011 - Data Validation Basics in Excel

Excel Tips for Sports Analysts and Sport Scientists Use functions and built in features of excel to make your life easier This video is made using Excel 2011 for ...
Read more




Building a Sports Science Monitoring System on Excel - (Part 2 of 4) Using a Excel Table

Part of the Building a Sports Science Monitoring System on Excel series for ThatSportScienceBlog.com. The video tutorial takes you through using and Excel ...
Read more




EAF# 61 - Part C - Building a Strength Load Monitoring Tool

Part 3 of 4 videos Create a database-type system to collect and extract predicted or actual 1RM for key lifts in your athlete training programs Topics are: dataset ...
Read more




EAF #41 - Using Excel Like SportsCode

Excel Tricks for Sport Scientists and Performance Analysts.
Read more




EAF# 61 - Part D - Building a Strength Load Monitoring Tool

Part 4 of 4 videos Create a database-type system to collect and extract predicted or actual 1RM for key lifts in your athlete training programs Topics are: dataset ...
Read more




EAF 45 - Manage Athlete Notes using Excel VBA Userforms

Use this quick and easy Excel trick to make a CRM database of all your athlete notes. EXCEL, VBA, USERFORM See my channel for Excel Tips for Fitness ...
Read more




SPRINZ 2014 Workshop - Excel Tricks - Fitness Test Data Management Project Demo

Published on Nov 14, 2014 14th November 2014 AUT SPRINZ Conference & Workshop Excel Tricks Session - Project #2 A more detailed run-through of the ...
Read more




EAF#8 - Conditional Formatted Excel Column Chart Using IF Function

Excel Tips for Fitness Trainers and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Make the bars of a column chart ...
Read more




EAF #92 - Using Excel to Code Sport - Part 4 - Using Reference Data

Excel for Performance Analysts Training Course - Click below http://thevideoanalyst.com/courses/excel-for-analysts/ This is a 10 hour series of tutorial videos ...
Read more




EAF #40 - Updated Body Composition Manager

www.athletefitness.co.nz to get this file for $1 See how you can build functional tools with excel Data Validation, Dynamic Charts, VBA Excel Tricks for Sports.
Read more