I bet there is some type of video  tutorial out there.
But I'm more of a "hands-on" kind of guy.
What you're asking is like saying:
"I have a car, but is there a video to show me how to drive".
sure. you can find a video, but until you actually get behind the wheel
and start down the road, you really can't get the feeling.. you know?

As the saying goes:
"If you don't know where you're going, any road will take you there"

You need a PURPOSE, some objective so you know when you've arrived.
Look through the emails in this group and try to solve the problems yourself.
they'll help you branch out into areas you normally wouldn't travel.

You act like "writing" macros  and "record short and simple" macros is not the
same thing.
Many, many times, when I need to do add something to one of my macros,
I'll record  what I want to do, then copy/paste it into my macro and modify it
to work with my application.

I've got a spreadsheet with nearly 11,000 lines of code backing it up.
I need to modify it so that records with a specific attribute are changed to
bold
and the background changed to blue.
I recorded a macro to change the font and color, then in the code where I
locate the line in question, I copied in the recorded code.
I don't waste my time trying to remember the syntax to "write it on my own"...

I'd say you need to learn  how to use the VBA debugger, Watch window and
Immediate Window.