Duration

1 day

Aim

The skills and knowledge acquired in Microsoft Excel 2003, Level Two are sufficient to be able to use and operate the software at a very efficient level.

Target Audience

Microsoft Excel 2003, Level Two is designed for users who are keen to extend their understanding and knowledge of the software. Allowing the user to manipulate information and data lists.

Prerequisites

Microsoft Excel 2003 Level Two assumes participant has attended Bute's Excel 2003 - Level One course or has a good knowledge of Excel 2003 Orientation, Working with Workbooks, Working with Functions, Selecting Ranges, Formulas, Formatting Cells, Copying and Filling, Sorting and Printing. It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Content

Conditional Formatting Absolute Referencing Labels and Names Logical Functions Lookup Functions Nesting Functions Workshop Working With Lists Linking Workbooks Sharing Workbooks Charting Charting Techniques

Course Objectives

At the completion of Microsoft Excel 2003, Level Two you should be able to:

• use a range of conditional formatting options • understand and use absolute referencing in a workbook • use names and labels • use a range of logical functions • use the various Lookup functions • nest functions to create complex formulas • work with lists in worksheets • use linking to create more efficient workbooks • share workbooks with other users • create a variety of charts (graphs) in Excel • enhance charts that you create in Excel

Course Outline