Part time Excel Introductory

Microsoft Excel 2003 - Introductory Type of learning:
Instructor lead at DBIC

Duration:
1 day intensive

Times/dates:

Cost:

£185 (includes course materials, lunch and refreshments)
Corporate rates available please contact us for further information

Target Audience
Intending, new or recent users of Excel 2003.

Pre-Course Requirements
Delegates should be familiar with the Windows operating system. No knowledge of Excel 2003 is expected.

Benefits to the Employer
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.

Course Aims
This practical course will introduce the delegate to Excel 2003. It will provide â€OEhands on†experience of many of the features found in this programme. By the end of the course, the user will be competent with the following skills:

Course Outline

Fundamentals

- Spreadsheet Principles

- The Excel Screen

- Menus/Toolbars

- Taskbar

Save, Open and Close Workbooks

- Start a New Workbook

- Save and Close a Workbook

- Open a Saved Workbook

- Open Multiple Workbooks

Spreadsheet Modelling

- Spreadsheet Structure

- Create a Spreadsheet

- Labels and Numbers

- Moving Around a Worksheet

Formulas

- Add, Subtract, Multiply and Divide

- Brackets

- Percentages

- Ranges

- AutoSum

Editing Cells

- Edit Data

- Edit Directly in a Cell

- Delete Cell Contents

- Undo and Redo

- Copying and Moving

- Cut, Copy and Paste

- Copy a Range of Cells

- Use the Fill Handle

- Copy Formulas

- Drag and Drop

Printing

- Print Preview

- Page Setup/Margins

- Headers and Footers

- Gridlines and Headings

Formatting Cells

- Bold, Italic and Underline

- Numbers

- Date and Time

- Alignment

- Font Size and Colour

- Cell Borders and Shading

Formatting Worksheets

- Change Column Width and Row Height

- Insert and Delete Rows and Columns

- Hide Rows and Columns

Charts

- Create, Format and Print Charts

- Move and Resize

This course outline is a guide. All our courses can be tailored to customer requirements.