GETTING STARTED
- What is Excel?
- Starting Excel
- The Excel Application Window
- Using the Excel Ribbon
- Using the Microsoft Office Button
- Using the Quick Access Toolbar
- Displaying Help Information
- Exiting from Exce
MODIFYING AN EXISTING WORKSHEET
- Resetting the Working Folder
- Moving the Cell Pointer
- Changing Data in a Worksheet
- Reversing an Edit Operation
- Saving a Workbook
- Adding Data to a Worksheet
- Entering a Formula into a Worksheet
- Adjusting Column Width in a Worksheet
- Adjusting Row Height in a Worksheet
- Printing a Worksheet
BUILDING A NEW WORKSHEET
- Opening a New Workbook
- Using the Spelling Checker
EDITING A WORKSHEET
- Working in Edit Mode
- Selecting Ranges in a Worksheet
- Using AutoFill
- Copying Cells
- Moving Cells
- Clearing Cells
- Using AutoSum
- Inserting and Deleting Rows and Columns
- Inserting and Deleting a Range of Cells
|
FORMATTING A WORKSHEET
- Resetting the Alignment of Cell Entries
- Resetting Font Options for Cell Entries
- Resetting the Number Format of Cell Entries
- Adding Borders and Shading to a Worksheet
- Using AutoFormat
ENHANCING A WORKSHEET PRINTOUT
- Changing the Page Setup for a Worksheet
- Previewing a Worksheet
- Inserting a Manual Page Break into a Worksheet
- Including Print Titles in a Printout
- Printing Selected Worksheet Entries
USING EXCEL FUNCTIONS
- What is a Function?
- Using the SUM Function
- Using the AVERAGE Function
- Using the MAX and MIN Functions
- Using the COUNT Function
- Using the Insert Function Button
|