Interested in learning macros?
Either you wanted to learn macros to automate your task or to start your career in VBA programming or just wanted o highlight your performance in appraisals using VBA then this is perfect starter course for you,
We can automate several lengthy tasks like reporting, data analysis and so on.
This is starter course to VBA & Macros for absolute beginner. You will get familiar with use of macro recordings to automate tasks, basic concepts and learn some important techniques which will help you to improve your code and get more from recorded macros. You will also learn Excel formulas and references types.
You will get discount coupons for my others upcoming course for as you will be an existing students.
You will learn VBA object model
you will learn how to setup VBA editor and its important tools
You will learn different types for files and their pro n cons
You will learn different types of macro security
You will get overview of macro recording in this lecture
You will learn how to run existing macros
You will learn how to record macros
You will learn how to delete a macro
You will learn types of macro recordings
You will learn different ways to trigger your macros
You will learn how to run your recorded macro on specific event
You will write your first VBA program
You will first time interact with variables in your program.
You will learn different types of variables
You will learn variable declaration, its advantages, how to use comments and expert developers best pratices
You will learn how to write code for more than one condition
You will learn different types and IF statement and how to efficiently use them into your VBA code
Another Type of Condition
You will get introduction of loop and its components.
You will see how to use while loop with an example
You will learn use of For Loop
This lession will explain a special type of for loop which you will be able to apply on objects
This loop has different working pattern
You will be able to design form as per your requierment.
You will learn how to write a code for a specific control of form in VBA
You will learn key points to enhance your forms to give it a proffessional touch
You will learn how to improve your macros
Congratulations!! You have completed macro starter course.
My name is Rajesh Mhatre.
I was crazy to get a programming job. I started from automation with VBA and I really loved it. I started reading books from different authors checking videos but just this did not helped me to achieve mastery but when I worked on different real development projects I got that expert shine. I used to work 12- 14 hours per day as it became my passion.
Now I am having 7+ years of experience. I worked for different companies such as IT Firms, Investment Banks, Accounting firms and KPO on different roles such as MIS Specialist, Automation specialist, Senior Software developer and every where I experienced different use and power of VBA. I like to teach and I turned many students to a software developer. I also write blog so such students can get tips.
I wanted to share my all core knowledge to all of you. So you don't have to spend so much time to become an expert.