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+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel VBA

Excel VBA - The Complete Excel VBA Course for Beginners

Learn Excel VBA and take your spreadsheets to the next level.
Rating: 4.3 out of 54.3 (1,313 ratings)
7,421 students
Created by Alan Murray
Last updated 10/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Write powerful Excel VBA code to automate processes
  • Identify real world situations where you can apply your new VBA skills
  • Understand, test and debug VBA errors
  • Lifetime access to the lessons, practice files, exercises, and 1-on-1 instructor support
  • Fun and effective lessons including 'real world' Excel VBA projects to complete
  • Projects and challenges to practice your skills

Requirements

  • An intermediate to advanced knowledge of Excel
  • The course is taught in Excel 2010, but the lessons will work in any version unless stated
  • No prior programming skills are necessary. The course starts with the basics

Description

Hear What Some of Our Students are Saying.....

"Really, really good course on VBA! *****"

"Great content, great examples, would definitely take another course from this instructor again!"

"Excellent course for getting started with VBA. The instructor makes every concept clear, and guides you through with many examples.

"Great course for a beginner or as a refresher. I know I will be coming back to some of these lectures as needed for some of his code tidbits because as he says, "you can't remember everything", and I love knowing where I can find what I am looking for.

Want to take your Excel skills to the next level and learn Excel VBA? Well, you have come to the right place.

This course covers everything you need to become proficient in Excel VBA. In just a few hours you can be writing your own macros to perform complex tasks and automate reports.

Areas covered include; 

  • Learning the basics of the VBA language.

  • Using loops to perform repetitive tasks.

  • Interacting with users via userforms and message boxes.

  • Working with built-in VBA Functions.

  • Accessing directories and files.

  • Automating report generation and saving as PDF.

  • Creating your own Excel functions and Add-Ins.

You will receive; 

  • Support from the Instructor.

  • Lifetime access to lectures and content.

  • Real-world Excel VBA projects to complete.

  • Fun and no-nonsense lessons.

  Ok, no more time for waffle. Grab a coffee and let's get cracking. 

Who this course is for:

  • You want to learn VBA to take your skills to the next level
  • You want to automate reports and save time on repetitive and boring tasks
  • This course is probably not for those with VBA experience who are looking for advanced VBA.

Course content

15 sections • 75 lectures • 12h 19m total length

  • Preview03:09
  • Download These Files First
    00:08

  • Preview14:29
  • Preview06:42
  • Preview07:42
  • Editing your Macro Code 1
    12:16
  • Using Relative References when Recording Macros
    Preview06:38
  • Preview05:32
  • Editing your Macro Code 2
    Preview06:08
  • Preview05:50

  • Preview07:38
  • Writing your First Macro
    16:43
  • Cleaning Recorded Code
    12:01
  • Preview08:39
  • Referring to Cells, sheets and Workbooks
    27:06
  • Errors in VBA
    09:00
  • Introduction to VBA Quiz
    7 questions
  • Recording and Editing Macros Challenge
    00:42
  • Recording and Editing Macros Challenge Answer
    08:35

  • Using Variables
    17:24
  • The Role of Option Explicit
    10:27
  • Variable Scope
    09:08
  • Using Object Variables
    09:39
  • Using Variables Quiz
    5 questions

  • If..Then..Else Statements
    10:04
  • Select Case Statements
    06:03

  • Conditional Loops
    08:25
  • Using the Cells Object with a Loop
    06:36
  • Conditional Loops - Updating an Inventory List
    24:53
  • Counter Loops - Delete Blank Rows on a Worksheet
    20:11
  • Counter Loops - Protect All the Worksheets in a Workbook
    05:50
  • Collection Loops - Convert Selected Text to Uppercase
    08:05
  • Nesting Loops - Updating an Inventory List 2
    16:16
  • Make your Procedures Faster and Stop Interference
    09:53
  • Looping Challenge
    00:28
  • Looping Challenge Answer
    05:58
  • Looping Challenge 2
    00:20
  • Looping Challenge 2 Answer
    02:54

  • Debugging Code
    18:51
  • On Error Resume Next
    05:39
  • Creating Error Handlers
    09:18
  • Using Multiple Error Handlers
    15:33
  • The Err Object
    07:03
  • Other Ways of Handling Anticipated Errors
    08:15

  • Message Boxes - Updating an Inventory List 3
    11:14
  • Input Boxes
    15:25
  • Dialog Boxes - Using the Save As Dialog Box
    14:18

  • Loop Through all Files in a Folder
    21:04
  • Loop Through Specific Files of Type - List File Names on a Worksheet
    12:02
  • Create Directories and Export as PDF
    14:50

  • Introduction to Arrays – One-Dimensional Fixed Arrays
    17:11
  • Two-Dimensional Arrays
    11:45
  • Dynamic Arrays
    14:28

Instructor

Alan Murray
Microsoft MVP, Founder of Computergaga
Alan Murray
  • 4.5 Instructor Rating
  • 2,103 Reviews
  • 17,672 Students
  • 5 Courses

Alan Murray is a Microsoft MVP and  Excel trainer. He has been training for over 20 years for businesses around the world.

He is the founder of the Computergaga blog and YouTube channel. It has over 530 videos and more than 28 million views. He regularly shares new Excel tips and tutorials.

He is the author of the "Advanced Excel Success" book, showing hwo to get to the next level in your Excel jurney.

Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses.

Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours. 

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