Who should attend? |
This course is intended for new users of Excel 2003. |
Prerequisites |
Windows 95, Windows 98, Windows NT 4.0, or Windows
2000 |
Course Objectives |
Upon completion of the course, participants will be able to accomplish the following:
- Open
and move around in an Excel workbook to learn navigation
skills necessary for creating and using Excel spreadsheets
- Organize
columns and rows to accommodate information and edit the contents
of cells to organize the information on your worksheet
- Calculate
values by entering formulas into cells and specify an exact address
of a cell by creating an absolute cell reference, create formulas
by typing functions or build more complex formulas using the
Insert Function dialog box
- Format
cells and worksheet elements to make the worksheet consistent and
readable
- Change
the page setup and preview the workbook to define how the printed
worksheet appears
|
Course Content |
|
|
Getting
Started with Microsoft Excel 2003
Understanding
Spreadsheet Concepts ; Creating
New Workbooks ;
|
|
Modifying
the Worksheet
Working
with Columns and Rows ; Working
with Cell Contents ;
|
|
Using
Formulas and Functions
Creating
and Using Formulas ; Creating
and Using Functions ; Using
Absolute Cell References ; The Insert
Function Command ;
|
|
Formatting
Worksheets
Formatting
Cells ; Formatting
Worksheet Elements ;
|
|
Setting
Print Options
Changing
the Page Setup ; Previewing
the Workbook ;
|
|
|