YoVDO

Excel VBA and Macros programming for Absolute Beginners

Offered By: Skillshare

Tags

Microsoft Excel Courses User Interface Design Courses Macros Courses Excel VBA Courses

Course Description

Overview

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.


Syllabus

  • 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
  • VBA AutoOpen
  • Object Variables and With statement_ Learn to stop repeating
  • Opening Notepad With VBA
  • Make VBA Speak for us
  • How to paste data to new workbook and save it
  • Creating Duplicates exists program
  • How to delay the code execution

Taught by

Muhammad Ali Yasin

Related Courses

The Ultimate Excel Programmer Course
Udemy
Microsoft Excel VBA for Beginners - Learn VBA Step by Step
Udemy
Excel VBA Programming - The Complete Guide
Udemy
Beginners to Expert Excel and Excel VBA 38 Hours Mega Course
Udemy
Excel VBA&Makro Programmierung: Jetzt richtig durchstarten!
Udemy