Excel 2000 - Advanced

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 2000 is a software application that can be used as a spreadsheet, database, or graphing program. The advanced course introduces the skills necessary to organise Excel information including working with the data series; advanced functions; Using Scenarios and Goal Seeking; Using Auditing Tools; Consolidating Worksheets; Using/Running/Recording Macros; Working with the Data Map; Advanced Charting.

Working with Data Series

	Using the Series Command
	Creating a Linear & Date Series
	Using a Stop Value

Using Advanced Functions

	Using the VLOOKUP; HLOOKUP; IF; ISERROR Functions
	Using an AND/OR Condition with IF
	Using the ROUND Function
	Limiting the Precision of Numbers

Using Scenarios and Goal Seeking

	Using the Scenario Manager
	Creating/Edit/Displaying a Scenario
	Creating a Scenario Summary Report

Using Goal Seek

	Using Data Tables
	Placing Formulas in Data Tables
	Creating a One-Variable Table
	Creating a Two-Variable Table

Using Auditing Tools

	Displaying the Auditing Toolbar
	Displaying/Removing Dependent Arrows
	Displaying/Removing Precedent Arrows
	Removing Tracer Arrows
	Tracing Cells Causing Errors

Consolidating Worksheets

Consolidating by Category/Position

Solving Problems

Using Solver

Saving a Solution as a Scenario

Restoring the Original Values

Changing a Constraint

Creating a Solver Report

Using Scenarios to View Solutions

Using/Running Macros

	Defining Macros
	Opening a Workbook Containing Macros

	Running a Macro
	Using a Shortcut Key
	Using the Visual Basic Toolbar
	Opening the Visual Basic Editor Window
	Using the Visual Basic Editor Window

Recording Macros

	Recording a Macro; Assigning a Shortcut Key
	Using Relative References
	Assigning a Macro to a Menu
	Deleting a Macro

Editing Macros

	Writing a New Macro;
	Entering Macro Comments
	Copying/Editing Macro Commands
	Running a Macro from the Code Window

Modifying Charts

	Adding, Formatting and Removing Gridlines
	Formatting/Scaling an Axis
	Formatting the Data Series
	Adding Data - Different Worksheets
	Using a Secondary Axis
	Changing Data Series Chart Types
	Adding a Trendline
	Charting Non-adjacent Ranges
	Creating an Exploded Pie Chart
	Adjusting the 3-D View
	Creating User-defined Charts

Working with the Data Map

	Using the Data Map
	Organizing the Map Worksheet
	Creating a Basic Map; Refreshing a Map
	Changing the Map Format Type
	Inserting Data into a Map
	Deleting a Chart Format
	Magnifying and Moving a Map
	Printing the Data Map

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