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!

So this has been bugging me for years, on different machines.

Sometimes I copy something, go to another sheet try to paste...aaaand nothing is Copied.

I go back, Ctrl CCCCCCC, go back and paste no problem.

"Now maybe I didn't press Ctrl+C correct the first time" was my reasoning, but... no, I do press it, learnt it with enough of this happening.

I tried googling and came across a few threads but not the exact thing.

Anybody has this 'issue' or know what could be up?

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!