1. Getting Started
- starting Excel, the Excel application window
- using the menu system and toolbars
- exiting from Excel
2. Modifying an existing worksheet
- resetting the working folder
- moving the cell pointer, changing data in a worksheet
- undoing an operation
- saving a workbook
- adding data to a worksheet, entering formulas
- adjusting column width in a worksheet
- printing a worksheet
3. Building a worksheet
- opening a new workbook
|
4. Using worksheet shortcuts
- using AutoFill
- copying, moving and clearing cell entries
- using AutoSum
- inserting new rows and columns into a worksheet
5. Enhancing worksheet appearance
- using edit mode
- adjusting row height, realigning cell entries
- changing the font, numeric format
- adding a border and shading to a worksheet
- using AutoFormat
6. Improving printed output
- changing the page setup
- previewing a worksheet
7. Final case study |