Microsoft Excel 2003 Level 2 Course
Course Description
In Excel 2003 - (Level 1), you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Course pre-requisites:
To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel 2003. Students can obtain this level of skill by taking the following PTR course:
This course is rated as an Intermediate Course, suitable for accomplished computer users.
Topics covered on the 1 day Microsoft Excel 2003 Level 2 course
Creating and Applying Templates
- Create a Workbook from a Template
- Create a Custom Template
- Working with Comments
- Create a Hyperlink
- Use Web-based Research Tools
Creating and Modifying Charts
- Create a Chart
- Format Chart Items
- Change the Chart Type
- Create a Diagram
Working with Graphic Objects
- Insert Graphics
- Create AutoShapes
- Format Graphic Objects
- Change the Order of Graphic Objects
- Group Graphic Objects
- Move, Copy, and Resize Graphic Objects
Calculating with Advanced Formulas
- Create and Apply a Name for a Range of Cells
- Calculate Across Worksheets
- Calculate with Date and Time Functions
- Calculate with Financial Functions
- Calculate with Statistical Functions
- Calculate with Lookup and Reference Functions
- Calculate with Logical Functions
Sorting and Filtering Data
- Sort Data Lists
- Filter Data Lists
- Create and Apply Advanced Filters
- Calculate with Database Functions
- Add Subtotals to a Worksheet
Using Excel with the Web
- Export Excel Data
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
|
(click button to view / download course outline in printer friendly format)
(may take a few seconds to load)
|
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Applications Training Course
Course Fee = £250 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
| 29 | 25 | 30 | 20 | 24 |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The Microsoft Excel 2003 Level 2 course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.
View SAVE IT Scheme Details
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
|
