Excel Intermediate

Basics

My Places toolbar and smart tags
Open dialogue box toolbar
Customise toolbars
Change page view mode and zoom
Freeze rows or columns to remain on the screen
Hide/unhide columns/rows
Split screen and remove split screen
Document exchange
Create a new folder when saving
User name, file location
Getting Help
Formulas And Functions And Cell Referencing

Relative/absolute cell referencing
Mixed cell references
Basic error messages in formula
Check a formula for errors
Quick replicate
Spell check
Count, Average, Minimum, Maximum
IF function
Manipulate Workbooks And Worksheets

View different worksheets
View all open workbooks
Rename a worksheet
Sheet colour tab
Add/delete a worksheet
Copy/move a worksheet within or between workbooks
Editing Data

Grouping and editing worksheets
Undo/redo multiple actions
Copy or move data between workbooks
Find/replace specific data
Sort using sort buttons
Sort by more than one column
Preparing To Print

Scaling and orientation
Create headers and footers
Set and clear the print area
Printing a selected area
Insert/remove a page break
Repeat row/column titles on multiple pages
Set the page order
Formatting

Change the font style, size, colour
Numbers as text
Date styles/entering dates
Hours and minutes
Accounting symbols
Numbers as percentages
Horizontal and vertical alignment
Merge cells
Center text across cells
Wrap text
Shrink to fit
Change text direction
Cell borders and shading
Format painter
Specify column width and row height
Insert/delete individual cells
Repeat command
Simple Charts

Explode all or part of a pie chart
Copy/move a chart
Delete a chart
Change the chart type/data range
Change the titles, legends and data labels
Change the chart location
Paste Special

Copy values
Transpose data
Link worksheets