Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Blender
30-Day Money-Back Guarantee

This course includes:

  • 6 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel VBA

Mastering MS Excel VBA For Beginners

Learning MS Excel VBA from beginner level to advanced level
Rating: 4.1 out of 54.1 (352 ratings)
4,337 students
Created by Alvin Pillay
Last updated 10/2016
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Write VBA Code to automate the things you do in Excel
  • Use VBA Code to do things in Excel that otherwise wouldn't be possible
  • Save precious time at work by automating repetitive Excel tasks
  • Impress your colleagues and managers
  • Improve your hiring skils

Requirements

  • MS Excel 2007 and later
  • No prior programming knowledge
  • No prior VBA knowledge
  • Very basic MS Excel knowledge (Like how to reference a cell by row and column and how to write a simple excel formula in a cell.)

Description

Interested in learning VBA for Microsoft Excel? Well, you’ve come to the right place. My Mastering VBA for Excel will take you from beginner to master in a very short time. Join me on this journey and allow me to teach you VBA for MS Excel.

So why learn MS Excel VBA. MS excel is already a very easy to use piece of software and very flexible. It has a myriad of uses. Learning VBA for MS Excel, will allow you to automate existing things you do in Excel, so that you can save time and make your life easier. It can also make excel do things that you would never have been able to do without VBA.

You can use these skills to make your day to day working life easier, impress your colleagues or your boss.

Learning MS Excel VBA is a life skill that will not be wasted. There will always be an opportunity to use it.

This course consists of over 50 easy to follow videos. That equates to over 5 hrs of fun learning. If you want to, you can learn excel VBA in one week, by spending an hour each day. With some extra time for practicing. However, I would recommend doing it a bit slower, say 2-3 videos a day, with lots of coding practice.  All code used in the videos are made available for you to download.

Who this course is for:

  • Anyone that uses MS Excel

Course content

7 sections • 55 lectures • 5h 58m total length

  • Preview05:00
  • 1.1 Introduction to VBA for MS Excel
    03:46
  • 1.2 Download Course Materials
    00:11

  • Preview05:07
  • Preview05:42
  • Preview09:13
  • 2.4 Object Hierarchy
    14:33
  • 2.5 Variable Basics
    11:41
  • 2.6 Set Command
    05:05
  • 2.7 Range vs Cell
    13:11
  • 2.8 Debugging and Debug Windows
    11:56

  • 3.1.1 Contiguous Data Range - Part 1
    13:11
  • 3.1.2. Contiguous Data Range - Part 2
    04:08
  • 3.2 Copy & Paste
    11:25
  • 3.3 With Command
    08:38
  • 3.4 Formulas
    06:28
  • 3.5 Question Box
    04:38
  • 3.6.1 Inputbox
    04:29
  • 3.6.2 Inputbox Validation
    04:57
  • 3.7 Sorting
    06:50
  • 3.8.1 Error Handling - Part 1
    05:33
  • 3.8.2 Error Handling - Part 2
    03:34
  • 3.8.3 Error Handling - Part 3
    02:34

  • 4.1.1 Variables and Datatypes - Part 1
    09:54
  • 4.1.2 Variables and Datatypes - Part 2
    08:58
  • 4.2 Public, Private & Constant Variables
    06:51
  • 4.3.1 If Then Else - Part 1
    09:45
  • 4.3.2 If Then Else - Part 2
    02:53
  • 4.4 If Then ElseIf
    10:43
  • 4.5 Select Case
    03:41
  • 4.6.1 For Loop - Part 1
    06:36
  • 4.6.2 For Loop - Part 2
    01:23
  • 4.7 Do Until Loop
    03:12
  • 4.8 Do Loop Until
    04:16
  • 4.9 Do While Loop & 4.10 Do Loop While
    03:59
  • 4.11 Calling Procedures
    10:44
  • 4.12.1 Functions - Part 1
    06:01
  • 4.12.2 Functions - Part 2
    04:12
  • 4.13.1 Arrays - Static Arrays
    11:07
  • 4.13.2 Arrays - Dynamic Arrays
    08:19
  • 4.13.3 Arrays - Erase Static Array
    02:18
  • 4.13.4 Arrays - Two Dimensional Arrays
    05:09
  • 4.13.5 Arrays - Read From and Write To Sheet
    05:03
  • 4.13.6 Arrays - Quick Read From and Write To Sheet
    03:50

  • Preview07:16
  • 5.2 Add Sheet to Workbook
    05:11
  • 5.3.1 Duplicate Counter - Part 1
    10:14
  • 5.3.2 Duplicate Counter - Part 2
    09:52

  • 6.1 Activate Sheet Event
    04:45
  • 6.2 Deactivate Sheet Event
    04:15
  • 6.3 Change Sheet Event
    11:46

  • 7.1 Open Workbook Event
    02:26
  • 7.2 New Sheet Event
    02:04
  • 7.3 Sheet Deactivate Event
    02:51
  • 7.4 Before Save Event
    06:45

Instructor

Alvin Pillay
VBA for MS Excel and MS Access Enthusiast
Alvin Pillay
  • 4.2 Instructor Rating
  • 579 Reviews
  • 6,959 Students
  • 2 Courses

I am an engineer with over 20 years expierence using Microsoft Office products. I have used MSAcess and MSExcel for various data migration and data analysis projects. More recently I have been doing a lot of work with MSExcel VBA. With the knowledge I have gained, I thought it beneficial that I share this with others that are wanting to get up to speed quickly with MSExcel VBA.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.