Microsoft Visual Basic. Master programming for Windows.

This one-day introductory course assumes no prior programming knowledge, and builds a solid foundation of the skills and knowledge required to learn to read and write industrial VBA code in Microsoft Excel. You will gain an understanding of the background knowledge (and more) a programmer should have, in order to successfully learn to program Excel VBA macros and functions.

It is recommended you complete this course prior to attending the three-day Microsoft Excel VBA Course: Masterclass if you are:

• a self-taught programmer (including VBA)
• a non-programmer
• experienced in programming languages other than VBA.

Outcomes

By the end of this course, you should be able to:

• discuss the elements of human logic manifest in Excel’s user interface, and some of the ways those elements manifest in Excel VBA
• implement those elements in VBA functions and VBA macros for Excel
• describe the Microsoft Excel Object Model and VBA concepts
• begin to catch errors with basic debugging
• feel competent in progressing onto the three-day Microsoft Excel VBA Course: Masterclass.

Content

Human logic

• Gain an overview of the knowledge required to program in Excel VBA
• Understand the Six Requirements of Human Problem Solving
• Lear