Advanced MS Excel 2000 for PC

Short Description
is referenced the exact same way that any other Excel function is used. 1. Select the cell to enter the function in. 2. Begin the formula by typing “=” and …

Website: facility.berkeley.edu | Filesize: 68kb

Content
University of California at Berkeley - Information System & Technology: WORKSTATION AND MICROCOMPUTER FACILITIES DIVISION
Advanced MS Excel 2000 for PC Page 1 of 8 Last Revised: October 3, 2000
Advanced MS Excel 2000 for PC
Course Description: The class is a continuation of the “Intermediate MS Excel 2000 for PC” class. Topics covered include
macros, user-defined functions, and simple Visual Basic procedures.
Prerequisites: familiarity with Excel 2000 and/or completion of “Intermediate MS Excel 2000 for PC”.
The W&MF staff has prepared this document for you so that can familiarize yourself with some of the
more advanced features of Excel 2000. This document is meant to serve as a future reference for you -
covering some options that you might find useful. Not all the information mentioned in this document
will be covered in the Advanced MS Excel 2000 class.
Automating Repeated Tasks
Macros are a series of commands that Excel automatically executes. Macros are best used when there is
a series of tasks that are repeatedly performed using the same sequence of actions and commands.
Macros in Excel are constructed using the Visual Basic programming language; however, it is not
necessary to understand computer…