Course Overview
TOPIn this two-day course, you will learn to record simple macros, edit code and how to write your 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 and Immediate windows. The course covers many styles of code including With statements, If… Then… Else statements, loops and event driven code.
Scheduled Classes
TOPWhat You'll Learn
TOPIn this course you will:
- Record Simple Macros
- Edit Recorded macros
- Take complex macro tasks and simplifying them
- Work with workbook and worksheet objects using the Immediate window
- Select ranges using VBA code
- Code for Excel Tables, Pivot Tables & Charts
- Create If… Then… Else statements
- Create Loops
- Add worksheet controls
- Create custom VBA forms and controls
Outline
TOP
Viewing outline for:
- Recording Simple Macros
- Editing Recorded macros
- Taking complex macro tasks and simplifying them
- Generalizing code and making it more flexible
- Importing text files
- Inserting columns & input boxes
- Filling in empty cells
- Appending data to another file
- Naming ranges
- workbook and worksheet objects using the Immediate window
- Selecting ranges using VBA code
- Code for Excel Tables, Pivot Tables and Charts
- If… Then… Else statements
- Loops
- Adding worksheet controls
- Creating custom VBA forms and controls
Prerequisites
TOPTo be successful in this course, student should have taken Excel Part 1, Excel Part 2 and Excel Part 3 or possess the equivalent knowledge.
Who Should Attend
TOPStudents who wish to automate tasks in Excel.