Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel Macros - a friendly and effective quickstart in VBA

Name: Excel Macros - a friendly and effective quickstart in VBA
Rating: 4.5 (48 reviews)

Enter the magical world of the Excel VBA automation. Start to create Excel macros and save time from the first lesson

Created byValentin Ilicea

Last updated 4/2020

English

What you'll learn

Become confident using Excel macros for your daily work in 2.5 hours, with crystal clear, HD video tutorials
Acquire a new skill for a lifetime with the 7 steps formula for learning Excel macros for beginners
Upgrade your personal brand at work by building even more trust with error-free Excel macros
Learn Excel VBA code from scratch, including LOOPS, IF statements, InputBox and MsgBox with a friendly, step-by-step, practical guide
Automate your work without programming / writing lines of code, using recorded macros (section 1)
Get LIFETIME access to all course materials: Excel files, real-world cases, quizzes, homework exercises, PDF ebook, and 1-on-1 instructor support
Test your skills with homework and quizzes

Course content

5 sections • 34 lectures • 2h 45m total length

Warm welcome from the instructor1:58
Learn a practical, friendly quickstart to Excel macros in VBA as you record, edit, and debug macros through hands-on exercises and real-world cases.
Demos: what you will be able to do upon completing this course4:20
See how Excel macros automate formatting and data quality with one-click workflows. Move daily extracts to history, fix text and date issues, and export PDFs or compare files.
Course design and structure4:28
Guide learners from recording macros to writing VBA code, mastering variables, objects, and methods, loops, and if statements, with interactive macros using msgbox and inputbox.
How to make the most out of this course2:05
Download here upfront all the course resources0:24

Let's jump in: record - save - run an Excel macro. See and twist the VBA code11:59
Record macros to automate formatting, autofit, and filtering for a one-click workflow saved to the personal macro workbook. Edit VBA code to widen ranges and reuse in files, with backups.
Record macros - quiz
Boost your Macros skills by understanding the code in a practical way - F8 trick9:54
Learn to step through VBA macros line by line with the F8 trick in the Visual Basic Editor, set breakpoints, and run or stop the macro to see live changes.
Understand the code - quiz
Run a macro in one click: create a button on the Quick Access and in the file5:57
Discover how to run a macro with one click by adding a button to the quick access toolbar or in the worksheet, then assign the macro and test it.
Button to run a macro - quiz
I got an error! -->what to do and how to debug the VBA code3:09
use the debug option to locate where a vba macro fails, inspect the highlighted line for typos, fix it, and re-run to verify the macro runs correctly.
Debug - quiz
Reach the next level on recorded Excel Macros by using the relative reference7:03
Learn to elevate recorded Excel macros by using relative references for flexible cell selection, contrasting absolute vs relative, and applying offset to adapt to the active cell.
Relative reference
Excel Macros Real world case - how to use the relative vs absolute reference4:17
Record and run a macro to copy daily data into a historical master sheet, using absolute and relative references to ensure flexible, one-click updates.
5 keys in working with macros0:59
5 mistakes in working with macros2:11
Real world case: 1 click-resolution for data as text instead of number or date5:39
Demonstrate a one-click resolution to convert numbers stored as text and misread dates using text to columns, with a recorded macro in VBA.
Real world case: protect your data in one click3:30
Learn how to protect formulas with a one-click macro in Excel, record a macro in a personal macro workbook, and quickly toggle protection to edit formulas.
Practical Inventory template for consistent Time savings with Recorded macros4:20
Use a practical inventory template to decide which tasks to automate with recorded macros, based on frequency and time spent, listing reports and safe operations like formatting and data validation.
Blue Module challenge0:39
Challenge - solution tutorial1:04
Tackle practical Excel macros with a friendly solution tutorial, offering a quickstart in VBA to solve common challenges and implement macros efficiently.
Main Excel Macro Shortcuts in a glance - recap0:09

Let's jump in: write your first Excel macro from scratch4:51
Create a module named with underscores for your first Excel macro. Write a simple sub, run with F5, and display a message box, using comments and indentation.
We will explore 3 VBA Concepts: properties and methods, objects and variables0:44
Explore three VBA concepts—properties and methods, objects and variables—to build a solid foundation for writing macros, with practical quizzes to practice along the way.
Object Methods and Properties. Select, copy, paste. 4 operations in one VBA line9:02
Explore VBA properties and methods on the range object, using dot notation to set values and perform select, copy, and paste in one line with a destination like D1.
Methods and properties
Objects in VBA - how to declare and initialize objects with Dim keyword9:01
Learn to work with VBA objects from range and cells to columns, rows, sheets, and workbooks, declare and initialize them with Dim, and perform basic data filling and copying.
Objects
List of useful objects in VBA for beginners
How to declare variables in VBA. Types of variables. Write VBA code exercise8:35
Declare and initialize VBA variables with Dim, assign values from cells or input boxes, and display a concatenated message with index, name, and salary.
Variables in VBA
How to use FOR loops and IF THEN ELSE statements in Excel VBA9:41
Explore using for loops and if-then-else statements in Excel VBA to automate calculating the gross profit margin ratio in column D, handling zero divisions and looping through rows.
Minitool to compare two files in 1 click - VBA For loop w Row and End properties9:13
Build a one-click VBA for loop tool to compare two files, highlight differences in yellow, and auto-detect the last row using end down and row properties.
VBA InputBox - how to get an user value and assign it to variable with examples7:00
Use a vba inputbox to get the last row and assign it to j, even with missing values. Validate with isNumeric and exit sub if invalid; declare j as variant.
How to safely delete rows based on a condition - using DO WHILE LOOP in VBA9:08
Learn to safely delete rows based on a condition in VBA using a do while loop, filtering missing dates and a selected month via an input box.
Green module challenge0:20
Final Quiz

