If you're not familiar with excel tables you should start there. Otherwise;
Google how to turn on developer tab in excel and get access to VBA. Shortcut is Alt+F11
VBA is fun but I personally feel dumber the more I use it; there's a lot of trial and error to make it work and sometimes it doesn't make sense yet my scripts work so I don't dwell on it.
I have a penchant for Excel formulas as they contain everything you need within your workbook. They're ugly to look at and it doesn't take much to spawn a monster but unlike VBA they won't require your coworkers to know what macros are and how to use them, and from a security perspective you'll be safe from any malicious code.
My work involves a lot of spreadsheet data detective work so VBA macro to gather up lots of sheets neatly comes in handy, while INDEX MATCH is the way to cross-reference values and fill in blanks. Those are two formulas where MATCH is placed inside INDEX where you would otherwise specify a row number. Google how to use it and once you feel comfortable, check out how to use Array formulas which will allow you to have multiple criteria in your matches.
If you're more interested in programming a good place to start is
Visual Studio download. Choose "Download Community Free"
He assumes you're not an idiot so he goes forward fast but I think he explains well.
Once you're done with that course, a bit more in-depth practice is the C# Programming Yellow Book: PDF
Last but not least is Powershell. You probably already have it installed - press Start menu and write Powershell and it'll show up.
It looks like the command prompt (cmd) but it's basically a terminal that provides access to .NET and C#. Lots of documentation to read there so probably only for the specially interested.
You can start with the Get-Help command.