Author archive for John Lythe

• Excel Tricks for S&C Coaches: Beginner to Advanced – Module 4: The Project

By on 30/01/2018

After this final part of the course, the Project, you will be successfully finishing all 4 modules and you can proudly call yourselves an Excel Experts! However, in order for this to happen, you just need to master this last and probably the most important lesson!

• Excel Tricks for S&C Coaches: Beginner to Advanced – Module 4

By on 17/01/2018

By now, you have learned pretty much everything you need to know about the Excel and those exercises are great way to check your knowledge and skills, as well as to see the progress you made from the first module.

• Excel Tricks for S&C Coaches: Beginner to Advanced – Module 3

By on 02/01/2018

In this module you will go through some basic and advanced charting principles, pivots, tables and VBA .

• Excel Tricks for S&C Coaches: Beginner to Advanced – Module 2

By on 19/12/2017

Today, we are presenting you a Module 2, in which John is demonstrating more advanced excel functions, or in other words, everything that you need to know about formulas and functions.

• Excel Tricks for S&C Coaches: Beginner to Advanced – Module 1

By on 11/12/2017

Check out ''Excel Tricks for S&C Coaches: Beginner to Advanced’’ course, which will help you perfect your excel skills and make your job much easier.

• Using Excel to Create a Basic Athlete Load Monitoring Tool – Part 2

By on 07/11/2017

Part 2 of John Lythe's series - a quick look into the creation of a basic tool to collect and monitor athlete training load using RPE and duration data.

• Using Excel to Create a Basic Athlete Load Monitoring Tool – Part 1

By on 04/11/2017

This example shows how to get started with athlete load monitoring. If you are collecting session duration and RPE from your athletes then you have enough information to get started.

• How to Use Excel to Automatically Create Reports – Part 5: Use a Scroll Bar

By on 28/11/2016

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

• How to Use Excel to Automatically Create Reports – Part 4: Most Recent Results

By on 15/11/2016

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.

• How to Use Excel to Automatically Create Reports – Part 3: Create a Dynamic Report Builder

By on 11/10/2016

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.