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 Mindfulness Personal Transformation 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 Online Business Freelancing 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: How to Write Macros Like a Professional

Learn how to write real-world Excel VBA Macros from scratch. No experience required!
Rating: 4.5 out of 54.5 (1,138 ratings)
7,123 students
Created by Paul Kelly
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn little-known techniques used by the top professionals
  • Over 70 example Macros for you to use in your own projects
  • Discover the best method to access a worksheet and the ones you should avoid
  • Learn how to use Intellisense to help you write your code
  • Learn how to supercharge your Excel experience using Loops
  • How to resolve errors quickly and painlessly
  • Learn programming techniques you can use in any programming language
  • Learn When to use "If" and when to use "Select"
  • Learn the 4 Loops of Excel and when to use each one
  • How to test your output before writing to a worksheet
  • Discover how to protect your code against users changing the worksheet name
  • Learn how to use the Compiler to check for errors before you run
  • Learn the best way to use Range, Cells and Offset to access the cells
  • Learn how to easily format any cell or range
  • Discover how easy it is to step through the code line by line
Curated for the Udemy for Business collection

Requirements

  • Knowledge of Microsoft Excel
  • A Laptop/PC with a copy of Microsoft Excel

Description

September 2018 Added New Content!

How to Copy and Filter Data using Excel VBA

This new section comes with 13 Exercises plus full solutions to help you practice and reinforce what you have learned.

-----------------------------------------------------------------------------------------------------------------

April 2018 Added New Content!

Learn how to build an entire Excel VBA application from start to finish. In this brand new section you will see techniques not taught in any other Excel VBA course. 

This new section(number 15) contains proven principles and little-known techniques that will help you build an application in a fraction of the time it would normally take you. 

You will also learn tips and tricks that will reduce your errors, make your code more organised,  and make your applications easier to maintain and update.

This is the only Excel VBA course that shows you first hand, a professional developer creating a VBA application from scratch. 

-----------------------------------------------------------------------------------------------------------------

January 2018 Added New Content!

Using Arrays in Excel VBA: 6 brand new lectures.



FINALLY! A Way To Write Excel VBA Like a Professional

If you think the top Excel VBA programmers are smarter or more gifted than you, then you're mistaken. Truth is, they use dozens of proven programming principles.... little-known techniques that are completely unknown to most VBA users. What are these principles? How can you learn them? And how can you use them to create your own Macros? In this course, Paul Kelly teaches you dozens of must-have secrets that he learned during his 20+ years as a professional software developer, including 

*How To Easily Open Any Workbook - I provide the code, You can use it everywhere!

* Why using Loops can increase your productivity exponentially - Start using them immediately

* How To Create a Real-World VBA Project - A step-by-step guide through a Fruit Sales example project

* The Error Translator Table - An easy way to resolve errors that should have been written years ago

* Which worksheet method to use - Your code will still work even if the user changes the sheet name!

* How to easily test the output of your macros - It's childs play to write values to this Window

* How To Quickly Create Solid Excel Macros - Tons of examples you can "steal" for yourself.

* The In Built VBA Tools That Help You Easily Find Bugs - If you think you would make a good detective then you may really enjoy this

* How to Easily Format any Cell - Changing a cells font, color, format is so simple you could do it now.

* These "Evil" Workbook types should never be used - Do You Use them?

* And Much More. 

Remember if you are not happy with the course for any reason you can get a FULL REFUND within 30 days - no questions asked!!!

Who this course is for:

  • Accountants/Auditors/Financial planners
  • Business/Financial Analysts
  • Managers/Project Managers/Project Planners
  • Anyone who wants to learn how to write VBA in a professional environment
  • Anyone who wants to exponentially increase their productivity at work
  • Anyone who wants an introduction to programming with a straightforward langauge
  • Anyone who wants to increase their value to their current or potential employer
  • Any user of Excel who wants to dramatically increase their abiltiy

Featured review

Ben Holtzman
Ben Holtzman
1457 courses
67 reviews
Rating: 5.0 out of 5a year ago
I usually don't like giving reviews until I've seen most or all of the course. But I'm going to make an exception here. I've never seen a more helpful set of tip and tricks in a VBA course. Paul did an amazing job and is helping to make my job quite a bit more efficient. Thank you Paul! You're providing very high value for me right now.

Course content

16 sections • 83 lectures • 5h 36m total length

  • Preview02:23
  • A Welcome Note From Paul and Course Source Code
    1 page
  • Preview1 page
  • Preview1 page

  • Preview01:55
  • Your First Macro
    04:47
  • Preview04:36
  • The Immediate Window - How to easily test your output
    02:40
  • Preview03:39
  • Getting Started - Support Text
    11 pages

  • Preview01:46
  • How to get any Workbook
    03:45
  • When to use each Workbook method
    01:00
  • Making your code easy to read - Use a Workbook variable
    03:20
  • How to get any Worksheet
    03:32
  • Putting it all together - A sample Macro
    06:16
  • VBA's best kept secret - the worksheet codename
    04:03
  • The Sample Macro - How the code name improves it
    03:08
  • Summary of Worksheets and Workbooks
    04:09
  • Workbooks and Worksheets - Downloadable Guide
    10 pages
  • Workbooks and Worksheets Quiz
    10 questions

  • An introduction to Variables
    04:37
  • How to do almost anything with a string
    03:30
  • Using variables to write and read from Cells
    03:08

  • Using Range to manipulate cells
    03:14
  • Using Cells - How to choose cells at run time part 1
    04:38
  • Using Offset - How to choose cells at run time part 2
    02:38
  • Sample Macro - Writing to months using Offset
    03:17
  • Sample Macro - Writing to months using Cells
    02:39
  • Formatting Ranges - Making you work look good
    03:53

  • Mini Project Workbooks
    00:02
  • Introduction to Mini Project
    00:54
  • Formatting the Cells
    03:42
  • Write the Totals
    02:16
  • Make it flexible with Offset
    04:17

  • What is Debugging
    01:01
  • Stepping through code
    02:17
  • Using Breakpoints
    02:29
  • The Locals Window
    02:53
  • The Watch Window
    03:30
  • More on the Watch Window
    02:11

  • Using Conditions
    04:54
  • The If Statement
    02:41
  • If Statement with ElseIf
    03:07
  • The Select Statement
    02:35
  • More with the Select Statement
    03:49

  • Introduction to Loops
    02:06
  • The For Loop
    04:07
  • More on the For Loop
    04:51
  • The For Each Loop
    03:42
  • The Do Loop
    04:21
  • Using Do Loop with Until
    03:12
  • Using Do Loop with While
    02:27
  • While and Wend
    00:57
  • Summary of Loops
    01:55

  • Syntax Errors
    04:28
  • Compiler Errors
    04:17
  • Runtime Errors
    02:02
  • Preview3 pages

Instructor

Paul Kelly
Udemy Instructor, Professional Software Developer
Paul Kelly
  • 4.5 Instructor Rating
  • 1,138 Reviews
  • 7,123 Students
  • 1 Course

Paul Kelly has written over a million lines of code in his 20 year software development career. He has worked for the largest insurance company in the UK, was a senior software consultant for one of the biggest Car Rental Companies in the world and has built card processing systems for a number of leading financial institutions.

In recent years a great deal of his work has been building advanced Excel applications and training Excel users to get the most from Excel Macros in very competitive environments.
Paul has built a number of VBA tools including an automated code generator, a formula version tracker, broken link identifier, module version control and many more.

When not writing code he likes to travel around South America, try his luck at Poker and follow he favourite team in the ancient Gaelic sport of hurling.

  • 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.