Microsoft® Office Excel® 2010: VBA
Course Specifications
Course number: 084288
Course length: 1.0 day(s)
Course Description
Course Objective: You will automate your job tasks in Microsoft® Office Excel® 2010.

Target Student: This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Prerequisites: Knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. Students are recommended to first take the following Element K courses or have equivalent knowledge: 
•	Microsoft® Office Excel® 2010: Level 1
•	Microsoft® Office Excel® 2010: Level 2
•	Microsoft® Office Excel® 2010: Level 3
•	Microsoft® Office Excel® 2010: Level 4
Hardware Requirements
For this course, you need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration: 
•	A PC with a Pentium® processor, at least 300 MHz.
•	10 GB of hard disk space or larger. You should have at least 1 GB of free hard disk space available for Office installation. 
•	A minimum of 64 MB of RAM with 1 GB of free hard disk space.
•	A CD-ROM drive.
•	Keyboard and mouse or other pointing device.
•	1024 x 768 resolution monitor is recommended.
•	Network cards and cabling for local network access.
•	Internet access (contact your local network administrator).
•	A printer (optional) or an installed printer driver.
•	A projection system to display the instructor’s computer screen. 
Software Requirements
Each computer requires the following software:
•	Microsoft® Office Professional Plus 2010 Edition
•	Microsoft® Windows 7 (Professional Edition)
•	Windows Rights Management Services (RMS) Client with Service Pack 2. 
Course Objectives
Upon successful completion of this course, students will be able to: 
•	develop a macro.
•	format worksheets using macros.
•	create an interactive worksheet.
•	work with multiple worksheets.
•	perform calculations.
Course Content
Lesson 1: Developing Macros

Topic 1A: Create a Macro Using the Macro Recorder 
Topic 1B: Edit a Macro 
Topic 1C: Debug a Macro 
Topic 1D: Customize the Quick Access Toolbar and Hotkeys 
Topic 1E: Set Macro Security 
Lesson 2: Formatting Worksheets Using Macros

Topic 2A: Insert Text 
Topic 2B: Format Text 
Topic 2C: Sort Data 
Topic 2D: Duplicate Data 
Topic 2E: Generate a Report 
Lesson 3: Creating an Interactive Worksheet

Topic 3A: Determine the Dialog Box Type 
Topic 3B: Capture User Input 
Lesson 4: Working with Multiple Worksheets

Topic 4A: Insert, Copy, and Delete Worksheets 
Topic 4B: Rename Worksheets 
Topic 4C: Modify the Order of Worksheets 
Topic 4D: Print Worksheets 
Lesson 5: Performing Calculations

Topic 5A: Create User-Defined Functions 
Topic 5B: Automate SUM Functions