Excel Macros & Excel VBA Programming for Beginners

Focused View

Andreas Exadaktylos

9:03:15

178 View

1. Introduction

1. Introduction.mp4

03:29

2. Course Resources.mp4

01:18

3. Compatibility & Macros Security.mp4

04:06

4. Why a macro and not regular Excel.mp4

01:21

5. IMPORTANT Opening macro-enabled workbooks.html

6. For Mac users.html

Files.zip

2. The Basics of Macros

1. Introduction.mp4

01:08

2. How to Record a Macro.mp4

04:31

3. How to Run a Macro and Assign it to an Icon or a Button.mp4

06:20

4. Personal Macro Workbook.mp4

03:11

5. Watch An Excel Macro Write Your VBA Code.mp4

02:16

6. Rules regarding Naming Macros.html

7. Assignment 1.html

8. EXERCISE Record a Macro.html

9. The Basics of Macros.html

Files.zip

3. Get in-depth with Macros

1. Introduction.mp4

01:09

2. A Detailed Example of how we Record a Macro.mp4

08:46

3. Inserting a Data Entry Form into a Database Automatically.mp4

08:14

4. Clean the Format of a Data Table using Macros.mp4

13:50

5. Absolute vs. Relative Referencing during Macro Recording.mp4

10:58

6. (NEW 2024) Writing Effective Macros.mp4

04:44

7. DEMO Use Navigation Buttons to Change Chart Type.mp4

03:08

8. Get in-depth with Macros.html

Files.zip

4. Starting Excel VBA Programming

1. Introduction.mp4

03:32

2. A tour of the Developer Tab.mp4

04:03

3. Overview of procedures in VBA.mp4

06:06

4. Referring to Ranges.mp4

04:00

5. Different Ways to Refer to a Range in VBA.mp4

11:20

6. Dynamic Ranges (& Intro to Variables).mp4

11:16

7. Copying Data using VBA Code (& Intro to Objects).mp4

08:46

8. Copying Data to the Bottom of a Range.mp4

03:25

9. Finding Data with VBA.mp4

05:56

10. Replacing Data Quickly.mp4

04:40

11. Using Special Cells to Remove Blank Rows.mp4

06:27

12. Why use Option Explicit.mp4

03:51

13. How to troubleshoot when your code is not working properly.mp4

07:20

14. Excel VBA Indentation.html

15. Starting Excel VBA Programming.html

Files.zip

5. VBA Language Elements in Detail

1. Introduction.mp4

01:08

2. (NEW 2024) VBA Data Types.mp4

04:37

3. (NEW 2024) VBA Syntax and Expression Entry PART1.mp4

08:50

4. (NEW 2024) VBA Syntax and Expression Entry PART2.mp4

05:27

5. Sub Procedures.mp4

02:51

6. Sub Procedure Examples.mp4

03:27

7. Variables.mp4

05:59

8. (NEW 2024) Manage Variable Scope.mp4

04:10

9. (NEW 2024) Define Static Variables and Constants.mp4

06:13

10. (NEW 2024) Define object variables.mp4

03:53

11. Strings and Dates.mp4

03:24

12. Assignment Statements.mp4

03:30

13. Constants.mp4

03:24

14. Arrays.mp4

03:59

15. (NEW 2024) Activity Define variables, constants, and calculations.mp4

02:15

16. (NEW 2024) SOLUTION of Activity Define variables, constants, and calculations.mp4

03:25

17. PROJECT Using Relative or Absolute Reference.mp4

03:06

18. VBA Language Elements in Detail.html

Files.zip

6. Common Objects, Properties & Methods

1. Introduction to Objects, Properties, Methods, and Events.mp4

07:56

2. RANGE Property.mp4

05:14

3. CELLS Property.mp4

05:10

4. OFFSET Property.mp4

04:05

5. VALUE, TEXT, COUNT, COLUMN, ROWS & ADRRESS Properties.mp4

07:37

6. SELECT, CLEAR & DELETE Methods.mp4

04:09

7. Subroutine Examples - Part1.mp4

10:47

8. Subroutine Examples - Part2.mp4

09:15

9. Subroutine Examples - Part3.mp4

02:20

10. How to handle basic user error in your subroutines.mp4

04:09

11. Common Objects, Properties & Methods.html

Files.zip

7. Filtering and Sorting with VBA

1. Introduction.mp4

02:31

2. Sorting with VBA Part1.mp4

10:34

3. Sorting with VBA Part2.mp4

05:14

4. Sorting with VBA Part3.mp4

04:50

5. Filtering with VBA Part1.mp4

08:49

6. Filtering with VBA Part2.mp4

03:34

Files.zip

8. Using VBA and Worksheet Functions

1. Introduction.mp4

01:20

2. (NEW 2024) How to create a Function in VBA.mp4

06:31

3. How to make your own user-defined (UDF) function (Custom Functions).mp4

04:37

4. How to convert a user-defined function to an Excel Add-In.mp4

02:53

5. Custom Function Examples.mp4

03:21

6. How to borrow functions from Excel.mp4

18:38

7. Message Box and Built-In Functions EXAMPLES.mp4

04:25

8. Using Worksheet Functions in VBA.mp4

06:25

9. Using VBA and Worksheet Functions.html

Files.zip

9. IF and FOR Looping Statements

1. Introduction.mp4

00:49

2. The If-Then Structure.mp4

11:14

3. For-Next loops.mp4

04:08

4. Applications of Looping Methodologies - Part1.mp4

06:51

5. Applications of Looping Methodologies - Part2.mp4

10:03

6. Applications of Looping Methodologies - Part3.mp4

05:53

7. Iterating through a Selection vs. a Range.mp4

