Excel Intermediate

Functions
IF function
Creating multiple IF statements
Look ups
Information functions
Data calculations
Testing for errors
Naming ranges

Working with multiple sheets
Creating a new workbook
Selecting cells across worksheets
Entering formulae across worksheets
Using paste link
Splitting the worksheet into panes
Saving a workspace
Fixing worksheet titles
Copying and moving between worksheets
Copying and linking between workbooks
Insert, delete and group worksheets
Data Consolidate

Tools
Spell check
AutoCorrect
Find and replace
Cell and workbook protection
Using Zoom

Introduction to Pivot tables

Charts and Drawing
Creating a chart
Changing the chart type
Chart options
Formatting a chart
3D View
Printing
Using the drawing tools