Sterling Computer Courses

Microsoft Excel 2002 - Level 3

Duration: Approx. 5 hours.

This product is an online product and is a Single user, 1 Year licence.

Screenshots:

(click on a screenshot for a bigger picture) Images are representative of this product.

Overview:

This course teaches students a set of expert-level spreadsheet features. Students will learn about summarizing list data with outlining and subtotals, and they will learn how to create and remove custom filters; techniques for working with shared workbooks, including protecting workbooks from changes; track and review changes; and merge and consolidate data from worksheets. Finally, students will learn how to customize the Excel working screen with custom toolbars, menus, and macros. The material is presented through explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered.

Learn To:

This course covers the following topics:

Create Templates

Edit Templates

Create New Workbooks Based On User-defined Templates

Create Named Ranges

Use Named Ranges In Formulas

Delete Named Ranges

Use Lookup Functions

Create And Apply Custom Number Formats

Apply Conditional Formatting

Add Data Validation Criteria To Cells

Import Data From Text Files

Import Data From Web Pages

Become Familiar With XML

Create Web Queries

Export Excel Data To Other Applications

Publish Excel Worksheets To The Web

Use XML To Share Excel Data

Understand PivotTables

Create PivotTables

Format PivotTables

Show And Hide Information In PivotTables

Add, Hide, And Show Detail Information In PivotTables

Preview And Save PivotTables As Interactive Web Pages

Create PivotCharts

Explore The Formula Auditing Toolbar

Trace Precedents

Trace Dependents

Locate Errors In Formulas

Remove Tracer Arrows

Create Trendlines

Create Scenarios

Understand Outlining

Group And Outline Structured Data

Add Subtotals To Worksheets

Create And Remove Custom Filters

Create Workspaces With Multiple Workbooks

Consolidate Data From Several Worksheets

Understand Sharing

Create Shared Workbooks

Track Changes

Accept Or Reject Changes

Merge Workbook Revisions

Remove Sharing

Protect And Unprotect Worksheets

Protect Workbooks

Record Macros

Run Macros

Understand Editing Macros

Add And Remove Buttons From Toolbars

Add Custom Menus

Objectives:

Once you have completed this course, you will be able to:

Work with named ranges

Import and export data

Use PivotTables and PivotCharts

Audit and analyze worksheets

Summarize data

Price:

~~Normal Price: £80.00 (excl. VAT)~~

Special Offer Price: £50.00 (excl. VAT)

YOU SAVE: £30.00 (37.5%)

To purchase this online course, click the "Buy Now" button below. If you have bought a course from us before please enter your username before clicking "Buy Now". If you are a new customer, leave this field blank.

General:

Home Course Log-in Instructions Contact Us

Online Course Categories:

PC Basics Microsoft Office Microsoft Outlook Misc.

Sister Sites:

Associated Training Corporate Site Associated Training Associated E-Training Sterling Safety Training Sterling Financial Training UK Business Training Sterling Languages Sales Training Courses UK Management Training Courses UK Communication Skills Training Media First

To contact us, please e-mail: contact@sterlingcomputercourses.co.uk

Sterling Computer Courses.co.uk is a division of:

Sterling Consultancy (UK) Ltd
10 Wheatcroft Business Park
Landmere Lane, Edwalton
Nottingham
NG12 4DG

Telephone: 0115 984 9940 | Fax: 0115 921 5352