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…
-
Discovering The Excel VBA fundamentals
- Getting started
- The simple flow of automation instructions – What’s an Excel macro
- What an Excel macro can do for you
- How do you take control of Excel using the Excel VBA tools
- How to start an Excel macro
- How to run a macro
- How do you pause/halt a macro
- How to terminate an Excel macro
- How to alter the flow of instructions in a macro (Quick intro to dynamic macros)
- The next step
-
The Secrets Of Excel VBA Language
-
The secrets of Excel VBA objects
- Getting started
- Uncovering the fundamentals of Object oriented programming
- The Excel object model revealed
- Why do you need an object model?
- So, then what’s the Excel object model?
- How do you refer to Excel VBA objects (members) in a hierarchy
- How to control Excel objects
- Object’s property syntax
- Object’s method syntax
- How to control the Range object
- How to control cells statically
- How to control cells based on a relative position
- How to control cells dynamically
- Using a ForNext loop
- Using a DoWhile loop
- Using a DoUntil loop
- How to control columns statically in a sheet
- How to control columns based on a relative position
- How to control columns dynamically in a sheet
- How to control rows statically in a sheet
- How to control rows based on a relative position
- How to control rows dynamically in a sheet
- How to control the WorkBook object
- How to respond to workbook events
- How to control the WorkSheet object
- How to control the PivotTable object
- Adding a new Pivot Table using VBA
- Adding row fields to a Pivot Table using VBA
- Adding data fields to a Pivot Table using VBA
- Adding column fields using VBA
- Adding page fields using VBA
- Converting the current region to a table
- How to make your macros interactive and user-friendly
- How to create a user form
- How to use form’s data in your macros and macros data in your forms
- How to control another application’s objects
- The next step
-
The Fundamental Excel VBA Programming Tools
-
How To Design Excel VBA Macros
-
How To Write Excel VBA macros
Free
broken link above: “name forms and controls efficiently on page Error! Bookmark not defined.”
Hi Eli,
Fixed! Thanks for reporting the issue.