This tutorial is excellent if you want to learn how to create your Fitness Programme using Excel. In the following video, you will use functions and built-in features to make your life easier. The video demonstrates Named Ranges, Data Validation, Indirect Functions.
To find out more, please watch the video below.
Following the Part 1 of John’s tutorial on Creation of Fitness Programme, where we learnt about Named Ranges, Data Validation and Indirect Function – Part 2 demonstrates the Advanced Data Validation.
This is the fundamental skills video in which John Lythe demonstrates basic text functions, such as: LEFT, RIGHT, MID, &, LEN, TRIM, CLEAN, UPPER, LOWER, PROPER.
This is the part three of this exercise. In this video we have a new data set to look at as compared to the first two videos. This is more generic fitness testing data set that contains all sorts of things from body weight and body composition through speed, strength and power measures.
In this video I will show you how to extract only the most recent records for a selected athlete using either the LARGE or the AGGREGATE function to provide the row numbers and INDEX to extract the data.
Stay informed about the latest development, announcements, and promotions in strength and conditioning training, sports science, performance management, and related disciplines.
After you sign up, we will send you Home Workout Builder to your email address.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
Please note that your subscription and membership will be canceled within 24h once we receive your request.
Responses