Learn How to Make an Excel Database

This is part one of the series where I’m going to look at the creation of basic sport reports from a data. In this first video I am going to use a body composition data set and perform a simple vlookup to extract the information for a given athlete.

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.