|
Getting started
- Explanation of Excel opening screen
- Understand the Excel worksheet
- Renaming and colouring worksheet tabs
- Mouse control and keyboard commands
- Displaying different toolbars
- Customising toolbars
- Adding and deleting new toolbars
Getting help
- Using Office Assistant
- Using help menus
- Changing the help window
- Using 'What's this?'
Creating a worksheet
- Moving around the worksheet
- Selecting cells with mouse and keyboard
- Entering and editing data
- Undoing incorrect entries
- Saving the workbook and using Autorecover
Manipulating data
- Using Cut, Copy and Paste
- Using 'Drag and Drop'
- Using Go To
- Using Find and Replace
Entering formulae
- Adding formulae
- Using Autosum
- Replicating formulae
- Using Autofill and Custom Lists
- Using basic statistical functions
- Dealing with circular references
|
Formatting worksheet appearance
- Changing text appearance
- Changing alignment of text
- Formatting numbers
- Centring the title
- Using the Spellchecker
Altering workbook structure
- Inserting and deleting columns
- Inserting and deleting rows
- Changing column width and row height
- Removing gridlines
- Moving and copying worksheets
- Inserting and deleting worksheets
- Renaming workbook
Printing the worksheet
- Setting the print area
- Changing margin settings
- Centralising printout
- Creating headers and footers
- Using print preview
- Setting print variables
Full practice assignment
- Creating a worksheet from supplied information
- Customising the worksheet in accordance with instructions
- Printing out copies of the worksheet
- Amending details as required
|
