Date: Friday, December 8, 9:00 a.m. - 4:30 p.m.
Class location: Building 98, (CLA) C5-15
registration form
Pre-requisite:
Completion of beginning and intermediate MS Excel courses or equivalent/knowledge and experience.
Instructor: California Computer Schools, Inc.
This course is coordinated through Organizational Development & Training.
Course Description/Curriculum:
- What are records and fields?
- Using the Pick List to enter data
- Defining and creating names
- Using the Go To feature
- Filter information using Auto Filter
- Create a custom Auto Filter
- Set up an Advanced Filter
- Using labels to match criteria
- Understanding "AND"/"OR" Searches
- Use number match/comparison criteria
- Writing formulas: =DAVERAGE, = DCOUNT, =DMIN, =DMAX, and =DSUM
- Sorting spreadsheet data
- Creating a series
- Create, edit, and delete a Custom List
- Using vertical/horizontal split windows
- Arrange multiple documents on screen
- Moving or Copying sheets
- Insert and delete sheets
- Copy data between Excel documents
- Link data from one file to another
- Understand linking between documents
- Creating a Template
- Viewing and customizing toolbars
- Recording and running macros
- Creating a macro button
- Adding custom menu to a toolbar
- Assign a macro to a custom menu
- Deleting menu items
To register, please e-mail ljroth@csupomona.edu
*Note to staff participants: Please be sure to clear your attendance with your managers.
How to Register
To request registration for one of the above listed dates/times, please complete the
Registration Form and fax to extension 3779.
If you have questions regarding registration for classes, please contact:
Loretta Roth, Organizational Development & Training,
email: at ljroth@csupomona.edu, or by
telephone: 909-869-2705.
Reservations will be confirmed by email.
Remember to put your own text here (same as alt text)
