Summary

The comprehensive 6-week road map for mastering Excel macros (in a non-programmer way)

Learning goals

In this program you will discover:

• What is an Excel macro
• What is VBA
• How to start writing a macro
• How to run a macro
• How to write VBA instructions to control Excel
• How to understand Excel VBA once for all with intuitive, friendly and jargon-free explanations that just make sense. Fully understand the Excel VBA language so you write programming expressions your computer understands. Analogies with English are used extensively, so you see VBA is not that complicated. No more trial-and-error to get a macro that gets the job done. Get rid of your limitations due to your limited VBA knowledge
• How to connect the dots about how Excel VBA works by starting from the most basic fundamentals (programming background). Understand algorithms, the pillar programming concept, which regular Excel VBA training programs assume you already know. This new knowledge will build up your confidence to complete New and Challenging assignments
• What are all the Excel VBA components you can use to navigate, write and debug your macros
• How to make sense of error messages as you code and avoid errors from the ground up
• How to create Excel Macros that work for variable size arrays and sheets. Learn how to iterate through cells, rows and columns in your sheets. Learn how to use loops that literally think and know where to start and when to stop processing information. And use this knowledge to process big spreadsheets with a mouse click!
• How to find the best solution and the syntax for your macros. When you implement flowcharting right, you become a professional who always knows which is the best way to start your macros, how to find the VBA code and structure of simple to complex VBA macro projects (even at an enterprise level). You also increase your confidence to tackle bigger automation projects because your planning and design skills will make macros simple to write and read (decreasing debugging time and effort). This is another critical concept regular Excel VBA training programs assume you already know. When you gain this knowledge, you will design your own macros to reduce workload to almost half and will become a valuable asset for your company
• How to code common Excel routines like how to work with ranges, how to work with sheets and workbooks, etc. Code templates provided! 
• What are the main VBA functions you can use. List of main available functions provided! so you know instantly which functions exist
• How to communicate with other applications using VBA: Access, Word, Outlook, PowerPoint, etc. Code templates provided! Gain Prestige creating powerful applications such as one that prepares the weekly presentation out of many Excel workbooks, or another one that creates contracts in Microsoft Word out of Excel tables
• How to find the full syntax of VBA expressions to control any aspect of Excel objects: Charts, Pivot Tables, Sheets, Workbooks, etc. A one-line template is provided that works with every object of Excel. It’s something like fill in the blank template. Speed up the time to complete a job and do it minutes because you will be able to write simple lines of VBA code that do tens of boring tasks for you. Don’t work late anymore
• Demystify the scary Excel Object model using a simple analogy that makes perfect sense. This knowledge is critical to know the full VBA syntax of your automation instructions. Also, download the object model organized in a friendly mind map, so you have the big picture of all Excel VBA objects you can use and how to access them. Be Praised And Admired by your coworkers and boss who still don’t get it
• Easy VBA examples so you see how the concepts are implemented in real situations
• How to transform a macro blueprint into a VBA project
• How to type the VBA code of your macro faster
• And much more…