VSBT

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