Winners of the Excel Macros & VBA School Contest + a Preview of What’s Inside Excel Macros & VBA School

 In Excel Macros & VBA, Updates

Hi it’s Victor here. I’m almost ready to open the doors to Excel Macros & VBA School. Put this date in your calendar: Friday July 21, at 5pm London BST / 12 noon Eastern EDT / 9am Pacific PDT.
(Tip: You can check https://www.worldtimebuddy.com/ for your local time if you’re not in one of the above timezones)

In this update I’ve got some good stuff for you…

– I’ll announce the two lucky contest winners
– And I’ll show you a preview of what’s inside the upcoming course

But before we get into all that, I want to explain …

 

The Main Purpose of Excel Macros & VBA School

Most Excel users never get around to learning how to program Excel. They think they can get by without this skill. This can be a big mistake, especially if you frequently deal with routine and repetitive tasks that can be automated.

For instance it is very common for jobs that take a couple of hours (e.g. many steps of data import, cleansing and reporting) to be reduced to 5 minutes or less. Giving you more time to focus on higher order tasks that need a real human to do them well.

In Excel Macros & VBA School I want to teach you how to understand and use the programming language of VBA that’s built into Excel. So let me tell you a bit about …

 

What’s Inside Excel Macros & VBA School

At this point, I have completed 4 modules and have 6 modules in the pipeline. As a VIP Founding Member coming in now, you get immediate access to the first 4 modules and access to the later modules when they are ready. And of course you get lifetime access.

Let’s take a look at what you’ll learn in the first 4 modules:

Module 1 – Course Introduction

Learn how to make the most of this course (and any other course you take). I teach you important skills to make the learning process faster and help you remember longer. These skills will give you the edge.

Module 2 – Introduction to Macros and VBA

Really understand the difference between Macros and VBA. People tend to use these words interchangeably but they are not the same. I also show you practical ways to immediately use recorded macros without writing any code, and teach you about how to choose the right security settings so you can protect yourself from unknown (and potentially harmful) code.

Module 3 – Discover the VBA Editor

Did you know that the built-in VBA Editor gives you a lot of power? But only if you know your way around it. I demonstrate how you can customize and use the VBA Editor as the key tool in your programming toolkit. I will also teach you important habits so you can reduce programming headaches.

Module 4 – The Excel Object Model

I’ll walk you through the complex structure that is the Excel Object Model and demystify it for you. You will learn a simple analogy to understand what it all means. Once you have a grasp of how the Excel Object Model fits together, you can then explore different parts of the model without getting lost. I also demonstrate different ways of referencing things in Excel so you understand the tradeoffs and can make better choices in your own code.

Here are the remaining 6 modules that are in the pipeline:

Module 5 – Useful Workbook macros

Module 6 – Useful Worksheet macros

Module 7 – Working with Ranges

Module 8 – Important VBA concepts (variables and loops)

Module 9 – Ways to control program flow (decisions)

Module 10 – Becoming a VBA programmer

Note: As a VIP Founding Member you get access to modules 5 – 10 as soon as they are completed in the next few months.

And finally, let’s get around to …

Announcing the Winners of the Excel Macros & VBA School Contest

There were many great entries for the contest. I want to thank everyone who entered for the thought and effort you put in.

Here’s the list of entrants in alphabetical order: Alta Niemandt, Ashok Motwani, Daniel, Eric Pisaro-Grant, Ilyas Qasim, Jan Bolhuis, Janet Stead, Jeff, Kara, Kemi Thomson, Kristin, Michael Cipriotti, Mike Pouncey, Nector, Sai, Troy, Valerie M Harris, and Wendy.

Thank you for taking part!

Picking two winners was pretty difficult… After lots of reading and thinking, I decided on two winners early this morning.

If you have a couple of minutes, it would mean a lot to me if you could congratulate the winners in the comments section of this page.

I’ve copied the winning entries below for you to read.

 

Winning entry # 1 – Mike Pouncey

Hi Victor,

Simply put, I want to learn more about the capabilities of Excel and VBA because I’ve dabbled in recording macros and searching ready-made VBA to use in my work projects and I’ve been able to transform the way people think about data due to how I’ve been able to display it in a dashboard.

I had a fairly large data set and it used to take me about a month’s worth of man hours to search the data by hand (certain things about the data made it beyond the capability of standard excel functions), and once I spent the time (about two months) researching and building my VBA macro (of course, I didn’t understand most of what it said, I just used various things I found), I am now able to not only develop the same report I was before in less than a minute’s time, I also know that by using the VBA, it eliminates human error (once you fix your code) from my reports and I’m much more confident in them.

Likewise, I was able to present the data in a dashboard that made it extremely easy for Senior Leaders to visualize the data in a way that just can’t be realized with standard raw data.

I think learning Excel VBA is essential in today’s marketplace – regardless of your industry. I am now a recognized expert within my particular field due to the previously described dashboard I built with recorded macros & pieces of VBA stitched together.

If I were able to actually learn VBA in such a way that I could understand it – it would not only help me build several additional research tools I one day hope to make, but it would give the Leaders that I work for the capability to see information in a way that it currently not possible due to the constraints put on standard Office software. I know and understand the potential for Excel VBA and am excited to hear about your upcoming course.

I hope you are able to help me create VBA code that provides mouse-over effects, etc. that you can do in HTML, JS and others, but within Excel. If so, I could use it for an interactive map that could update tables on a dashboard based on what the user clicked in the interactive map/shapes. Not sure if this is possible or not, but if I could learn how to do that, it would be a tremendous help to me.

Thanks for taking the time to put together the course.

 

Winning entry # 2 – Nector

Hi Victor,

I work for an Organization that has more than 6,400 employees and I wanted to stand out from everyone else so, I self-taught myself Geographic Information System and most of Microsoft Office programs: Work, Power Point, Outlook, OneNote, Project, Publisher, Access and Excel.

Because of my self-taught skills, I was transferred to the main Headquarters to be part of the administrative staff for the CEOs of the organization.

Since being transferred I have created numerous Access databases and more than 100 Excel spread sheets that are now being utilized by all of the Departments within the Organization.

Because the Excel spread sheets are utilized by all of our departments, I taught myself basic Excel-VBA (not much) to minimize the time of collecting and processing our incoming and outgoing data. This new learned skill has WOWED all my Superiors and sent my spread sheets to a new level.

Macros have eliminated so much time and different processes for numerous departments that I was given a new title “Data Analyst and Operations Technology Specialist. I also receive numerous phone calls during the course of a work week from employees who need excel help or advice and I am constantly asked how and where I learned my skills.

I realize and like the power and effect of Excel -VBA/Macros but I need to have a better understand of the components, variables and arguments… I truly will love to unlock the true power of Excel and take my first VBA course with you, Victor.

 

Honorable Mention – Alta Niemandt

Finally I’d like to give an honorable mention to Alta who wrote a short poem about Macros and VBA as the contest entry. I hope this cheers you up like it did for me.

Who said learning Excel can’t be fun? 😊

My job is very tedious

Making my brain monotonous

Oh give me patience to endure

Until I find that magic cure

Where is it?

What is it?

How do I get it?

Come on, let’s find it?

Mirror, mirror on the wall

Give it to me when I call

The magic cure has it all

Giving major joy to all

Macro, macro, do your job

Vba, Vba, add your lot

Give us hours in the day

So we can all go out and play

Hmmmmmmm…….. MAGIC!!!!!!

Victor Chan
Victor has been using Excel intensively since 2002. He is a Chartered Accountant (Fellow of the ICAEW) and has an MEng in Manufacturing Engineering from the University of Cambridge. He is on a mission to help you learn Excel and VBA with practical video tutorials and awesome online courses.
Join over 9,000 subscribers

GET BETTER AT EXCEL

Recent Posts
Showing 8 comments
  • Victor Chan
    Reply

    I want to thank everyone who entered the contest: Alta Niemandt, Ashok Motwani, Daniel, Eric Pisaro-Grant, Ilyas Qasim, Jan Bolhuis, Janet Stead, Jeff, Kara, Kemi Thomson, Kristin, Michael Cipriotti, Mike Pouncey (winner), Nector (winner), Sai, Troy, Valerie M Harris, and Wendy.

    If you have a couple of minutes, it would mean a lot to me if you could congratulate the winners in the comments here. Thanks!

    P.S. If you want to read the other entries, you can do so at this page.

    • Mike
      Reply

      I’m excited!! Thanks for choosing me Victor. And thanks to everyone else for the nice comments. It’s going to be so great to actually learn and understand VBA – especially from Victor (really appreciate the videos you make).

  • Mary
    Reply

    Congratulations guys!!

    • Kemi Thomson
      Reply

      Congrats to the winners!!!

  • Brian
    Reply

    Well Done, you have Excelled!

  • Eric P-G
    Reply

    Congrats, Mike and Nestor — worthy winners, who will surely appreciate this knowledge-giving! Plus, thanks to Alta for the entertainment!! (Excel is fun!!!)

  • Jan
    Reply

    Hé Mike and Nestor, Congrats! With “101 Ready to use Excel macros” and “Excel 2010 Power Programming with VBA” in front of me, I can’t wait to become fellow students with you and all the other great guys and girls. Again congrats and enjoy VBA

  • Rich
    Reply

    Congratulations to Mike and Nector– your stories were inspirational. Alta– thanks for the creative response that made us smile!

Leave a Comment

Contact Us

Please send us an email and we'll get back to you, asap.

Not readable? Change text.