| What is Excel used for?
Introduction to the screen
Introduction to the keyboard
Introduction to the mouse
Creating a new workbook
Selecting cells, rows, columns, ranges etc.
Cursor movements
Types of data
Entering data
Editing data
Clearing data
Undo/redo
Saving workbooks
Backing up workbooks
Closing workbooks
Opening existing workbooks
Formatting from the toolbar
Clearing formatting
Basic formulae
BODMAS - Order of Calculations
AutoSum
Fill handle - existing custom lists
Fill handle - dragging formulae
Absolute & Relative references
Adjusting column width
Adjusting row height
Merge and Center
Adding new columns/rows
Deleting columns/rows
Moving/copying data
Moving/copying formulae
Sorting using toolbar icons
Zoom
Freeze panes
Page setup
Printing
Print headers
Adding page breaks
Charts / Graphs
Office Assistant
|