Excel 2002 - Intermediate Plus

Course Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VAT

Overview: Microsoft Excel 2002 is a software application that can be used as a spreadsheet, database, or graphing program. The electronic spreadsheet portion of Excel allows you to perform sophisticated calculations and create formulas that automatically calculate answers.

The advantage of using formulas is that when data in the worksheet changes, all the formulas recalculate automatically. This feature assists you in developing budgets, forecasting models, creating sales plans, making financial projections, calculating inventories calculations, generating banking statements, and basically working with any format involving numbers. Excel can sort lists and select specific pieces of information based on specified conditions.

The intermediate plus module includes: Creating & using labels in formulas; working with databases & the data form; conditional formats; advanced filtering; linking worksheets/workbooks; worksheet protection; templates; sharing workbooks; advanced charting; importing & exporting data.

Working with Labels in Formulas

	Using Labels in Formulas
	Using Labels to Define a Range
	Using Multiple Stacked Headings

Working with Outlines

	Applying/Collapsing/Expanding an Outline
	Modifying Outline Settings
	Using Auto Outline

Working with Databases

	Creating & Modifying a Database
	Sorting Records by Multiple Fields
	Using / Removing Data Validation
	Creating a Custom Error Message
	Creating / Removing Subtotals from a List

Working with the Data Form

	Viewing the Data Form / Data Form Records
	Adding/Deleting Data Form Records
	Defining Criteria

Working with Advanced Filters

	Creating & Using a Criteria Range
	Using Comparison Criteria
	Using an Advanced And / Or Conditions
	Copying Filtered Records
	Using Database Functions

Advanced Charting

	Adding; Removing & Formatting Gridlines
	Formatting an Axis / Data Series
	Changing the Axis Scaling
	Adding Data - Different Worksheets
	Using a Secondary Axis
	Changing Data Series Chart Types
	Adding a Trendline
	Creating User-defined Charts

Using Multiple Workbooks

	Opening Multiple Workbook Windows
	Cascading / Tiling Open Workbook Windows
	Copying Data between Workbooks
	Saving / Opening a Workspace
	Closing All Open Workbooks
	Linking Workbooks; Opening Linked Workbooks

Using Conditional and Custom Formats

	Applying / Changing a Conditional Format
	Adding / Deleting a Conditional Format

Using Templates

	Saving a Workbook as a Template
	Using, Editing & Deleting a Template
	Creating Default Templates

Using Paste Special

	Copying Values & Formulas between Worksheets
	Performing Mathematical Operations

Customising Excel Preferences

Setting View; Edit; General Options

Using Worksheet Protection

	Unlocking Cells in a Worksheet
	Protecting / Un-protecting a Worksheet
	Creating / Deleting Allow-Editing Ranges
	Protecting / Unprotecting Workbook Windows
	Assigning / Removing a Password
	Setting Manual / Automatic Calculation

Sharing Workbooks

	Using / Saving a Shared Workbook
	Viewing Users Sharing a Workbook
	Viewing Shared Workbook Changes
	Changing the Update Frequency
	Highlighting Changes
	Managing & Resolving Conflicting Changes
	Setting Change History Options
	Reviewing Tracked Changes
	Merging Shared Workbook Files

Exporting and Importing Data

	Exporting Data to Other Applications
	Importing Data
	Changing External Data Range Properties
	Importing Data from Other Applications
	Removing the Query Definition

If you have other questions, please contact us at enquiry@it-uk.com or complete our response form