Select individual items as they are listed below. Select all items listed below for beginning and intermediate
users (Basic Skills) .
Select all items listed below (Basic Skills) (Advanced Skills) .
1.
Program Management (Basic Skills)
Start and exit Excel Open and close a Workbook Navigate Help files
2.
File Management (Basic Skills)
Create a new Workbook -- Blank and Template Save a Workbook Find a file Modify the properties of a file
3.
Utilizing Enhanced File Management (Advanced Skills)
Import text files Share a Workbook Track changes
4.
Editing a Spreadsheet (Basic Skills)
Copy, cut, clear, move, and delete cells Paste and replace selected cells Delete selected Worksheet(s) Insert cells, rows, columns, and Worksheets Modify formulas and numbers Use Spellchecker
5.
Formatting a spreadsheet (Basic Skills)
Modify and set row height and column width Manipulate cells -- merge, center across, and align Show gridlines Set cell format -- currency, date, number, and text Set page margins and paper size Use Headers/Footers
6.
Utilizing Text Enhancements (Basic Skills)
Modify fonts and test size and color Modify text using boldface, italics, and underline Align text within selected cells Set text to wrap
7.
Printing Spreadsheets (Basic Skills)
Set page break Select a specific printer Use Print Preview Set print range to the selected area Print selected workbook(s) and
worksheet(s)
8. Using
Enhanced Formatting (Advanced Skills)
Set cell format -- fraction, scientific, percentage, and
custom Create and modify 3D shapes Insert charts, diagrams, and pictures Use borders and shading Hide a column Rotate text
9.
Using Formulas and Functions (Basic Skills)
Write formulas using add, subtract, multiply, and divide Use the AutoSum function Use the Insert function
10.
Using Advanced Formulas and Functions (Advanced Skills)
Use formulas incorporating IF and Range Names Use selected functions for text, database, date and time,
financial, math, and statistical analysis
11.
Using Data Manipulation (Advanced Skills)
Use sort and filter functions Validate data
12.
Working with Charts and Forms (Basic Skills)
Create a chart Create a chart with selected data Create a form
13.
Using Spreadsheet Analysis Tools (Advanced Skills)
Utilize auditing toolbar Setup and display Autofiler Create links between files Write multiple workbook formulas Use relative cell address function Use Trace Dependents tool
14.
Customize Excel (Advanced Skills)
Load "Add Ins" to current program Use split window tool Insert comments Customize menus Build macros Modify Office Assistant Protect cells and sheets Insert Word and Clip Art objects Modify the Toolbar
15.
Use Internet functions (Basic Skills)
Save file as HTML Insert and edit hyperlinks Use Web Display Toolbar