One Day Course
Course Description
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
-
Create, edit, and debug a macro.
-
Use querying tool.
-
Format worksheets using macros.
-
Create an interactive worksheet.
-
Work with multiple worksheets.
-
Perform calculations.
Prerequisites
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
-
Microsoft Office Excel 2007: Level 3.
Course Content
Developing Macros
-
Create a Macro with the Macro Recorder
-
Edit a Macro
-
Debug a Macro /li>
-
Customize the Quick Access Toolbar and Hotkeys
-
Work with Macro Security
Formatting Worksheets Using Macros
-
Insert Text
-
Format Text
-
Sort Data
-
Duplicate Data
-
Generate a Report
Creating an Interactive Worksheet
-
Determine the Dialog Box Type
-
Capture User Input
Working with Multiple Worksheets
-
Insert, Copy, and Delete Worksheets
-
Rename Worksheets
-
Modify the Order of Worksheets
-
Print Worksheets
Performing Calculations
-
Create User-Defined Functions
-
Automate SUM Functions
For more information on Acumen Classes
Please contact Deb Wagnon 314.333.3330
or
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63119
|
