- Home /
- Shop All /
- User Productivity /
- Microsoft Office /
- Microsoft Office Excel 2010: VBA
Product Description
Course length: 1.0 day(s)
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: VBA
Course Specifications
Course number: 084288Course 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