Compare two Excel files in one click - TOOL ready to use7:26
Use a ready-to-use VBA tool to compare two Excel files with multiple entries in one click, highlighting header differences and data mismatches, and clear formatting afterward.
Save time with this VBA code - 10 frequent operations in one click - sample file7:01
Automate your Excel workflow by mastering ten frequent tasks in VBA, including vlookup, filtering, deleting rows, converting text to numbers, and copying values as needed across multiple tabs.
Create PDF files in one click and save days of extra work. Ready to use macro7:47
Learn to create supplier-specific pdf summaries from excel data in one click by using a pivot table with filters and a ready-to-use macro that exports all sheets to pdf.

Requirements

Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows) - I use Excel 2019

Description

Over the past nine years, I’ve discovered just how POWERFUL Excel Macros can be.

As my Excel VBA knowledge grew, I started to get better tasks and projects from my management, resulting in high visibility to senior stakeholders, job level promotion and upgraded personal brand at work.

My income grew as well very soon: 3 months after I first started to use Excel VBA to automate my work, I was awarded my very first significant bonus in my career.

The hours I was able to save by replacing manual Excel work with automated Excel Macros made me feel more energized and I could enjoy my free time more than ever.

So in this course I’m going to share my exact learning strategy with you, by giving you the MOST critical ingredient: a simple formula to learn Excel Macros for beginners from scratch in 7 steps.

Get started with recorded macros
Learn how to edit recorded macros
Create your own VBA code from scratch
Learn about the 3 fundamental concepts in Excel VBA: variables, objects and methods & properties
Put the LOOP structures to work
Take decisions with IF statements
Create interactive Excel Macros with MsgBox and InputBox

This is the simplest path to learn Excel Macros from zero, for beginners, and trust me, it works.

Listen to what others say about the course

I took this course not only because of how useful it was for me at work but also to improve my over all Excel skills and all I can say is - BRILLIANT! The course pace was just right, everything well explained and perfectly structured. I really appreciate the real world cases and the practical approach Mr. Ilicea provided. The Training Materials were a great addition and well prepared which were a great help in the learning by doing process. Looking forward for your next course. Cheers!!

-- Florian

Enjoyed the style! This class is very well constructed with quizzes, real world cases and practical homework. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!

-- Nadia

Start to see value from the first minute of the training

This course is only about relevant, powerful and effective tools that Excel Professionals use on a regular basis in Excel to work faster and boost productivity while meeting the data quality requirements.

I concentrated 10 years of daily work in Excel and more than 1 year of course preparation to select for you the most effective Excel Macros, VBA code, real-world cases and exercises. As a result, right after the first video demo, you will be already in the position of using this knowledge in your daily work and it will already start to save you time. This is an effective start to learn Excel macros for beginners.

By the end of this course, you will be confidently recording, editing and especially creating from scratch basic and effective Excel macros. If you are like me, you will love your increased productivity and amazing data quality results obtained with the VBA code.

As a result, you will become much more competitive at work.

Learn By Doing

The course is hugely interactive with real-world cases, Excel exercises & actionable homework built into every section.

Follow the steps on screen, practice to learn fast, create your own Macros and Excel VBA code and get immediate results at work.

Concise, straight-to-the-point course

You see, the majority of the VBA classes out there are ranging from 7 to 22 hours long - not everybody has the time or the technical skills to follow along.

This is why this VBA course for beginners is so unique: it's time to get practical and see results after the first lesson.

All the strategies, tips and tools recommended are very time effective.

You'll Also Get:

✔ Downloadable Excel macro and regular workbooks - the macros in the VB Editor will always be there for you as a guide, but you will have macro-free files to practice as well

✔ Lifetime Access to course updates

✔ Fast & Friendly Support in the Q&A section

✔ Udemy Certificate of Completion Ready for Download

Don't Miss Out!

Every second you wait is costing you valuable time, increased complexity and frustration.

There are 750 million users of Microsoft Excel today and more than 4 million are improving their Excel skills only on Udemy. Be a top Excel user by learning the most valuable Excel skill: Excel Macros and Excel VBA.

This VBA course comes with a 30 day money-back guarantee - so there's no risk to get started.

Go ahead and hit the "Take this course" button to start working faster with Excel today!

See you there!

-Valentin (Founder of VeryFastExcel)

Who this course is for:

ANYONE who wants to learn to work faster and smarter in Excel
Working professionals who are looking for solutions to become more competitive at work
ANYONE who takes pride in his/her PRODUCTIVITY
This course is NOT suited for experienced & advanced Macro users

Excel Macros - a friendly and effective quickstart in VBA

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 13min

Enter the magical world of VBA with recorded Macros - BLUE section14 lectures • 1hr 1min

Writing VBA code - friendly guide. GREEN section11 lectures • 1hr 8min

Real world applications for major time savings - RED section3 lectures • 22min

Conclusion and next steps1 lecture • 1min

Requirements

Description

Who this course is for: