Excel Macros Mastery & Excel VBA for Non-Programmers Premium class

Andreas Exadaktylos, Teacher | Expert Computer Scientist | Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
37 Videos (1h 36m)
    • Introduction

    • Let’s get started by answering the most common questions

    • Running a Macro using Buttons or Graphics

    • Macros and Security

    • Why macros are huge time savers See examples

    • Running a Macro using the Quick Access Toolbar

    • What are macros and how we can use them

    • Running a Macro using the Ribbon

    • Ways of Recording a Macro

    • Enter the world of Excel VBA

    • Dealing with VBA Errors

    • Macro Recorder vs VBA

    • The VBA Environment

    • VBA Editor Tips

    • Make a macro available all the time

    • The Anatomy of Macros

    • Case Study Use navigation buttons to change Chart Type

    • Organizing your Personal Macro Workbook

    • Recording your first Macro

    • Hello World!

    • How to read from a cell

    • WithEnd how this statement can save you time

    • Range and Cells properties

    • The core of VBA Workbook Worksheet and Range

    • Dim and Set statements

    • Variables

    • Using IF..ELSE Statements with Macros

    • Combining Macro Recording and VBA Statements

    • Case Study Prompting a user to select a worksheet and run a macro

    • Using DO UNTIL Statements with Macros

    • How to join 2 different Macros

    • Tips for running your Macros fast

    • Using Relative or Absolute Reference

    • Using FOR…NEXT Statements with Macros

    • Saving a Workbook before Closing

    • Closing All Workbooks at Once

    • My Final Thoughts Thank you


About This Class

Become a proficient Excel Macro Programmer in a very short time.

Excel Macros are 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 Class 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 Class 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 Class 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!
  • You will learn the most current version of Microsoft Excel (2016) but the concepts are compatible with Excel 2007, Excel 2010 and Excel 2013
  • Compatible with Microsoft Office for Macintosh

Are you looking to learn practical Macro 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 2016 in full HD 1080p. If you get stacked don’t worry. I have fast and fully support through the discussion board. 

What are you waiting for? Enroll now!

11 of 11 students recommendSee All

Learned a lot from this class! Great Instructor!
I knew nothing about Excel Macros & VBA and now I can easily make macros and write code. Thanks Andreas!
I had little experience with Macros and no experience with Visual Basic. This course is so well structured that I now create advanced Macros and write my own code. Well done Andreas!





Andreas Exadaktylos

Teacher | Expert Computer Scientist | Entrepreneur

LinkedIn: https://www.linkedin.com/in/andreasexadaktylos

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. 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 Masters 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 love to create websites and optimizing 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