Getting started
- What is Excel? Starting Excel, the Excel application window
- Using the Excel menu system, using Excel toolbars
- Using Excel task panes
- Displaying help information
- Exiting from Excel
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
- Printing a worksheet
Building a new worksheet
- Opening a new workbook, using the spelling checker
Using worksheet shortcuts
- Using Autofill
- Copying cell entries, moving cell entries, clearing cells
- Using Autosum
- Inserting and deleting rows and columns
- Inserting and deleting a range of cells
|
Enhancing worksheet appearance
- Working in edit mode
- Adjusting row height in a worksheet, realigning cell entries
- Resetting the font of cell entries and number format of cell entries
- Adding borders and shading to a worksheet
- Using Autoformat
Enhancing printed output
- Changing the page setup of a worksheet
- Previewing a worksheet
- Printing selected worksheet entries
Using Excel functions
- What is a function? Using the sum function
- Using the average, max and min functions
- Using the count function, using the insert function button
|