Excel  Intermediate
One-Day Course

Course Overview

This course is designed to advance users' knowledge of the features and functions within Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets, enhancing them with charts and graphics and using more advanced formulae.

Delegates Requirements

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

Who Should Attend

Users with a basic understanding of Excel  who want to consolidate and expand on their knowledge of the basic features in a short space of time to make them more efficient and productive in the work place.

Course Outline

Excel  Intermediate

Intermediate Spreadsheet Functions and Features

Reviewing the Basics

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

Preventing Rounding Errors

Conditional Formulae (IF, AND and OR)

The Formula Palette

Productivity Features

Protecting the Worksheet

Hiding Data

AutoCorrect

The Spelling Checker

Charts and Pictures

Creating Charts

Changing Chart Elements

Changing Chart Data

Printing Charts

Inserting Clip Art and Pictures

Drawing Objects

Manipulating Objects

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