Registration Fee – $49
March 9, 2021 – 2:00 pm – 4:00 pm PST (2.0 CPE)
Prerequisites: A good understanding of Excel basics
Advance Preparation: None
Field of Study: Technical
Handout Materials: All files and notes available for download. See below
This webinar will present the basis of working with Excel’s VBA and Macros and lay the foundation for successful macro writing.
- VBA and Excel’s tools-Developer Tab, VBA Editor, Macro Recorder, Editing Tools and Concepts.
- When to Use Macros and When Not to Use Them
- Avoiding Macro Traps
- Writing Your First Macro
- Simple, Yet Powerful Macros to Get You Started
- Macros written an Excel user, not as a programmer
- Copy macros
- Selection (highlighting data) macros
- Looping Macros
- Manipulating Cells and Ranges
- Attaching Macros to Buttons on the Worksheet
- Macro library for continued learning and reference
VBA is a very comprehensive language and a short course would be a minimum of 40 hours. Even then, more is needed in order to focus on the user’s specific needs. This webinar only touches the surface with the intent of giving you the tools and guidance for further study. If you are looking for a quick learning experience and think you’ll be able to immediately run with macro knowledge, this is not the course for you. Again, this webinar is providing the tools and knowledge to get you started. This course has been taught over 30 times in the two hour format and works out real well for a comprehensive introduction. You must have the commitment and desire to learn these powerful tools and understand that it’s a continuous learning process.
We have a complete inventory of courses for continued learning. These are updated and modernized materials used when I taught the Excel VBA and Macro class at UCSD Extension which was the largest attended class during that time frame.
All the files used in presenting these topics will be available for download before the webinar. The files will contain instructions on how to use the concept which includes the presenter’s notes. Files with additional macros (macro library) for future reference will also be available. The files will remain available online until March 31, 2021.
The next course will take everything above to the next level and beyond.
Jim Colville, Bio
Jim began working with spreadsheets with Lotus 1-2-3, v1a and then with Excel v3, and soon thereafter v4. He learned very early the power of Excel and how to be super productive in solving problems, creating business solutions and enhancing reporting in his CPA practice.
Seeing the business opportunity in educating others in using Excel he began his own PC training company teaching over 20,000 users over a period about four years. The training evolved into a consulting company offering specific solutions to companies and corporations by combining training combined with project challenges which resulted in powerful solutions. A by-product of this is Jim’s Zero Time Reporting, once the data is entered (or imported) the report is done.
Jim has authored well over Excel 500 courses, both as training materials and solution based Excel products for companies, corporations and nonprofit organizations. Many of these later became the foundation of web based articles and solutions under the the name of Info-Stat.com . With the saturation of Internet based Excel websites and Jim’s commitment to his CPA business the Info-Stat website was allowed to sunset. With his retirement from his CPA practice in 2019, Jim has revitalized his web-based activities in by writing articles, creating Excel files that offer solutions, revitalizing Info-Stat.com and more importantly, educational webinars through AEI. Excel has changed dramatically over the years and the new course and webinar offerings significantly modernize the Excel materials including, but not limited to, business and artificial intelligence.
Of major significance is the evolution of Jim’s education activities from a local San Diego PC training company to a national and world wide based company with Internet based products, both website and webinar offerings.