I have not used Microsoft Excel as a Scouting tool, but I have heard that it is a pain to use and looking at it from a Scouting perspective I can see why that would be so. This year my team is starting to use a program called Tableau for our Scouting organization. Using an app we created to gather the data then putting it on the program to organize and quickly use. It is free for FRC teams as long as you get the code, mentors should have access to it I believe, I know my Scouting mentor did.
https://firstfrc.blob.core.windows.n...amUpdate03.pdf
Here is the link, and hopefully your mentor has access to the code to get it for free, there are actual tutorials on how to use this application, and you wont find very many tutorials on Excel scouting.
Good luck.