Session 1: Getting Started
Exploring the Excel Workspace
Understanding Workbooks and Worksheets
Entering Text and Numbers
Working With Ranges
Making Worksheet Selections
Cell Formatting
Modifying Columns and Rows
Using Find and Replace
Session 2: Using a Workbook
Creating and Modifying a New Workbook
Save Workbooks
Using the Open Dialog Box
Session 3: Using Worksheets
Arithmetic Operators
Create and Edit Formulas
Using Excel Functions
Zooming
Splitting a Worksheet
Freezing and Unfreezing Columns and Rows
Hiding and Unhiding Columns and Rows
Using Relative Cell References
Using Absolute Cell References
Session 4: Modifying Worksheets
Inserting and Deleting Cells
Inserting and Deleting Columns or Rows
Moving and Copying Cell Content
Applying Cell Borders and Shading
Working with Styles
Session 5: Proofing and Printing Worksheets
Check Spelling
Page Setup and Print Settings
Print Preview and Printing
Printing Nonadjacent Selections
Publish as Web Page
|
|
