Excel Tricks for S&C Coaches: Beginner to Advanced – Module 4 - Complementary Training
Excel Tricks for S&C Coaches: Beginner to Advanced – Module 4

Excel Tricks for S&C Coaches: Beginner to Advanced

MODULE 4: Exercise 1 – Intro

Today, we are presenting you a Module 4 of John’s course “Excel Tricks for S&C Coaches: Beginner to Advanced“. In this Module, you will be presented with 10 Practice Exercises, so that you can practice the skills you have learned so far, in all three previous modules.By now, you have learned pretty much everything you need to know about the Excel and those exercises are great way to check your excel skills, as well as to see the progress you made from the first module.The lessons that will be covered in Excel tricks for coaches, Module 4 are the following:

  • Intro (8m 34s)
  • Advanced Analysis and Charting (11m 31s)
  • Edit Pivot Tables and Create Pivot Tables (09m 17s)
  • Simple and Intermediate Analysis, Data Validation, Radar Profile Charts (09m 44s)
  • Data Extraction Formula, Advanced Analysis Formula, Pivot Tables (18m 21s)
  • Dynamic Charting and Table Referencing (09m 09s)
  • Intermediate Charting (09m 53s)
  • Convert and Chart Strength Training Data (11m 18s)
  • Data Validation, Named Ranges, Lookup Formula (09m 53s)
  • Random Data Creation, Intermediate Analysis (10m 18s)

After we complete the Module 4 – Practice Exercises x 10, the last part we are left with is the Project, in which all modules and lessons will be incorporated.

All of you that still haven’t had a chance to take a look at this excel tricks for coaches, an amazing course, should not miss this opportunity and gain advanced excel skills after successful completion of all modules&exercises.


Ready to watch this course?
Become a member and get unlimited access to all content on our website.

Start Your Membership Today

Join Us Today And Claim 2 Bonuses

Standard Membership
$35 per month


Go Annual and Get All Bonuses for FREE!

Join Us TodayAnd Instantly Save $2140

Premium Membership
$350 per year

Course Navigation


Module 1 Lessons

Module 2 Lessons

Module 3 Lessons

Module 4 Exercises

I am a former sport scientist, now I just build Excel systems and work with software tools (CRM, Salesforce, PM, Sharepoint) and technology. My day job requires me to sit between the IT department and the sports performance department to make sure that Strength and Conditioning Coaches, Nutritionists, Performance Analysts etc have the hardware and software tools they need to do their jobs. Read More »

Welcome to Complementary Training Community! Forums Excel Tricks for S&C Coaches: Beginner to Advanced – Module 4

Tagged: ,

This topic contains 3 replies, has 4 voices, and was last updated by  Daniel Estalayo 1 year, 8 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • 24/01/2018 at 17:49 #21779

    This is an excellent course, I’ve started setting out excel sheets just for the fun.

    12/02/2018 at 14:09 #22031

    Dear Mark, we are glad that you enjoyed the course. Keep up the good work and we will try to surprise you with more educative & interesting content in the near future!


    29/09/2022 at 18:06 #36785

    Hi. I can’t find the file with the practice exercises, the only spreadsheets in the downloaded zip are related to the Fitbit project. Am I missing something?
    Thanks. Daniel

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.