r/excel

I've always been dissatisfied with the types of Excel resources online. My main complaint is it's rare to see different Excel tips used in tandem - which, in my opinion, is the key to remembering the tips.

I've started off a new channel with a 30-minute project, centered around lookup functions XLOOKUP and INDEX XMATCH, with the different tips within the video split out on their own. The idea is to point people back to the larger project.

Here's the long project:

Here's one of my clip-outs, as an example, this one doing Data Validation with a dynamic list in a table:

I would expect most readers to be more advanced than the target audience of this particular video, but would appreciate any thoughts or ideas. If you're unsatisfied with Excel videos online, too, would be happy to hear why!

As the title suggests, I’m curious what my fellow Excel users out there do for work!

I have an accounting degree and my current job is very process oriented, but I’m going to need to find a new job within the next year or so. I’ve been tinkering lately with learning more about Excel, Access, VBA, SQL, etc. and really enjoying it, so I’m interested to know what others are doing with their skills :)

Thanks in advance!