Excel 2003 Introduction to VBA | Days of Training: 1 | |
Overview: In this course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. | Lesson 1: Developing Macros □ Create a Macro with the Macro Recorder □ Edit a Macro □ Debug a Macro □ Customize Toolbars, Menus, and Hotkeys Lesson 2: Formatting Worksheets □ Sort Data □ Insert Rows and Columns □ Insert Text □ Format Text □ Duplicate Data □ Generate a Report Lesson 3: Creating an Interactive Worksheet □ Determine Dialog Box Type □ Capture User Input | Lesson 4: Working with Multiple Worksheets □ Insert, Copy, and Delete Worksheets □ Rename Worksheets □ Modify the Order of Worksheets □ Print Worksheets Lesson 5: Performing Calculations □ Create User-defined Functions □ Automate SUM Functions |
Who Should Attend: Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. | ||
At Course Completion: Upon successful completion of this course, students will be able to: - develop macros, format, worksheets, create an interactive worksheet , work with multiple worksheets, perform calculations | ||
For more information or to register for classes, please contact:
New Horizons-GTG 5555 San Felipe, Suite 1500 Houston, TX 77056 Main: 713-552-1414 Online Schedule: 2007 Training Schedule Visit us online: http://www.nhhouston.com/ New Horizons Houston Blog: http://nhhouston.blogspot.com/ |
