Length:
Two 3˝ hour Classes Prerequisite: Essentials of Windows (any version)
Unlock
the secrets of this powerful spreadsheet application! You’ll
understand how to create and save data into your workbooks, then insert,
edit, delete, copy, move and replace numbers and text. You’ll come
away knowing how to find answers to any Excel question with the powerful
help features. Then, you’ll discover how to format workbooks including
alignments, column/row sizes, borders, number, and date formats.
You’ll master how to create basic formulas and functions within a
worksheet, then create professional charts and graphs based on your
information. After you’re finished, you can select from dozens of
printing options. If you use numbers in your workplace, Excel is a must!
Getting
Started
Know
the parts of Excel's window (toolbars, menus, status bar, &
formula bar)
Use
Excel's powerful on-line help
Building
Worksheets
Create
a worksheet (insert, edit, delete, and replace data)
Undo
errors
Go
to a cell
Add
a comment to a cell
Save
and open a workbook
Basic
Formatting
Format
text
Change
column width
Change
row height
Change
cell alignments
Create
borders
Format
numbers
Format
dates
AutoFormat
a cell range
Copying
and Moving
Move
and add columns/rows
Cut,
copy, and paste
AutoFill
a cell range
Drag
& drop
Basic
Formulas
Create
formulas with addition, subtraction, multiplication, and division
