| Basics |
| |
Standard toolbar overview
Formatting toolbar overview
Data entry
Block selection
Copying data
Moving data
Inserting cells, rows and columns
Deleting cells, rows and columns
Resizing rows and columns
Using the AutoFit facility
Undoing and redoing operations
Spell checking
Printing a spreadsheet |
|
| Formatting |
| |
Setting
alignment
Using cell shading
Adding borders to cells
|
|
| |
Using Autoformat
Number and date Formats
Creating styles
Applying styles
Modifying Styles
Using conditional formatting
|
|
| Formulas |
| |
Formulas
How formulas work
About cell references
About Excel ranges
Overview of functions
Using the AutoSum facility
Using the formula palette
Using conditionals
Statistical functions
Financial functions
Creating external references |
|
| Charts |
| |
Creating a chart
Setting chart options
Editing chart elements
Editing chart data
Adding logos and graphics
Printing charts |
|
| Productivity |
| |
Creating
reports
Setting print options
Creating custom lists
AutoCorrect
Password protecting documents
Protecting worksheets
Using hyperlinks
Save As Web Page
Web Page Preview
|
|