Did you know that repetition is a curse, if you don't stop then you'll be wasting thousands of hours of your life. As an Excel user, you know that many times you create same sheet, with same formatting and same formulas, again and again. So, you're wasting thousands of hours, which you can spend with your family, or doing other important stuff.
Luckily, there is a tool or a language using which you can save those thousand hours of your life by creating a simple program which does the work for you. The program will create the sheet for you, it'll format it for you and it'll insert the formulas you. Not just that It'll protect your data in different ways.
Excel VBA, the programming language we're going to learn in this course which'll help you automate your daily tasks more smarter and more easier. You'll be able to tackle different and complicated situations easier.
So, don't waste anymore hour or second of your life and take this course immediately, uncover the tools which'll make your life easier.
Introduction to course and Me
What is Excel VBA ?
VBA Macro Recorder
Absolute vs Relative Reference
How to protect your code ?
Getting to know VBA environment
Excel VBA Variables
Learning Range,Cells,Active cell etc.
Introduction to VBA Sheets and Workbooks
Introduction To Functions
IF THEN ELSE Statement
SELECT CASE Statement
Do While and Do Until Loop Statement
VBA FOR Loop statement
Message Box detailed
Input Box detailed
Getting Started with Forms
coding close button and adding Text Boxes
Adding Nationality and Date of Birth to project
Adding Combo Box
Adding Gender and Contact Number
Recreating project using Active X Controls
Object Variables and With statement_ Learn to stop repeating