Microsoft Excel 2007 Intermediate + Advanced

This is a fast track 2 day course which combines EXCL07INTER and EXCL07ADV

Microsoft Excel 2007 Intermediate Course Outline

Target Audience

Delegates that need 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

Prerequisites

To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel 2003.

Viewing Worksheets

• Customising View Options

• Displaying And Customising Toolbars

• Hiding Workbooks And Worksheets

• Freezing Panes

• Grouping And Ungrouping Worksheets

Printing

• Using Page Setup

• Margins

• Headers And Footers

• Printing a Spreadsheet

More Formatting Techniques

• Using Styles

• Conditional Formatting

• Using The Format Painter

• Using Guidelines

• Hiding And Displaying Cells

More Formulas And Functions

• Using Named Cells And Ranges In Formulas

• Using The Series Command

• Using The Insert Function Wizard

• Using The Excel Function Categories

• Correcting Formulas

• Using The Formula Error Checker

• Using The Formula Auditing Toolbar

• Using The Watch Window

Database and List Management

• Using Databases

• Creating And Editing A Database

• Sorting A Database

• Using Autofilters

• Advanced Filters

• Working With Filtered Data

• Using Data Forms

Excel 2003 And Other Applications

• Converting Files From Other Applications

• Copying Data From Another Application

• Embedding And Linking Objects

• Hyperlinks

• Managing Links

Microsoft Excel 2007 Advanced Course Outline

Target Audience

Delegates that need to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data

Prerequisites

Delegates must already have a good working knowledge of Excel 2003, using formulas. Creating, editing and formatting spreadsheets.

Importing Data

• Importing Data From External Sources

• Importing Text Files

• Using Microsoft Query

• Querying Data From The Web

• Refreshing Data

Templates And Styles

• Working With Templates

• Working With Styles

Analysing Data

• What-If Analysis

• Goal Seek

• Data Tables

• Scenario Manager

• Solver

• Using Pivot Tables

Macros and Custom Controls

• Working With Macros

• Running Macros

• Adding Custom Controls

Charts

• Chart Wizard

• Chart Toolbar

• Working With Charts

• Formatting the Chart Security And Proofing

• Security Features

• Protecting Excel Files

• Worksheet Protection

• Checking Spelling

• Using Data Validation

• Using Text To Speech

• Documentation

Customising Excel 2007

• Configuring Excel 2003 Options

• Working With Workspaces

Collaboration and Consolidation

• Sharing Workbooks

• Sending Workbooks

• Consolidation

Analysing Data

• Solver

Macros and Custom Controls

• Basic VBA

• Working With Macros

• Running Macros

• Adding Custom Controls

Customising Excel 2007

• Configuring Excel 2003 Options

• Customising The Excel Environment

• Working With Workspaces