Excel Macros - a friendly and effective quickstart in VBA

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

4.30 (48 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel Macros - a friendly and effective quickstart in VBA
168
students
3 hours
content
Apr 2020
last update
$19.99
regular price

What you will 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

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.

  1. Get started with recorded macros

  2. Learn how to edit recorded macros

  3. Create your own VBA code from scratch

  4. Learn about the 3 fundamental concepts in Excel VBA: variables, objects and methods & properties

  5. Put the LOOP structures to work

  6. Take decisions with IF statements

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

Content

Introduction

Warm welcome from the instructor
Demos: what you will be able to do upon completing this course
Course design and structure
How to make the most out of this course
Download here upfront all the course resources

Enter the magical world of VBA with recorded Macros - BLUE section

Let's jump in: record - save - run an Excel macro. See and twist the VBA code
Record macros - quiz
Boost your Macros skills by understanding the code in a practical way - F8 trick
Understand the code - quiz
Run a macro in one click: create a button on the Quick Access and in the file
Button to run a macro - quiz
I got an error! -->what to do and how to debug the VBA code
Debug - quiz
Reach the next level on recorded Excel Macros by using the relative reference
Relative reference
Excel Macros Real world case - how to use the relative vs absolute reference
5 keys in working with macros
5 mistakes in working with macros
Real world case: 1 click-resolution for data as text instead of number or date
Real world case: protect your data in one click
Practical Inventory template for consistent Time savings with Recorded macros
Blue Module challenge
Challenge - solution tutorial
Main Excel Macro Shortcuts in a glance - recap

Writing VBA code - friendly guide. GREEN section

Let's jump in: write your first Excel macro from scratch
We will explore 3 VBA Concepts: properties and methods, objects and variables
Object Methods and Properties. Select, copy, paste. 4 operations in one VBA line
Methods and properties
Objects in VBA - how to declare and initialize objects with Dim keyword
Objects
List of useful objects in VBA for beginners
How to declare variables in VBA. Types of variables. Write VBA code exercise
Variables in VBA
How to use FOR loops and IF THEN ELSE statements in Excel VBA
Minitool to compare two files in 1 click - VBA For loop w Row and End properties
VBA InputBox - how to get an user value and assign it to variable with examples
How to safely delete rows based on a condition - using DO WHILE LOOP in VBA
Green module challenge
Final Quiz

Real world applications for major time savings - RED section

Compare two Excel files in one click - TOOL ready to use
Save time with this VBA code - 10 frequent operations in one click - sample file
Create PDF files in one click and save days of extra work. Ready to use macro

Conclusion and next steps

Bonus lecture

Reviews

Boxy
August 25, 2020
The instructor is excellent and explanation is outstanding. I liked the last part of this module. Can we create a VB code to make Pivot field formating, if yes please explain.
Andrei
February 6, 2020
You can multi-task while taking an online course yet with this one I was all eyes and ears into what Valentin had to say. Obviously, at the beginning you might find yourself a bit reluctant yet as minutes and hours passed, the chemistry found its course. Thank you Udemy and Valentin for being the best facilitating platform and guide for me to improve my Excel skills and earn real-life changing abilities that makes my day to day office work much better. Kudos!
Neilya
January 25, 2020
Lectures are interesting, useful for general development; the instructor explains everything availably! Thank you so much!:)
Tiberiu
December 22, 2019
This course is worth the money if you are interested to develop your xls skils, or if you need it in your daily job. I am not a fan of xls, but I need to work with it and this help me. There is a lot of preparation and work put into this material by the author. Looking forward to other new courses.
Johannes
December 19, 2019
Excellent course with a hugely informative input, connecting the theoretical and practical parts efficiently.
Robert
December 16, 2019
The course was very easy to learn and was very friendly manner. It was good learning which i would practice in my work.
Maxim
November 26, 2019
The best way of learning is by practicing and this course offers the necessary support to help you achieve your goals, being more productive at work and great start into VBA world.
Andra
November 26, 2019
The course brings an innovative point of view, all explained very clearly, with relevant examples. The instructor describes everything so well. It is truly helpful and I am grateful for having enrolled.
Veronica
November 15, 2019
This course is really helping me to carry out daily activities on the job in a significantly faster way. I definitely recommend! The explanations are very clear
Florian
November 15, 2019
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!!
Nadia
November 15, 2019
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!

Charts

Price

Excel Macros - a friendly and effective quickstart in VBA - Price chart

Rating

Excel Macros - a friendly and effective quickstart in VBA - Ratings chart

Enrollment distribution

Excel Macros - a friendly and effective quickstart in VBA - Distribution chart
2592866
udemy ID
10/5/2019
course created date
11/13/2019
course indexed date
Bot
course submited by