By taking this 3 day class, a student will learn to record macros, edit code, and learn how to write their own VBA sub procedures. This course provides many examples of macro development that can help manage excel spreadsheets. Students will become familiar with the visual basic editor window and the immediate window. The course also studies many styles of code i.e. with statements, if then- else statements, and loops along with event driven code.
*Course cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run the class. Please contact us at firstname.lastname@example.org or 207-775-0244 for additional pricing information, or if you have any questions.
You must have good Excel skills and understand key concepts of spreadsheets or equivalent. It is not necessary to have prior programming knowledge. We cover VBA Macro programming concepts from the very basic level.
At Course Completion you will be able to:
Automate worksheet functions.
Work with multiple workbooks.
Import and export data.