About the Course

This course will arm you with years of knowledge and experience, condensed into an easy-to-follow format. Rather than spending months searching websites, trawling through videos and pouring over books, this program will turn you into someone who can create effective Excel VBA solutions.

Instructor(s)

  • Paul Kelly

    Paul Kelly

    Paul Kelly, a Microsoft MVP, cuts through the jargon to teach practical Excel VBA for real-world use. With a career spanning 30 years and a degree in Software Engineering, Paul has honed his skills in sectors like finance and automotive, earning a reputation among major firms. He's the force behind Excel Macro Mastery, a website and YouTube channel with a peak of a million yearly visitors and 80,000 subscribers, respectively. Paul excels in demystifying VBA with easy-to-grasp, actionable lessons backed by his extensive experience. His focus? Giving students the tools they need with code examples ready for real-life application.

Reviews: What Customers Have Said...

  • Really Useful Course

    Martyn Mathews

    I can't recommend Paul highly enough, his course is well structured and covers the real world usage of Excel VBA. He is also very good at communicating, any ...

    Read More

    I can't recommend Paul highly enough, his course is well structured and covers the real world usage of Excel VBA. He is also very good at communicating, any queries are answered,personally, and in a quick time frame. I am still working through the course but, so far, it's the best. Go for it!

    Read Less
  • This course is a game changer for me

    Sam Paterson

    I love all the knowledge about how to us VBA the "correct" way in this course. It's like every section I am learning something new and the light bulb comes o...

    Read More

    I love all the knowledge about how to us VBA the "correct" way in this course. It's like every section I am learning something new and the light bulb comes on. "Ahh, so that's how it is suppose to be done." I look forward to each and every lesson.

    Read Less
  • Many thanks to Paul for this outstanding course

    Lourdes del Campo

    I bought this course without hesitation the minute I learned about it, because I completely trust the instructor. The most valuable course you can get in VBA...

    Read More

    I bought this course without hesitation the minute I learned about it, because I completely trust the instructor. The most valuable course you can get in VBA (as well as on any other subject matter) is the one that is informed by true knowledge, that is to say the one that provides insights into the subject matter, there are tones of online courses in VBA, full of information, but scarce knowledge. All that is required now is that I do my part in learning and so far I am enjoying it so much I think it will be an easier load than I anticipated. Many, many thanks to Paul for this outstanding course

    Read Less

Course curriculum

  • 1
    Welcome to the course!
    • How to use this course
    • A message from Paul Kelly
    • Before we begin...
  • 2
    Getting Started with Excel VBA
    • Glossary
    • Shortcut keys
    • The Visual Basic editor
    • Activity 1 (Getting Started)
    • Understanding the Visual Basic editor windows
    • How to create a sub
    • Activity 2 (Getting Started)
    • How to write values to spreadsheet cells
    • Activity 3 (Getting Started)
    • Important note about downloading Excel workbooks
  • 3
    Accessing Worksheets
    • Notes on using OneDrive
    • How to select the correct worksheet
    • Activity 1 (Accessing Worksheets)
    • Accessing sheets in other workbooks
    • Opening a workbook for reading
    • Activity 2 (Accessing Worksheets)
    • Opening a workbook for writing
    • Activity 3 (Accessing Worksheets)
    • Troubleshooting worksheets
    • Activity 4 (Accessing Worksheets)
    • Quick Guide: How to select the worksheet
  • 4
    Dealing With Multiple Workbooks
    • Introduction
    • Retrieving multiple files from a folder
    • Activity 1 (Multiple Workbooks)
    • Using the Windows Open Dialog to select files
    • Activity 2 (Multiple Workbooks)
  • 5
    Project 1 - Basic Data Manipulation
    • How to read data records
    • Activity 1 (Project 1)
    • Using CurrentRegion to select the range
    • Activity 2 (Project 1)
    • Understanding the For Loop
    • Activity 3 (Project 1)
    • Understanding the For Each Loop
    • Using the If Statement to make decisions
    • How to write data records
    • Activity 4 (Project 1)
  • 6
    Techniques for Clean Code
    • Using the With Statement
    • Activity 1 (Clean Code)
    • Indenting the code
    • Activity 2 (Clean Code)
  • 7
    How to Use Variables Correctly
    • Basic variables
    • How to declare variables
    • Activity 1 (Variables)
    • Assigning variable values
    • Activity 2 (Variables)
    • Variable scope - the variable lifetime
    • Activity 3 (Variables)
    • How to use object variables
    • The Object Model Hierarchy
  • 8
    Project 2 - How To Design Your Code
    • Project requirements
    • Activity 1 (Project 2)
    • Basic solution to the project
    • Enums - how to make your code readable
    • How to design your project
    • Using Subs and Functions to organize your code
    • Collections - A simple data structure
    • Putting it all together - the final code
    • Activity 2 (Project 2)
  • 9
    Arrays: Practical Strategies for Effective Use
    • Why we need arrays
    • Getting started with arrays
    • Activity 1 (Arrays)
    • Practical uses of 1D Arrays 
    • Activity 2 (Arrays)
    • Replacing Ranges with 2D Arrays
    • Optimizing 2D Array Code
    • Activity 3 (Arrays)
    • Copying arrays - important considerations
  • 10
    Real-World Data Manipulation Scenarios
    • Quick Guide to Main Data Manipulation Scenarios
    • Scenario 1: Filtering and copying
    • Activity 1 (Data Manipulation Scenarios)
    • Useful data structures: The Dictionary
    • Scenario 2A: Grouping data
    • Scenario 2B: Grouping with multiple fields
    • Activity 2 (Data Manipulation Scenarios)
    • Scenario 3: Joining data
    • Activity 3 (Data Manipulation Scenarios)
  • 11
    Powerful Data Manipulation Tools
    • Introduction to Advanced Filter
    • Advanced Filter
    • Scenario 1 using Advanced Filter(Filter and Copy)
    • Activity 1 (Powerful Tools)
    • Introduction to ADO
    • ActiveX Data Objects(ADO)
    • Scenario 1 to 3 using ADO(Filter/Group/Join)
    • Activity 2 (Powerful Tools)
  • 12
    Performance Optimization
    • A Note About This Section
    • Introduction to performance optimization
    • Optimization basics
    • Measuring performance
    • Activity 1 (Performance Optimization )
    • Performance Optimization Techniques
    • Optimization for Data Manipulation
    • Activity 2 (Performance Optimization )

FAQ

  • Is this a once-off payment or subscription based?

    A once-off payment. You will only pay for this course once. You will never be asked to pay again no matter how much new content is added.

  • What is the difference between this course and the Excel VBA Handbook Course?

    The Excel VBA Handbook teaches how to structure the code in an application and covers a lot of areas of Excel VBA. However, it doesn't go deep on topics like arrays etc. In this course, I get deep into topics like arrays, dictionaries and the various data manipulation techniques. From what I've seen, the majority of people are using Excel VBA to move data around in some capacity, and learning proper efficient methods is extremely beneficial to most Excel VBA users.

  • Can I use the code from this course in my own projects?

    Absolutely 100% Yes. You can use the code however you like - personal or commercial. You can alter it any way you like.

  • What if I get stuck?

    You can post a question in any course lesson. I answer these questions promptly.

  • How long do I have access to the material?

    Once you have enrolled, you have ongoing access. The course is self-paced and you may take as long as you need to complete it.

  • What if I don't like it?

    Then you can get a full refund within 15 days of purchase. No questions asked! Simply reply to your receipt email.

  • What format does the course come in?

    This is a video-based course. It also includes activities to boost your learning as well as supplementary text where applicable. It also includes working code examples that you can use in your projects.