Excel 2003 Level 2 Intermediate

Public Course Dates

	Date	Location
	Thu, 30 Sep 2010	Reading
	Thu, 28 Oct 2010	Reading
	Thu, 25 Nov 2010	Reading
	Thu, 23 Dec 2010	Reading
	Thu, 20 Jan 2011	Reading
	Thu, 17 Feb 2011	Reading
	Thu, 17 Mar 2011	Reading

This course is available as a public course at our Reading training centre.

£225 for 1 day

Included in the price:

Comprehensive Manual
Refreshments & Lunch
Post Course Support

Course Description
Course Outline

Course Overview

Now that you can create, edit, format, and print basic spreadsheets, you may find it is helpful to streamline repetitive tasks and produce a more visually effective spreadsheet display. This course will show you how to use Microsoft Excel 2003 to streamline and to enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective

Apply visual elements and advanced formulas to a worksheet in order to display data in a variety of formats.

Target Student

This course is designed for the student who desires to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. Additionally, this course helps prepare students to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisites

Experience creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft Excel 2003 is necessary. The Systematix course Microsoft Excel 2003 Level 1 or equivalent experience is recommended.

We offer a range of Excel training courses

Creating and Applying Templates
Create a Custom Template Create a Hyperlink Create a Workbook from a Template Use Web-based Research Tools Working with Comments
Creating and Modifying Charts
Change the Chart Type Create a Chart Create a Diagram Format Chart Items
Working with Graphic Objects
Change the Order of Graphic Objects Create AutoShapes Format Graphic Objects Group Graphic Objects Insert Graphics Move, Copy, and Resize Graphic Objects
Calculating with Advanced Formulas
Calculate Across Worksheets Calculate with Date and Time Functions Calculate with Financial Functions Calculate with Logical Functions Calculate with Lookup and Reference Functions Calculate with Statistical Functions Create and Apply a Name for a Range of Cells
Sorting and Filtering Data
Add Subtotals to a Worksheet Calculate with Database Functions Create and Apply Advanced Filters Filter Data Lists Sort Data Lists
Using Excel with the Web
Create a Web Query Export Excel Data Import Data from the Web Publish a Worksheet to the Web

Publisher:	Microsoft
Version:	2003
Length:	1 day
Course-ID:	084261

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The course trainer was excellent. She spent time with individuals, explaining any problems experienced

- Siemens