Home > Microsoft Office Training:
Microsoft Excel Training - Macros
Microsoft Office 2007
Application Overview:
Microsoft Excel
Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.
Users:
IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.
Upgrade to Microsoft Office 2007 Training
Microsoft Office 2007 Training
Microsoft Excel 2007
Macros
Course Information
Duration: Two-Day Course
Platform: Windows and Macintosh
Fee: $595 CDN (+GST)
This class is limited to eight people.
Course Overview
Excel Macros enable you to automate repetitive tasks –and it’s not as hard as you may think. Use the Excel macro recorder to create the macro, then use the Visual Basic Editor to customize the recorded procedure. You can also create your own functions if the Function Wizard doesn’t have what you need. You won’t believe the time you can save!
Knowledge of Excel at the Intermediate/Advanced level is a prerequisite for this course.
Course Content
- Determine if a Macro is Necessary
- Existing Excel settings and functions that may eliminate the need for macros
- Introduction to Visual Basic for Applications
- Running and recording a macro
- Relative and Absolute macro recording
- Examining module design
- Assigning Macros
- Specify the location of recorded macros: individual or Personal macro workbooks
- Assigning macros to shortcut keys
- Assigning macros to an action button on a worksheet
- Assigning a macro to a button on a toolbar
- Decision Making Macros
- Create macros with different outcomes depending on conditions in a workbook using:
- the If Then function, the If Then Else function and the Select Case function
- Using Defined Functions
- Creating customised functions and formulas not already in the Excel extension function list
- Using variables
- Managing Macros
- Using the Personal macro workbook to store frequently used macros
- Assigning a macro to run automatically when a file opens
Calendar Dates:
Download PDF of Course Outline
If you have Adobe Reader installed you can view it now:
Related Training
DPA Certificate Programs
Our certification programs give you the opportunity to build your proficiency in electronic imaging, page layout, Internet, and office productivity while saving you a considerable amount.
more >>
(PDF 55 kb)