Excel Tutorials for Strength & Conditioning CoachesSimple Exercise DropdownsThe most basic way to get information from a list into a dropdown.Advanced exercise dropdownsUsing tables, data validation and indirects, this is how I still do my exercise lists today! Download Demo Template Automatically Create Backup Copies on SaveEvery time you save your template, this code will create an auto-backup of it in another file to prevent against corruption.Using Index / MatchIndex match works much like VLOOKUP, but it allows you to find data either left or right of the central data point.MROUND vs CeilingThe difference between MROUND and CEILING in calculating weights in Excel! View Post Calculating Volume in ExcelHow to calculate Volume in your Excel Strength & Conditioning Template View Post Calculating multiple weights within one cellHow to calculate a weight range in Excel using a range of %s. View Post Implementing Wellness Questionnaire Monitoring into your SpreadsheetHow to add a few questions, pre or post workout, for your athletes to answer. View Post Removing Unnecessary Zeros in ExcelSometimes in excel, when calculating weights for athletes, if there is no % it will show a zero. Here is how to hide that. View Post Building an Excel S&C Template LayoutLive build of me making a template in Excel View Video View Gallery for Demo / Example Strength Training Excel Templates!