Great Thinking ...

The following outline is for example only. All courses can be tailored to your exact requirement based on training needs analysis. Training needs analysis may be purchased as a separate service or can be provided free to any company with an estimated training requirement of 10 or more days of training in a given 6 month period.

A sample of the delegate notes, slides and exercises from this course is available on request. Please send an email stating your interest and any relevant information to: Andrew @ Bindon . org.

Objectives

This course will enable Excel users to design Excel worksheets for a variety of reporting, budgeting, and numerical forecasting tasks.

Duration

One Day

Delegates will learn ...

• how to build, manage, save, retrieve, and print Excel worksheets
• the application of formatting choices and printing options
• shortcuts that make the time spent in Excel more productive
• an overview of Excel's advanced features

Prerequisites

Knowledge of the windows environment is a prerequisite. Delegates need not have prior knowledge of spreadsheets. This course is suitable for new users to MS Excel or users who are self taught and have been using MS Excel for a few of months. Delegates may like to review the recommended pre-course text: Patrick Blattner, Using Microsoft Excel 2003 prior to attending. Although this may enhance a delegates enjoyment of the course it is not a requirement.

Suggested Next Courses

Microsoft Excel 2003 Power User

Topics covered

Getting started

• The Excel working environment
• Menus, Toolbars, Workbooks
• The help system

Introduction to worksheets and workbooks

• Creating, Opening, Saving and Closing a file
• Some examples of where we're heading
• Practical examples of usage of Excel
• "What-if" analysis

More detail on creating a basic worksheet

• Entering and editing data
• Working with ranges
• Naming ranges
• Working with long text

Movement techniques

• Movement techniques in worksheets
• Introduction to workbooks

Using functions

• Working with functions
• Screen tips for functions
• Functions with 3-D references
• The Function Wizard

Moving and copying data

• Moving data
• Copying data
• Filling series of data

Modifying worksheets

• Editing cell contents
• Absolute and Relative cell references
• Dealing with circular cell references
• Inserting rows and ranges
• Checking the spelling of a worksheet

Formatting techniques

• Formatting cell contents
• Working with dates
• Advanced formatting
• Copying and pasting formats
• Printing a worksheet

Using Print Preview

• Printing the entire worksheet
• Printing specified ranges

Introduction to Excel charting

• Creating a chart

How many software education companies do you know that tell you before you book a course the credentials of the person who will be leading it?

While many training companies will try to convince you that all their course leaders are equally proficient, the truth is that some are much more effective course leaders than others, some know the subject of the course in much greater depth than others, and some are much more effective at conceptual communication than others.

When you hire Gooisoft, you know what you're getting.

Your course leader - Andrew Bindon M.A.(Cantab), MCP, LCP

• 15 years experience designing and delivering technical training courses, in particular targetting the Microsoft windows platform
• Designed the course he will be delivering based on years of experience using the product
• Designed the course he will be delivering based on his experience of leading technical training courses
• Has led software development teams that provided software solutions to some of the largest UK and international brands
• Spent 2 years working for market leading communication and personal effectiveness company (LEC International)
• Has himself been a participant in 57 communication skills seminars
• Degree in philosophy of science from the University of Cambridge, 1988