 |
Overview |
|
 |
What
is a spreadsheet? |
|
|
Applications
of spreadsheets |
|
|
The terminology of spreadsheets |
|
|
Planning a spreadsheet |
|
|
An
introduction to Microsoft Excel |
|
|
The desktop |
|
|
Menus |
|
|
Toolbars |
|
|
Dialog boxes |
|
|
Online help |
|
|
User-selectable configurations |
|
|
Using Microsoft Excel |
|
|
Creating,
editing, and using spreadsheets |
|
|
Selecting
cells, rows, columns, and blocks |
|
|
Entering
text, numbers, and formulas |
|
|
Saving,
opening, and closing workbooks |
|
|
Adding,
deleting, and naming worksheets |
|
|
Formatting
worksheets |
|
|
Organizing
data |
|
|
Modifying
cell contents |
|
|
Copying,
moving, and deleting data |
|
|
Inserting,
deleting, and moving rows and columns |
|
|
Sizing
and aligning cells, rows, and columns |
|
|
Using
cell references |
|
|
Sorting
data |
|
|
Formatting
text and numbers |
|
|
Creating
and applying ranges |
|
|
Using
basic worksheet functions |
|
|
Creating
and modifying lines, objects, and shapes |
|
|
Creating,
formatting, and modifying charts |
|
|
Creating
and modifying headers and footers |
|
|
Previewing
and printing ranges, worksheets, and charts |
|
|
Saving
spreadsheets for use on the Web |
