Overall most people tend to learn better this way rather than trying to learn all Excel formulas at the same time as this can be very confusing. Most of us tend to learn in smaller packages of information and you should look for a course of instruction that will allow you to do this. As you are learning to use Excel you should of course start by learning to use the formulas that you are actually using or are likely to have need of in the immediate future.
Well, let‘s take a look at your situation. What level are your athletes or clients at? New athletes or clients probably would not benefit from percentages as much as more advanced clients, as they need to learn how to perform the lift correctly first and foremost. Second, a new client will adapt to the exercise so fast that by the next time you perform the exercise, their 1 rep max may be out of date and thus their percentages would be incorrect (if they used to bench 100lbs, but after 2 workouts they can bench 110lbs, that 60% you have them working out as now too low to cause the adaptation you are looking for).