Excel VBA and Macros programming for Absolute Beginners

Muhammad Ali Yasin

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
30 Videos (1h 50m)
    • Introduction to course and Me

      0:55
    • What is Excel VBA ?

      4:27
    • VBA Macro Recorder

      3:06
    • Absolute vs Relative Reference

      7:22
    • How to protect your code ?

      2:42
    • Getting to know VBA environment

      5:46
    • Excel VBA Variables

      4:17
    • Learning Range,Cells,Active cell etc.

      8:30
    • Introduction to VBA Sheets and Workbooks

      4:48
    • Introduction To Functions

      5:20
    • IF THEN ELSE Statement

      3:05
    • SELECT CASE Statement

      4:23
    • Do While and Do Until Loop Statement

      3:02
    • VBA FOR Loop statement

      2:28
    • Message Box detailed

      3:42
    • Input Box detailed

      1:34
    • Getting Started with Forms

      2:50
    • coding close button and adding Text Boxes

      1:13
    • How to access last row of worksheet in Excel

      2:35
    • Adding Nationality and Date of Birth to project

      3:22
    • Adding Combo Box

      3:51
    • Adding Gender and Contact Number

      4:11
    • Recreating project using Active X Controls

      3:05
    • VBA AutoOpen

      1:36
    • Object Variables and With statement_ Learn to stop repeating

      3:48
    • Opening Notepad With VBA

      6:45
    • Make VBA Speak for us

      2:38
    • How to paste data to new workbook and save it

      3:09
    • Creating Duplicates exists program

      2:51
    • How to delay the code execution

      2:17

About This Class

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.