Instructor: California Computer Schools, Inc.
Moving with the keyboard and mouse
Methods for entering data in a spreadsheet
Making changes to spreadsheet data
Using Cancel/Undo/Redo
Methods for selecting data
Clearing Cells
Inserting cells, rows, and columns
Deleting cells, rows, and columns
Using Spell Check
Methods to move data (cut and paste)
Methods to copy data (copy and paste)
Aligning data in cells
Horizontal alignment
Vertical alignment
Rotating text
Wrapping text
Change column width or use Auto-Fit
Change row height or use Auto-Fit
Hiding and unhiding columns and rows
Save files and use Save As to copy a file
Closing files
Opening an existing file
Creating a new workbook
Writing Formulas
Edit formulas and fix common errors
Filling formulas
Mouse shortcut to fill formulas
How the AutoSum feature works
Use absolute references in formulas
Select and change number formats
Change viewing options
Freezing vertical/horizontal panes
Creating manual page breaks
Using Print Preview
Page Setup:
Orientation, scaling and paper size
Margins, centering text on page
Custom headers and footers
Print area and row/column headings
Deleting Files
To register, please log into Bronco Direct
If you have a disability and need an accommodation, please inform us by email at ljroth@csupomona.edu or by calling the ODT office at x3726 one week prior to the workshop.
Loretta Roth, Organizational Development & Training,
email: at ljroth@csupomona.edu
phone: 909-869-2705.
Reservations will be confirmed by email.