VBA for Financial Modeling Excel Automation
What you’ll learn
Excel VBA
Excel Automation
VBA editor use
Modeling workflow improvements
Requirements
Excel knowledge
Description
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!
Overview
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
Section 10: GRAND CONCLUSION & ADDITIONAL CONTENT!
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