VBA for Financial Modeling Excel Automation

Automate repetitive work tasks and revolutionise your productivity!
VBA for Financial Modeling Excel Automation
File Size :
2.30 GB
Total length :
4h 15m



DealMaker Financial Training


Last update




VBA for Financial Modeling Excel Automation

What you’ll learn

Excel VBA
Excel Automation
VBA editor use
Modeling workflow improvements

VBA for Financial Modeling Excel Automation


Excel knowledge


THIS COURSE WILL CHANGE EVERYTHING…!!!Yes, of course I’d say that…. but this time it’s true!How many times have you…Had to clean up your financial model to share with clients?Had to reconfigure Excel display settings because they got messed up?Lost sleep because you didn’t keep your financial model’s log up to date?Had to repeatedly go through the financial model to manually remove sensitive information?Wasted time keeping track of all the defined names in your model?Had to lose time manually saving files for every case and scenario you calculate?How would you feel… if all you had to do… was press a magic button and BOOM!  You finish in less than 1 second???And what would it be worth to YOU, to know how to build your own Excel automation routines to take over the repetitive grunt work you always knew was a job for machines to do???Learning VBA can give you ALL OF THIS!This course teaches VBA to automate Excel by guiding you through SEVEN automation tools built for financial modelers!You won’t be left scratching your head wondering what all the VBA’s for because you will be using it straight away to discover how to save yourself time at work!I simply can’t imagine a world without VBA now… I mean how would you feel if they took away your keyboard??? … the INTERNET?????!!!Once you know the secrets of VBA, you will never look back and frankly, the way you use Excel will never be the same again…New doors will open – and you will be flying through them!


Section 1: Introduction & VBA study preparations!

Lecture 1 Why Learn VBA???

Lecture 2 My VBA journey, and why made this course!

Lecture 3 Making the best of the course: tips and prerequisites!

Lecture 4 The ONLY way you’ll learn how to code… (for REAL!!)

Section 2: Mastering the VBA editor

Lecture 5 Editor text types and text events

Lecture 6 The Main Code Window

Lecture 7 VBA editor modes

Lecture 8 The Immediate Window

Lecture 9 The Locals and Call Stack Windows

Lecture 10 The Watch WIndow

Lecture 11 The Project and Property Windows

Lecture 12 TEN Top Tips for using the VBA Editor!

Section 3: Auto-tidy tool

Lecture 13 Project use case, and VBA for build

Lecture 14 Code walkthrough

Section 4: Smarter “new window” views

Lecture 15 Project use case, and VBA for build

Lecture 16 Code walkthrough

Section 5: Smart-log tool

Lecture 17 Introduction and project use case

Lecture 18 VBA for build – core logging tool

Lecture 19 Code walkthrough – core logging tool

Lecture 20 VBA for build – automatic reminders and saving

Lecture 21 Code walkthrough – automatic reminders and saving

Section 6: Automatic redaction sequencing

Lecture 22 Project use case, and VBA for build

Lecture 23 Code walkthrough

Section 7: Make your own FORMULAS!

Lecture 24 Project use case and code walkthrough

Section 8: BETTER defined name management

Lecture 25 Project use case, and VBA for build – tool UDFs

Lecture 26 Code walkthrough – tool UDFs

Lecture 27 VBA for build – comment entry and one-click access to default Names manager

Lecture 28 Code walkthrough

Section 9: The BEST scenario manager!!

Lecture 29 Project use case, and VBA for build

Lecture 30 Code walkthrough


Lecture 31 BONUS LECTURE!!!

Financial modelers and analysts wanting to learn useful VBA!,Excel users looking for an applied VBA course

Course Information:

Udemy | English | 4h 15m | 2.30 GB
Created by: DealMaker Financial Training

You Can See More Courses in the Business >> Greetings from CourseDown.com

New Courses

Scroll to Top