Excel Tutorials for Strength & Conditioning Coaches

Using Index / Match

Video Notes

Using INDEX/Match Instead of VLOOKUP!

Automatically Create Backup Copies on Save

Every time you save your template, this code will create an auto-backup of it in another file to prevent against corruption.


MROUND vs Ceiling

The difference between MROUND and CEILING in calculating weights in Excel!


Calculating Volume in Excel

How to calculate Volume in your Excel Strength & Conditioning Template


Calculating multiple weights within one cell

How to calculate a weight range in Excel using a range of %s.


Implementing Wellness Questionnaire Monitoring into your Spreadsheet

How to calculate a weight range in Excel using a range of %s.


Removing Unnecessary Zeros in Excel

Sometimes in excel, when calculating weights for athletes, if there is no % it will show a zero. Here is how to hide that.


Building an Excel S&C Template Layout

Live build of me making a template in Excel