Your Excel VBA Automation Machine

What you'll learn

Create macros, or programs to automate mundane and repetitive tasks in your job
Get started with some of the key building blocks and tools
Create custom user forms to capture and record data entry effectively
Create bespoke applications & tools to improve business processes
Prepare & structure your data correctly so that it can be easily enriched & analysed
Make your workflow simpler and more efficient with Excel
Put your knowledge on test with quiz and challenges

Requirements

Microsoft Excel 2007 - 2019 or Office 365 (Some features may not be available in earlier versions)

Description

Welcome to Your Excel VBA Automation Machine, a powerful course to fast track your knowledge of macros and automation in Excel.

I'm guessing you're perhaps a intermediate or advanced Excel user, looking to improve your Excel skills, to further your career, to become better & faster at Excel, or to impress your boss.

VBA code can seem intimidating and technical, it's a whole new programming language to learn - not dissimilar to learning to speak a foreign language. There's lots of new menus, commands and methods to learn.

The good news is, you don't need to know every VBA command to automate most business tasks. I've been consulting & teaching Excel & data analytics in the UK financial services industry for over 15 years, and have curated an approach to VBA that will enable you to perform 99% of any automation challenge that you're ever likely to come across in your career.

At the end of this course, you'll be confident and proficient about automating tasks and creating calculators and tools in Excel using macros and VBA

This course works through different elements of VBA, one at a time. Each lesson has a practical, real life example that we work through, and that you can download afterwards.

There are downloadable challenges that you can work through in your own time, and there's a quiz at the end of the course to test your knowledge.

You also get access to my private facebook community, where you can ask me any Excel question and get a personal answer (worth far in excess of the price of this course!)

There's several free preview lessons below, so that you can get started, and I look forward to seeing you on the course!

Who is the target audience?

Your Excel VBA Automation Machine is course for intermediate to advanced level Excel users who are familiar with the basics of Excel features.