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.
This course is intended for a student who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets.
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.
*Course cost listed does not include the cost of courseware ($46.49). 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.