Excel 2003 Level 3 Advanced

Public Course Dates

	Date	Location
	Fri, 3 Sep 2010	Reading
	Fri, 15 Oct 2010	Reading
	Fri, 26 Nov 2010	Reading
	Fri, 7 Jan 2011	Reading
	Fri, 18 Feb 2011	Reading

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

£250 for 1 day

Included in the price:

Comprehensive Manual
Refreshments & Lunch
Post Course Support

Course Description
Course Outline

Course Overview

Microsoft Office Excel 2003 has helped you to perform tasks like running calculations on data and sorting and filtering numeric data. Now it is time to learn how to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. This course will advance your Excel skills.

Course Objective

Learn to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Target Student

This course is for students who wish to create macros, collaborate with others, review and analyze worksheets, create pivot tables and pivot charts, integrate multiple data sources, and import and export data. Additionally, this course is also for students who are preparing for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam.

Prerequisites

It is recommended that students should have completed the Systematix courses Microsoft Office Excel 2003: Level 1 and Microsoft Office Excel 2003: Level 2 or similar working knowledge of Excel 2003 such as creating, editing, formatting, and printing worksheets that include charts and sorted and filtered data.

We offer a range of Excel training courses

Streamlining Workflow
Add Data Validation Criteria Apply Conditional Formatting Create a Macro Customize Access to Excel Commands Edit a Macro Modify Excel's Default Settings Update a Workbook's Properties
Collaborating with Others
Adjust Macro Settings Administer Digital Signatures Merge Workbooks Protect Files Review Tracked Revisions Set Revision Tracking Share a Workbook
Auditing Worksheets
Group and Outline Data Locate Errors in Formulas Locate Invalid Data and Formulas Trace Cell Dependents Trace Cell Precedents Watch and Evaluate Formulas
Analyzing Data
Create Scenarios Create a Trendline Develop a PivotChart© Report Develop a PivotTable© Report Perform Statistical Analysis with the Analysis ToolPak Perform What-If Analysis
Working with Multiple Workbooks
Consolidate Data Create a Workspace Edit Links Link Cells in Different Workbooks
Importing and Exporting Data
Export to Microsoft Word Import Text Files Import a Word Table
Structuring XML Workbooks
Apply XML View Options Develop XML Maps Import, Add, and Export XML Data Manage XML Workbooks

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

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Excellent course, most topics were useful and the others were interesting and will be good to know about even if they don't affect my job personally

- IRI