Excel VBA -Learn Visual Basic macros (Beginner to Advanced) - Become a Guru in Microsoft Excel macros (VBA) to automate your tasks, reports, dashboards and analysis with Visual Basic
PREVIEW THIS COURSE - GET COUPON CODE
Description
Why learn Microsoft Excel Visual Basic (VBA): Today, Ms Excel is becoming the tool of choice in companies (in the USA alone, more than 500,000 companies actively use Excel) to be able to perform analysis and present data in a Quick way. A lot of the work won't require complicated models and can be set up in an automated way.
Work Smarter not Harder: With the advance of technology and information, jobs are becoming more and more challenging. In addition, data and analysis are becoming more and more accessible with time. The difference in productivity between a NOOB in Excel and an advanced User is more than 10X. Imagine automating your task and using your time for more productive activities!
Why this course:
Excel has the power to access anything you can do on the computer. You will be surprised how much you can automated & save time!
Learn how to automate reports. While you are home asleep, you computer can download data, analyze it, create a report and send it out!
Coding could be daunting at first. With this course, you will see that it's easy if you go step by step
This course teaches you how to understand coding and memorize the minimum - This will enable you to find code, modify it and use it
Unlike many courses, this course teaches you how to use code in real life - You will see examples you can relate to such as copy pasting, dashboards, creating customized letter, etc...
Course is designed for all levels: Whether you want to learn from scratch or deepen your understanding in VBA, you are at the right place!
4. Curriculum - Practical Hands on Excel Visual Basic (VBA):
Dealing with Files & Folders
Interacting with Applications such as PDF, PPT and Word
Creating your own formulas & Functions (Like what you have in Excel)
Manipulating Excel Tables and Pivot Tables
ActiveX and Form controls
Userforms
Triggering macros based on events
Comparison though looping in Collections
Conditional & Logical operators (Even partial match)
Loops (For, do, while etc...)
Referencing cells & copy pasting
Variables & how to use excel formulas in VBA
How to use the macro recorder
Msgbox with inputs from user
Error Handling & Debugging
Manipulating text and dates
Arrays
5. What you will learn:
What you need to know to complete most assignments
Best practices in coding such as identing, commenting, using variables, reusing code
Building automated Reports, Analysis & Dashboards (including how to get the raw data automatically
How to search for a code you don't know - Using the macro recorder, internet and more...
How to build faster codes
Useful Shortcuts
How to deal with Errors
Functionalities of The Visual Basic Editor
How to create applications with cool userforms and graphs/pics in the form
How to simulate typing on the keyboard
How to run your macro while you are not there
And many more!
6. About me:
Harvard MBA
Extensive consulting experience with McKinsey & Co, having learned the ability to dissect problems and perform complex analysis in no time
11+ years as a Vice President in a bank heading analytical and strategy teams
Built the whole analytics department of a 3500+ employee share services subsidiary
Degree in Computational Sciences among others
Well versed in Data and Artificial intelligence, having built chatbots
Passion for teaching Excel as a backbone to increasing productivity
Who this course is for:
- Beginners with no prior knowledge of VBA: You will learn step by step
- Intermediate VBA users: You will be able to sharper your skill and take away a wealth of codes to use to in your projects
