      |
Excel
2007 Essentials for Everyone
in Just Three Hours
Course
Length
Three Hours
Prerequisites
Windows
Introduction or equivalent experience
Course
Description
Perhaps you have
worked in Excel a time or two, but you are unsure how to do some of the
basics. This hands-on class is designed for the beginner or someone with
minimal Excel skills. Upon completion, you will be able to create and
edit worksheets, perform calculations, and use a variety of functions.
Course Topics
-
Identify screen elements
-
Move from sheet to sheet
-
Rename a worksheet
-
Select worksheets
-
Insert new sheet(s)
-
Move, copy, and delete
sheet(s)
-
Change the default number
of sheets in a workbook
-
Enter text and numbers
-
Use AutoComplete
-
Enter information in a
selected range
-
Replace and edit cell
contents
-
Use undo and redo
-
Print preview and print
-
Save and close a workbook
-
Create a new workbook
-
Open an existing workbook
-
Navigate in a worksheet
-
Use the Go To command
-
Change the view
-
Select and deselect data
-
Enter formulas
-
Edit a formula
-
Order of operations
-
Enter a function using
the Insert Function dialog box, the Function Library, and Formula
AutoComplete
-
Use the AutoSum button
-
Use the AutoFill feature
-
Resize columns and rows
-
Change a cell reference
to absolute or mixed
-
Insert and delete cells,
rows, and columns
-
Hide and unhide columns
and rows
-
Hide and unhide a
worksheet
-
Move, copy, and paste
worksheet data
-
Use the paste options
button
-
Use the paste button list
-
Sort rows by one column
What
Participants Receive
Each participant
receives a guide containing step-by-step instructions and
practice exercises.
|
