Learn How to Make an Excel Database

In this video tutorial, John is demostrating how to create Fitness Programe with Excel. This tutorial is very useful if you want to learn how to create your own Fitness Programm using Excel.

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.

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