VBA programming

File: digimon lole.jpg (20KB, 500x375px) Image search: [Google]

20KB, 500x375px

Hello, /adv/, I have a need of knowledge and advice.
So at this new work (it's mah third week) we work a lot in Excel. We don't program it or anything, we just use it all the fucking time.
My higher ups want me to learn VBA so I could keep programming Excel and continue what others have done. The thing is - What's written so far is for advanced people, and not noobs like me. My only experience in coding was creating a small text game via C#.
I know most of the basic terms.
I have until Thursday to study a LOOOTTT of VBA coding, and I seek your advice.

Also, when I say what's written so far is complicated, I mean it's fucking MASSIVE. Pages upon pages of code which allows the normal workers to use special functions, like pressing on a button to automatically send mail, or to keep a special tab of notes which you can save & load at will and even edit.

Where is the best place to learn it, what's the best way to go over the subject, and how the hell I can remember all of it?

I'm currently on this series of vids:
youtube.com/watch?v=c8reU-H1PKQ&list=PLNIs-AWhQzckr8Dgmgb3akx_gFMnpxTN5&index=5

pic related, digimon are in the computer.