The Secret to Mastering Excel VBA

Discover how professional programmers code in Excel VBA

Become the #1 expert your friends & colleagues call for advice

GET THE COURSE NOW

You thought you know what you can do with Excel...

You already know Excel is a powerful spreadsheet program. If you're a bit more advanced, you know you can automate simple activities with Macros.

Let me tell you this: regardless of your level in Excel, you can do things with Excel you have never thought possible or even imagined!

Here's a secret: what differentiates an Excel Macro User from an Excel VBA Programmer?

An Excel Macro User extends Excel with automation.

An Excel VBA Programmer extends a VBA computer program to use Excel.

Approaching a task from a programmer's perspective can have a HUGE impact

 

 

Choosing the right data structure and programming technique in this exercise, resulted in a performance increase of 52 seconds to a fraction of a second.
This is but one simple example...

I'm excited to invite you to take the first course in my program: Computer Programming with Excel VBA

Look what can happen to you after having completed this course

  • You will be Competitive: deliver Excel-based solutions in half the time and cost compared with other technologies
  • You will stand Out: very few professional VBA programmers out there. Join this elite group of professionals
  • You will become a Valued Expert: in your company, you will become the best Excel expert people turn to for advise
  • You will discover an attractive opportunity: requires a small investment in learning with vast potential opportunities
  • You will easily sell your services: Excel is readily available on almost every computer. No hassle or special installations are required

In this course you will discover...

 

  How to create slick PDF reports with a click of a button!

 

With Excel VBA you can create a slick PDF report, with beautiful Excel charts and data, and even automatically send it as an attachment by email.
 
This is a PDF training certificate you will create in this course!

 

  How to Design Business Tools over Real Business Data!

With Excel VBA you can access data produced by another application and dynamically query and manipulate the data by a simple change of a selector filter.
This is a Purchase Order Enquiry tool over data produced from an ERP system you will create in this course!

  Program effectively based on true understanding of how computer programs work!

Computer programs have structure, flow, data resources and much more - only when truly understanding how they work you can design and deliver a performant, scalable computer program.
Understand how computer memory stores data for choosing the right data structure for the job!

  Manipulate any element of the Excel Application!

By understanding the structure of the Excel Object Model and methods to access all of its objects, you can automate almost any task you can imagine.
Understand the structure of the Excel Object Model for efficient manipulation of any object and property in your Workbook!

Tal White, Virginia, USA

 

"I’m impressed & enjoy going through each of your training modules.

My current project’s building an Excel front end for mass invoice creation & import into QuickBooks Enterprise (we grow flowers to sell to grocery & retailers).

After I work through all your training modules it will be time for some re-work!

Thank you again for the work you’ve put into your materials. ".

Andrew Dove, Scotland

 

"I have to say that I am very impressed with your course.


The major positives that I have observed so far are:

  • Clarity of explanation

  • Obvious authority on the subject matter

  • Getting into the more advanced areas

  • Value for money

 

Personally, I am planning to make VBA development and Excel training a full time occupation by the end of this year.  As such I may well be interested in your supervision offering further down the line".

Ping Chan, Hong Kong

 

"I enjoy taking the lessons as each concept is explained clearly with relevant examples. The structure of the lessons is very well organized so it is easy for me to find the topic I wish to review and reinforce my learning".

What you will get when enrolling to this course:
  • 16 hours in 56 recorded, hands-on sessions

Each session was carefully planned, its code was written and verified and the video was edited to reflect a balanced blend of slides lecture with hands-on demo.

The course is structured to build a gradual learning curve. With each session you conquer another goal, expand your skills and experience.

The harmonized planning and orchestration of the complete 4-course program delivers to you an un-matched combination of skill-sets, typically never found in a single, coherent and complete program.

  • 3 Quizzes

Each module closes with a quiz. The quizzes are designed to measure your deep understanding of the material. Repeating a sentence you heard in the course is not enough to pass the quiz.

Only true understanding gained through practice leads to successful professionals - and that is what I aim for you!

  • 3 Assignments

Writing code that works for real business needs will earn you the practice and skill you need. The assignments are engineered to confront you with real business challenges and are considered an important part of your training.

