-
07/10/2017
Top 10 Excel Tricks for Sport Science
By John Lythe on 07/10/2017If you work in the sports as a physiologist, performance analyst or something else, you will see some tips and tricks that could be useful for you to know.
0 -
28/11/2016
How to Use Excel to Automatically Create Reports – Part 5: Use a Scroll Bar
By John Lythe on 28/11/2016This is part five and we have got one more idea that I want to show you and that is a scrollbar. To find out more, please watch the video.
-
15/11/2016
How to Use Excel to Automatically Create Reports – Part 4: Most Recent Results
By John Lythe on 15/11/2016In 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.
-
11/10/2016
How to Use Excel to Automatically Create Reports – Part 3: Create a Dynamic Report Builder
By John Lythe on 11/10/2016This 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.
-
04/10/2016
How to Use Excel to Automatically Create Reports – Part 2: Extract Multiple Records
By John Lythe on 04/10/2016This is the part two of this exercise. What we are going to do this time is to add a second set of data to our table and then look to extract both sets to our report. Unfortunately vlookup is no longer going to work for us because it will only find and extract the first record in a...
-
22/09/2016
How to Use Excel to Automatically Create Reports – Part 1: vLookup
By John Lythe on 22/09/2016This 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.
-
12/09/2016
Learn How to Make an Excel Database
By John Lythe on 12/09/2016Today I am going to show you how to create a database in Excel. To illustrate a point we are going to look at four different examples. Because my YouTube channel is all about creating Excel systems for people who work in sport, they all are going to be sport examples.
-
27/11/2013
Introductory Dashboard, Dynamic Chart, CheckBox, Spin Button
By John Lythe on 27/11/2013In this educative and useful video, John Lythe is showing you how to make a dynamic chart using Form Controls (Spin Button and Checkbox).
-
21/11/2013
YoYo Test Comparison Part 2 – Conditional Formatting Using Formula
By John Lythe on 21/11/2013YoYo Test Comparison Part 2 - Excellent instructional video by John Lythe - IFERROR and Conditional Formatting using a Formula.
-
26/10/2012
Excel Text Functions with John Lythe
By John Lythe on 26/10/2012This is the fundamental skills video in which John Lythe demonstrates basic text functions, such as: LEFT, RIGHT, MID, &, LEN, TRIM, CLEAN, UPPER, LOWER, PROPER.
