This example-based, hands-on course introduces you to the fundamentals of writing Excel macros. You will learn how to create procedures to automate your work, remove the risk of inconsistencies and errors in repetitive tasks and above all, to save time.
You will write and edit macros for Excel, using Visual Basic for Applications and the Integrated Development Environment.
Upon successful completion of this course, students will be able to:
-Create new macros and edit existing ones
-Assign those macros to toolbar buttons and to get them to run automatically
-Create sub procedures to interact with the user, asking for information and returning information
-Format a worksheet, including text, cell borders and shading and use custom number formats through VBA
-Enter data in cells and retrieve data from cells programmatically
-Assign headers and footers programmatically and work with workbook properties
-Create code loops to iterate through sheets in a workbook or cells in a range, in order to process each item in them in similar ways
-Create programmatic tests and have the code respond in different ways depending on the outcomes of those tests
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
This course assumes that you have a sound grasp of working with excel, including writing worksheet formulas (such as SUM, MAX, MIN, AVERAGE etc) and formatting data. Any experience of recording and stepping through macros will be beneficial, but is not a pre-requisite for attendance.
Before starting this course, delegates are recommended to take the PTR courses: Microsoft Excel Level 1, Level 2 and Level 3, or have equivalent knowledge and skills.