Excel 2002 - Intermediate

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 module includes Managing Worksheets; Name Ranges; Formatting Charts; Drawing techniques; AutoFilter; HTML; Outline; Name Ranges; Comments and more.

Using Large Worksheets

	Increasing the Magnification
	Decreasing the Magnification
	Changing the Magnification of a Range
	Switching to Full Screen View
	Splitting the Window
	Removing Split Windows
	Freezing the Panes
	Unfreezing the Panes

Working with Multiple Worksheets

	Using Multiple Worksheets
	Navigating between Worksheets
	Selecting Worksheets
	Renaming Worksheets
	Selecting Multiple Worksheets
	Colouring Worksheet Tabs
	Inserting Worksheets
	Deleting Worksheets
	Printing Selected Worksheets

Managing Worksheets

	Copying Worksheets
	Moving Worksheets
	Using Grouped Worksheets
	Moving Data between Worksheets
	Copying Data between Worksheets
	Creating 3-D Formulas
	Using 3-D Ranges in Functions

Using Range Names

	Working with Range Names
	Jumping to a Named Range
	Assigning Names
	Using Range Names in Formulas
	Creating Range Names from Headings
	Applying Range Names
	Deleting Range Names
	Using Range Names in 3-D Formulas
	Creating 3-D Range Names
	Using 3-D Range Names in Formulas

Using Other Functions

	Using Function Arguments
	Using Financial Functions
	Using Logical Functions
	Using Date Functions
	Formatting Dates
	Revising Formulas

Managing Data

	Sorting Lists
	Sorting in Ascending/Descending Order
	Finding Data
	Replacing Data
	Finding and Replacing Cell Formats

Using AutoFilter

	Enabling AutoFilter
	Using AutoFilter to Filter a List
	Clearing AutoFilter Criteria
	Creating a Custom AutoFilter
	Disabling AutoFilter

Managing Files

	Changing Workbook Properties
	Using the Basic Search Task Pane
	Using the Advanced Search Task Pane
	Clearing Query Clauses
	Selecting File Views
	Sorting Excel Files

Formatting Charts

	Formatting Charts
	Adding Chart Titles
	Formatting Chart Objects
	Changing the Text Orientation
	Adding a Data Table
	Creating an Exploded Pie Chart
	Adjusting the 3-D View
	Deleting a Chart

Drawing an Object

	Working with Drawing Objects
	Drawing Enclosed Objects
	Drawing a Line
	Selecting Filled and Unfilled Objects
	Moving an Object
	Adding Text to an Object
	Selecting Text in an Object
	Resizing an Object
	Formatting Lines
	Changing and Removing the Fill Colour
	Changing the Font Colour
	Deleting an Object

Using Additional Effects and Objects

	Adding a 3-D Effect
	Applying a 3-D Setting
	Adding a Shadow
	Drawing a Text Box
	Drawing an Arrow
	Inserting Pictures
	Formatting Graphics

Using AutoShapes and Diagrams

	Working with AutoShapes
	Drawing a Callout
	Drawing a Basic Shape
	Drawing a Connector
	Drawing a Flowchart Shape
	Drawing a Block Arrow
	Inserting a Diagram
	Working with Diagrams

Using HTML Files

	Previewing a Web Page
	Creating a Hyperlink
	Editing a Hyperlink
	Saving a Worksheet as a Web Page
	Using Publishing Options
	Opening an HTML File

Working with Comments

	Creating Comments
	Viewing a Comment
	Using the Reviewing Toolbar
	Printing Comments
	Responding to Discussion Comments

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