Duration

1 day

Aim

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

Target Audience

Microsoft Excel 2007, 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 2007 Level Two assumes participant has attended Bute's Excel 2007 - Level One course or has a good knowledge of Excel 2007 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 Logical Functions Lookup Functions Nesting Functions Workshop Labels and Names Linking Workbooks Sharing Workbooks Simple Data Entry Working With Lists AutoFilter Pivot Tables Charting Chart Data Techniques Charting Techniques

Course Objectives

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

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

Course Outline