Excel 97 - 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: This course introduces the skills necessary to organise Excel information including using styles, custom formats, templates; consolidating worksheets, working with comments and sharing workbooks. You will learn how to use the auditing tools and report manager, advanced charting skills for modifying charts.

The advanced course introduces the skills necessary for creating and using pivot tables (used for summarising large amounts of data) and includes formatting pivot tables and using pivot table calculations. Finally you will learn the basics of using a macro, creating a macro button and custom menus.

Using Styles and Custom Formats

Using, applying, creating, modifying and merging styles; creating a style by example; creating a custom format.

Using Templates

	Working with, saving, using and editing templates
	Inserting new worksheets
	Creating default templates

Consolidating Worksheets

Consolidate worksheets by category and by position

Working with Comments

	Creating, viewing, editing, showing, hiding, deleting and printing comments
	Viewing all comments; using the Reviewing toolbar

Using Auditing Tools

	Displaying the Auditing Toolbar
	Displaying and removing dependents and precedents
	Removing Tracer Arrows and tracing errors

Using the Report Manager

	Using the Report Manager and worksheets in a report
	Printing and creating a Report

	Using a Scenario and a view in a Report
	Reordering Sections in a Report

Sharing Workbooks

	Introduction to Shared Workbooks; saving a shared workbook; viewing users and changes
	Displaying comment boxes, changing the update frequency, highlighting changes
	Managing and resolving conflicting changes, setting the change History options, creating the History worksheet
	Reviewing tracked changes
	Merging shared workbook files

Modifying Charts

	Creating, applying and deleting user-defined charts
	Changing the data source; editing text/axis titles; adding unlinked text; removing/adding axes labels
	Using and disabling the time-scale axis
	Using the chart Range Finder
	Moving a legend; adding data labels and tables

Working with Chart Data Series

	Adding and deleting a data series
	Adding data series/multiple worksheets, editing data series names, changing data series types
	Adding a trendline, charting non-adjacent ranges

Creating/Revising Pivot Tables

	Creating a Pivot Table
	Changing the source range, inserting into and deleting from the source range

Adding Pivot Table Fields

Adding row, page and column fields; moving and deleting pivot table fields

Formatting Pivot Tables

	Using Enable Selection, selecting pivot table parts
	Formatting a pivot table and numbers
	Using the Autoformat feature, Pivot Table options and disabling Preserve formatting

Using Pivot Table Calculations

Adding other summary fields, changing the summary function, creating and changing a custom calculation

Creating a calculated field and item

Using Multiple Ranges

	Selecting the Type of Page fields
	Multiple source ranges, Field1 and Field2 ranges
	Displaying the pivot table; renaming custom page fields; using the consolidated table

Using Macros

	Defining and running macros
	Opening a macro workbook and the Visual Basic editor; using a shortcut key

Recording Macros

Recording a macro, assigning a shortcut key

	Using relative references
	Assigning a macro to a menu, deleting a macro from a menu

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