Excel VBA -Learn Visual Basic macros (Beginner to Advanced)

1. 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.

   
   

2. 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!

   
   

3. 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