Course Length:

2 Days

Course Description:

By taking this course, a student will learn to record simple 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.

Who Should Attend:

This course is for advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Create, edit, and debug a macro.
• Format worksheets using macros.
• Create an interactive worksheet.
• Work with multiple worksheets.
• Perform calculations.

Prerequisites:

Students should have knowledge of Microsoft Office Excel 2007, including how to create, edit, format, and print worksheets that contain charts, and sorted and filtered data. To ensure your success, we recommend the following courses, or equivalent knowledge in Microsoft Office Excel 2007: Level 1, Microsoft Office Excel 2007: Level 2, and Microsoft Office Excel 2007: Level 3.

Course Outline:

• Recording Simple Macros
• Editing Recorded macros
• Taking complex macro tasks and simplifying them
  1. Generalizing code and making it more flexible
  2. Importing text files
  3. Inserting columns & input boxes
  4. Filling in empty cells
  5. Appending data to another file
  6. Naming ranges
• Workbook and Worksheet objects using the immediate window
• Selecting ranges using vba code
• Code for Excel Tables, Pivot Table,& Charts
• If then else statements
• Loops
• Adding Worksheet controls
• Creating custom VBA forms and controls