DT012 - Excel 2007 Level 2

In this one-day instructor-led course, students will use Excel 2007 to streamline and enhance spreadsheets with templates, charts, graphics and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.

Upon successful completion of this course, students will be able to:

• Calculate with advanced formulas
• Organise worksheet and table data using various techniques
• Create and modify charts
• Analyse data using PivotTables and PivotCharts
• Insert graphic objects
• Customise and enhance workbooks and the Microsoft Office Excel environment

Revision Exercises
• Creating Formulas
• Formula Summary
• Creating a Worksheet
• Editing a Worksheet

Absolute Cell Referencing Functions
• Function Syntax
• The MAX Function
• The MIN Function
• The IF Function
• Financial Functions
• Date Functions

Range Names
• Defining Range Names
• Names in Formulas
• Navigating with Names
• Using Named Constants
• Documenting Range Names

Lists
• Extended Formatting and Formulas
• Adding Records
• Sorting Data
• Using a Data Form
• Filtering Records
• Subtotals
• Outline Symbols
• Using other Functions
• Using Page Breaks
• Removing Subtotals

Outlining
• Hiding Detail
• Showing Detail
• Grouping Rows

Conditional Formatting
• AutoFill
• Filling Dates
• Filling Text
• Custom Lists

Charts
• Changing the Chart
• Type
• The Legend
• Gridlines

Formatting Charts
• Printing Charts
• Separate Chart Sheets
• Coloured Sheet Tabs
• Printing Separate Chart Sheets

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Before attending this course it is recommended participants have completed the Excel 2007 - Level 1 course or have the equivalent working experience.