Excel  Intermediate 2007
One-Day Course

Course Overview

This hands-on course is designed to advance the delegates' knowledge of the features and functions within Excel 2007.  Delegates will get practice creating and modifying actual spreadsheets, enhancing them with charts and graphics and using more advanced formulae using the ribbon

Delegates Requirements

A working knowledge of using PCs, a keyboard and mouse, Windows and some experience of creating basic spreadsheets is required, and either gained from the workplace or by prior attendance on a Windows Introduction and Microsoft Excel Introduction course.

Who Should Attend

Users with a basic understanding of Microsoft Excel who want to consolidate and expand on their knowledge of the intermediate features in 2007a short space of time.

Course Outline

Topic Heading

Microsoft Excel Intermediate

Intermediate Spreadsheet Functions and Features

Reviewing the Basics

New Features in 2007

Increased Workbook File Size

Cell Styles

Table Styles

New Conditional Formatting

Sort by Cell/Font Colour

New Chart Features

Page Layout View

Old Feature, New Location

Formatting the Worksheet

Adding Borders and Shading

AutoFormats

Copying Formats

Text Formatting

Indented Lists

Using Styles

Creating and Applying a New Style

Modifying Styles

Navigating Worksheets and Workbooks

Opening a Second Workbook

Working with Large Sheets

Using Zoom

Worksheet Linking

Using More Advanced Formulae

Using Scientific Calculations

Preventing Rounding Errors

Conditional Formulae (IF, AND and OR)

The Formula Palette

Financial Functions (PMT, FV, PV)Productivity

Features

Protecting the Worksheet

Hiding Data

AutoCorrect

The Spelling Checker

Charts and Pictures

Creating Charts

Changing Chart Elements

Changing Chart Data

Printing Charts

Using Smart Art Graphics

Drawing Objects

Manipulating Objects

Graph Plotting

Excel and the Internet

Creating Hyperlinks

Saving a Worksheet as a Web Page

Web Page Preview

Sending Worksheets and Workbooks Via E-mail

TO BOOK A COURSE
Telephone 01794 521449