View Full Document

3 views

Unformatted text preview:

California State University Northridge Information Technology Training Guide Excel 2003 Basic Macros in Excel Table Of Contents 1 Introduction 2 What are Macros 3 Recording Macros Absolute Vs Relative Creating an Absolute Macro Creating a Relative Reference 4 Running Macros 5 Assigning Macros to your Toolbar to an Icon Button to the Menu Bar To an Object 6 Deleting Macros 7 Viewing your Macro Option 8 Class Exercise Introduction Find out what a macro can do for you Save yourself time energy keystrokes and headaches Learn how Macros can help you perform frequently repeated tasks quicker and easier This guide will take you through the process of Understanding what macros are and what they can do for you Recording macros Running macros Deleting macros Assigning frequently used macros to an icon button Prepared by Tina Actis Purtee User Support Services June 13 2006 ITR s Technology training guides are the property of California State University Northridge They are intended for non profit educational use only Please do not use this material without citing the source California State University Northridge Information Technology Training Guide What Are Macros What is a Macro A macro is a collection of excel activities that are performed in a predefined sequence and recorded The recorded sequences run completely within Excel What can Macro s do for me Marcos can be used to automate tedious or frequently repeated tasks How many times in a day do you have to type in a standard page heading for your department or put a standard footer on your document A macro will carry out this sequence of actions much more quickly than you could yourself For example you can create a macro that enters your department name address phone number etc In one row or cell in your worksheet centers the date in the cell and then applies a color and border format to the row or cell Any task that you find yourself repeatedly performing in Excel a macro can be recorded for it Wow what a time saver Now



Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Basic Macros in Excel and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Basic Macros in Excel and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?