Course Content

Formulas Review

·            Building formulas

·            Ordering calculations

·            Absolute cell references

·            Using functions

Managing multiple worksheets within a workbook

·            Moving and copying worksheets

·            Inserting and deleting worksheets

·            Selecting multiple worksheets

·            Changing tab colour (2003 and 2007 only)

Transferring and linking data

·            Linking within a workbook

·            Linking between workbooks

Creating and amending graphs

·            Using the chart wizard

·            Changing the type of graph

·            Adding additional data

·            Adding, removing and repositioning legends

·            Adding data labels

·            Formatting the graph

Customising and automating the Excel environment

·            Recording macros

·            Running macros

·            Assigning macros to quick keys

·            Assigning macros to toolbar buttons (2000, XP and 2003)

·            Assigning macros to the quick access toolbar (2007 only)

·            Assigning macros to objects

Conditional Formatting

·            Changing the cell format depending on set criteria

·            Databars, Top/Bottom Rules, Colour Scales and Icon Sets (2007 only)

Setting up data validation

·            Setting number and date validation

·            Setting drop down list validation

·            Setting custom validation

·            Using the auditing facility

Protecting information

·            Protecting worksheets

·            Selectively protecting (XP, 2003 and 2007 only)

·            Protecting workbooks