i made a google sheet a work that took rsvps from our instructors who are agreeing to teach this year out of the system where they RSVPed
then it calculates a unique ID for them based on name and local union
then there are sheets broken out by course number (because each first number has a different person coordinating those instructors) and filled with the info we used to contact them. these generate the same unique ID from their name and local union
then i used if(iserror(vlookup script to pull over their rsvp, the email they entered, and any questions or concerns they had
and then i used conditional formatting to highlight anyone whose entered email didn't match the one we sent their invite to so we can update it in our system
and my boss took one look at this and said "you know no one else in our department can do anything even approaching this?"
so i texted my dad to thank him for teaching me how to do vlookups.
sincerely, if you are starting out in your career, learn how to make excel do a tiny bit of magic and you will go so so very far.
learn how to do vlookup, xlookup, if, iserror, countif, and sum and you'll be most of the way there. conditional formatting is annoying, but useful. pivot tables, if used correctly, might get you referred to the spanish inquisition. and VBA scripts! you can do so much stuff automatically with VBA. I use it every year to break our course evaluation master into individual sheets based on course and instructor. takes me 20 minutes instead of 3 weeks it would take doing it by hand.
you can get a lot of pre-written VBA code online as well, so as long as you know how to activate the developer console, you'll be fine. it's nowhere near as scary as you think it's gonna be.
learn excel. learn spreadsheets. you'll thank me for it.