# Author archive for John Lythe

• ### Google Sheets for Sports Science Course – Module1: Basics

By on 23/10/2020

This is the first video in the series and presents a quick summary of key differences between Excel and Google Sheets as well as a run-through of the menus and layout. It finishes with demonstrations of formula writing, named ranges, data validation, and collaborative comments.

• ### Google Sheets for Sports Science Course

By on 23/10/2020

We are proud to present to you Google Sheets for Sports Science course. The intention of this course is to open your eyes to Google Sheets and gain skills to become a Google Spreadsheet power user!

• ### 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

• ### Excel Tricks for S&C Coaches: Beginner to Advanced

By on 07/12/2017

Excel Tricks for S&C Coaches: Beginner to Advanced course consist of 30+ videos that have been put together by John Lythe, who has over 15 years of experience as an S&C Coach with Olympic athletes and 20 years of experience using Excel in business and sport.

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