I always say: an assignment is your opportunity to express yourself!

  • Assignments complete solutions: Excel VBA code for download

Download my suggestion for possible solutions to the assignments. These are complete, fully working solutions that will expand and enrich your knowledge and techniques for implementing business challenges.

I explain my solution for each and every assignment in a dedicated, detailed session, so these are important lessons in and of themselves - don't skip those sessions!

This course covers all you need to become an Excel VBA programmer

Course Introduction

In this module, you will be introduced with the course purpose, structure and contents, and after 10 minutes you'll start writing your first VBA program!

Computer Programming Fundamentals

In this module, we will lay the foundation of making you a computer programmer. This is what will differentiate you from most other Excel VBA developers. You will discover:

  • What is a computer program
  • Computer language structure
  • Data types
  • Software Applications Architecture

VBA: The Building Blocks

In this module, you will start coding VBA extensively. The main focus is to make you comfortable with the VBA development environment, find and interact with the Excel application objects and structure your program efficiently. You will discover:

  • Referencing Excel objects: Sheets, Cells...
  • The Excel Object Model
  • Properties, methods, events, collections, enumerations
  • The Macro recorder
  • Data storage & variables
  • Subroutines & Functions
  • User Defined Functions
  • Application Events
  • Debugging your code
  • Assignment: Summarize employees table by region

VBA: Programming Techniques

In this module, you will become a professional programmer with Excel VBA. You will use powerful programming techniques and be able to control your program to behave like a professional business software. Learning other programming languages will become easy. We'll cover:

  • Conditional Program Flow
  • Loops
  • Arrays
  • Application Behavior Control
  • User Interaction
  • User Defined Types
  • Error handling
  • Assignment: Create a dynamic PDF training certificate
  • Assignment: Build a query tool over purchasing data extracted from an ERP system
GET THE COURSE NOW

Watch Sample Lessons from the Course

Who am I and why I am the best guide for you

Hi!

My name is Mor Sagmon. 30 years ago, I co-authored a book teaching advanced Macros in Lotus 1-2-3 (it was the popular "Excel" before Excel came to be). Back then I delivered my first project: a financial reporting system for The 4 Seasons Hotel.

After graduating Computer Science, Information Systems and Databases at the Technion Institute of Technology, I continued delivering software projects implemented in a wide array of technologies.

Having served as the CIO of Avgol, a manufacturing company, I experienced leading complex IT projects from the other side: now as a customer.

The best school for me was probably my 15 years with the business software giant, SAP. After leading large software projects with customers such as Bose, Chevron, Shell Trading and others, I moved on to less technical positions, including business development, cutting-edge research,  academia relations manager, and sales operations.

Today I combine my unique experience and expertise in technology and business, and deliver beautiful, intuitive to use business software solutions, mainly built with Excel VBA and the MySQL Database. This extensive breadth of knowledge and experience with real business customers, enables me to offer you the top guidance possible in becoming a successful business software consultant, and an expert Excel VBA programmer.

Some of my customers have this to say about me:

Darren Dickey, VP Sales, Hospitality Designs

Mor is incredibly insightful. He thinks critically about the project and provides feedback and suggestions that improves on the scope. He was very responsive during the project and took great pride in the work he completed. I have no reservations in recommending him. I will be hiring him again for similar projects.

Rick Harris, Founder, Innovator-In-Chief, Customer Faithful Ltd

Great working with Mor. He took time and effort to discuss exactly what I needed, including suggestions which helped me a lot. Very professional – I expect to use Mor again and would not hesitate to recommend him to others.

Pedro Baez, President, PPAB Consultants

Mor has delivered a great product and ahead of schedule. During the process of creating the tool requested, Mor was patient and persistent on learning my needs, purpose and goal for the tool, before he started the creative process. His attention to detail was keen and productive. I will continue to use his services as other projects become necessary.

Take the first step in mastering Excel VBA and growing your career today!

There is no other course like it anywhere!

GET THE COURSE NOW

Feel free to contact me

I'm waiting to hear from you. email me directly at [email protected]. You can also find me on LinkedIn and my Facebook Page.

Close

50% Complete

Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.