Learning Concepts Computer Training Inc.
Productivity Point International

Power Series
 

 

Excel 2003 - Macros – Power Series
Self-Assessment


As you work with Excel and become familiar with its features, you may identify tasks or operations that are performed routinely.  For example, you may repeat the same sequence of commands each time you create a monthly report or chart.  You can automate many of these tasks with macros.  A macro is a series of commands that Excel performs automatically when the macro is run.

 

Come and learn the basics of creating and editing Macros in Excel.  Learn how to have a macro “run” as soon as a file is opened.

 

Please complete all the parts of this self-assessment and based on the outcome, decide for yourself whether or not you have the pre-requisite knowledge to take this course.  If you have any questions e-mail rob@ppical.com or contact Rob at 269-6619.

 

You will find the course description below.

 

Should I Attend
This Workshop?

I can add a column or row using the Sum function

Yes

No

I can create formulas that add, subtract, multiply or divide

Yes

No

Result: If you answered no to any of these questions, the Power Series Workshop will be too advanced for you. We recommend that you attend the Productivity Point Advanced course before this workshop.

 

My job requires me to perform repetitive tasks in Excel.

Yes

No

My job requires me to constantly reformat or re-sequence data.

Yes

No

Result: If you answered yes to any of these questions, you have the required skills and will benefit from attending this workshop.

 

Excel 2003 - Macros

Course Description

 1/2 day Instructor-Led Course
 

Who should attend

Users who need to perform repetitive actions on data that is stored in a worksheet.
Users who need a quick and easy way to filter data or lists of transactions.

Users who need to quickly identify values based on specific criteria.

 

In this course we will:

  • Review macro and Visual Basic terms.

  • Record and run macros.

  • Use the Visual Basic Editor window to view, edit, and write macro code.

  • Add comments to macro code.

  • Print macro code.

  • Apply different cell selection techniques in macros using Range, ActiveCell, and Offset.

  • Use Value and Formula to control cell contents.

  • Run a macro from within another macro.

  • Explore the use of automatic macros.

  • Use macro shortcut keys to apply filters to a database.

  • Use conditional formatting within a macro.

  • Use the InputBox function to gather data from macro users.

 

What students receive

Each student receives a copy of the Power Series Student Manual and/or handouts for post-class reference.


Return to Power Series