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.
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!
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!
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!
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!
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:
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:
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:
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:
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.
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.
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.