Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Neuroscience Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel Macros

Excel Macros & Excel VBA Programming for Beginners

Become a proficient Excel Macros and Excel VBA Programmer in very short time. Excel 2019 Macros & VBA Examples included.
Highest Rated
Rating: 4.5 out of 54.5 (765 ratings)
2,906 students
Created by Andreas Exadaktylos
Last updated 11/2020
English
English, Polish [Auto]
30-Day Money-Back Guarantee

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 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 16 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

Requirements

  • 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

Description

COMPLETELY REDONE ON SEPTEMBER 2020 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. Other spending 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 aspect 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, 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 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 them 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 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 which are fully explained and easy to understand. It has been recorder with the brand new Excel 2019 in full HD 1080p. If you get stacked don’t worry. I have fast and fully 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

Course content

9 sections • 67 lectures • 4h 18m total length

  • Preview03:29
  • Preview02:55
  • Preview05:09

  • Preview08:43
  • Ways of Recording a Macro
    04:29
  • Ways of Running a Macro
    06:09
  • Assign a Macro to Ribbon Icons and Create your Ribbon
    03:47
  • Relative OR Absolute Method?
    04:13
  • Rules regarding Naming Macros
    03:03
  • Quiz 1: The Basics of Macros
    4 questions
  • EXERCISE: Record a Macro
    01:16
  • Summary
    01:00

  • Macro Recorder vs VBA
    03:26
  • Preview03:47
  • The VBA Environment
    04:29
  • VBA Editor Basics
    02:11
  • VBA Modules and Editor Tab Tips
    05:49
  • Excel VBA Object Model
    05:47
  • Dealing with VBA Errors
    01:01
  • Using VBA's Help System
    03:22
  • Quiz 2: Enter the world of VBA
    3 questions
  • Summary
    02:09

  • Preview01:39
  • Make a macro available all the time
    02:53
  • Organizing your Personal Macro Workbook
    01:30
  • Watch An Excel Macro Write Your VBA Code
    02:17
  • Project #1: Use navigation buttons to change Chart Type
    03:11
  • Quiz 3: Get in-depth with Macros
    3 questions
  • Summary
    00:36

  • How to Create your First Piece of Code
    03:35
  • How VBA "speaks"
    06:29
  • Workbook, Worksheet and Range
    02:32
  • Object Properties and Methods
    09:03
  • Sub Procedures
    02:44
  • Sub Procedure Examples
    03:27
  • Functions Procedures
    03:28
  • Function Procedure Examples
    03:21
  • Quiz 4: How to create your First Piece of Code
    4 questions
  • Summary
    00:47

  • Variables
    05:59
  • Constants
    03:24
  • Strings and Dates
    03:24
  • Range and Cells properties
    02:07
  • Assignment Statements
    03:30
  • Arrays
    03:59
  • Range Property
    05:14
  • Cells Property
    05:10
  • Offset Property
    04:05
  • Useful Range Object Properties
    07:37
  • Useful Range Object Methods
    04:09
  • Summary
    04:13

  • With …End With Constructs
    02:16
  • EXAMPLE: How to read from a cell
    01:12
  • Dim and Set statements
    02:25
  • Using IF..ELSE Statements with Macros
    05:17
  • Using Relative or Absolute Reference
    03:06
  • Using FOR…NEXT Statements with Macros
    05:40
  • Using DO…UNTIL Statements with Macros
    02:09
  • Project #2: Add a confirmation dialog box with VBA IF statements
    08:31
  • Project #3: Prompting a user to select a worksheet and run a macro
    02:12
  • Combining Macro Recording and VBA Statements
    05:54
  • How to join 2 different Macros
    01:37
  • Tips for running your Macros fast
    01:53
  • Project #4: Transfer Data From one Excel Worksheet to another
    08:27
  • Quiz 5: Supercharge Macros and VBA with Loops
    3 questions
  • Summary
    01:05

  • Project #5: How to Create Notifications-Reminders using VBA Code
    03:49
  • How to create an Excel Animated Chart using VBA Code
    08:28
  • Saving a Workbook before Closing
    02:33
  • Closing All Workbooks at Once
    01:09

  • Excel 2019 Tutorial for Beginners
    13:36
  • Amazing discount for my other courses!
    00:49

Instructor

Andreas Exadaktylos
Best Selling Teacher | Msc Computer Scientist
Andreas Exadaktylos
  • 4.6 Instructor Rating
  • 5,666 Reviews
  • 25,295 Students
  • 7 Courses

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.

I have over 16 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 have a Master's Degree in Computer Science and a Degree in Electronic Engineering. 

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 17 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 and my two kids. Travel, forex trading, and reading books are my favorite hobbies. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.