14:38

8. Using the For Each... Next statement.mp4

14:15

9. DEMO Using IF..ELSE Statements with Macros.mp4

05:17

10. DEMO Using FORNEXT Statements with Macros.mp4

05:40

11. IF and FOR Looping Statements.html

Files.zip

10. Variable iteration loops

1. Do...Loops.mp4

09:21

2. Validating user input using a Do...Loop.mp4

05:32

3. Creating a guessing game using a Do...Loop.mp4

05:15

4. Do-While loop and Do-Until loop.html

5. The GoTo Statement.mp4

03:36

6. Combining Macro Recording and VBA Statements.mp4

05:54

7. How to join 2 different Macros.mp4

01:37

8. Variable iteration loops.html

Files.zip

11. VBA Projects & Ready-to-use MACROS

1. PROJECT Transfer Data From one Excel Worksheet to another.mp4

08:27

2. PROJECT Create an Interactive Map using VBA & Macros.mp4

11:14

3. PROJECT Add a confirmation dialog box with VBA IF statements.mp4

08:31

4. PROJECT Prompting a user to select a worksheet and run a macro.mp4

02:12

5. PROJECT How to Create Notifications-Reminders using VBA Code.mp4

03:49

6. PROJECT How to create an Excel Animated Chart using VBA Code.mp4

08:28

7. PROJECT Saving a Workbook before Closing.mp4

02:33

8. PROJECT Closing All Workbooks at Once.mp4

01:09

Files.zip

12. BONUS SECTION

1. SPECIAL BONUS Discover Exciting Offers!.html

2. Excel 2019 Tutorial for Beginners.mp4

13:36

Description

Become a proficient Excel Macros and Excel VBA Programmer in very short time. 2024 UPDATED

What You'll Learn?

Create and Modify Macros in Excel
Understand VBA and create your first piece of code
The course is full of code examples that you can use straight away
Become a proficient Excel Macro and VBA Programmer in a very short time
Know the difference between Macros and VBA
Choose the right Loop for each task
Learn Automation secrets in Excel VBA
Follow along with included Excel project files
Learn from an instructor with over 24 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
Learn the most current version of Microsoft Excel
Course updated regularly
An instructor ready to answer your questions in less than 24 hours
Watch high-quality video lectures with lifetime access
Quizzes and exercises
Certificate of completion

Who is this for?

All Excel users who have always been interested in macros but have never found a good resource to learn them

Individuals who wish to turn Microsoft Excel into a powerful tool in their daily work

Students with willingness for learning

Business Professionals and Entrepreneurs

What You Need to Know?

Only basic prior experience in Microsoft Excel or spreadsheets is required to get the most out of this Excel course.

Break your tasks down into small parts. The more you practice the better you become

This course was recorded with Excel 2016 but it's also compatible with Excel 2007, 2010 and 2013

It is also compatible with Microsoft Office for Mac

More details

Description
COMPLETELY REDONE ON JANUARY 2024 WITH NEW VIDEOS!

Become a proficient Excel Macros & VBA Programmer in a very short time.
Excel VBA is powerful. Everybody wants to learn Excel Macros and VBA. They can make Excel work like magic. But most Excel users never use them. Others spend several days on a multi-hour course or working through a 1000-page book, getting overwhelmed with information. So why waste a great deal of time learning things you may never use?
In this course, my goal is to help you learn ways to create Excel Macros that wonâ€™t burst your brain. Also to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training.

Content and overview
A macro is a sequence of instructions that automates some aspects of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, which is a programming language developed by Microsoft.
If you think Excel VBA programmers are smarter or more gifted than you, then youâ€™re mistaken. Yes, macros can be intimidating, and yes, programming is a huge topic. If you saw a course on Excel programming with hundreds of lectures, would you really watch all of them?
But wait a minuteâ€¦
What about people who may not have a programming background but aspire to reap the utmost from the program? Are there any programming principles and well-guarded secrets that you can learn and use to create any Macros you want?

In this course, you will find several short, to-the-point lectures covering Excel Macros and VBA entertaining and accessible to non-techies. The goal is not to make you a star Excel programmer. If you want to be that, go for it! But Iâ€™ll give you some best practices and make this course extremely practical. After all, you are not a programmer, you just need to write an Excel Macro to help you get your work done.

Why is this course different?
It's super practical. Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.
It's comprehensive and fast. Microsoft Excel Macros and VBA are complex, that's why the course is broken down into bite-sized pieces
I update the Excel class monthly with new lectures!
It has a Homework-Quiz after the section so to prove that you have learned the material.
You will learn the most current version of Microsoft Excel (2019), but the concepts are compatible with Excel 2007, Excel 2010, Excel 2013, and Excel 2016
Compatible with Microsoft Office for Macintosh

Are you looking to learn practical Macro and VBA techniques you can put to use instantly? If so, then this is the course for you. Itâ€™s entirely project-based and itâ€™s full of examples that are fully explained and easy to understand. It has been recorded with the brand new Excel 2019 in full HD 1080p. If you get stacked donâ€™t worry. I have fast and full support through the discussion board. And if you donâ€™t like the course simply return it. There is a 30-day money back guarantee. At the end of this Microsoft Excel class you will be given a Certificate of Completion
What are you waiting for? Enroll now! (it is 100% no risk deal)
Who this course is for:
All Excel users who have always been interested in macros but have never found a good resource to learn them
Individuals who wish to turn Microsoft Excel into a powerful tool in their daily work
Students with willingness for learning
Business Professionals and Entrepreneurs

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can.I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. I have over 20 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school. I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well. I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 20 years. I am a professional Forex Trader for over 5 years. I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife. I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.