Sterling Computer Courses

Microsoft Excel 2003 - Level 3

Duration: Approx. 6 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 Microsoft Office Excel 2003 Level 3 course teaches students a set of expert-level spreadsheet features. Students will learn how to summarize, outline, and subtotal list data, as well as how to use named ranges, list ranges, and Lookup Functions. They will apply conditional formatting and data validation. They will import and export data, and learn how to use XML to share, map, and reuse data. They will also discover how to create, format, and modify PivotTables and PivotCharts to see just the information they need. They will use various worksheet auditing and analysis tools, such as Evaluate Formula, Watch Window, Solver, and scenarios. They will also create and remove custom filters, work with shared workbooks, protect workbooks, 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.

Learn To:

This course covers the following topics:

Protect Workbooks

Record Macros

Locate Errors In Formulas

Consolidate Data From Several Worksheets

Create Shared Workbooks

Create Templates

Evaluate A Nested Formula

Watch All Cells With Formulas

Group And Outline Structured Data

Merge Workbook Revisions

Protect And Unprotect Cells And Worksheets

Run Macros

Change Security Levels For Macros

Understand Editing Macros

Add And Remove Buttons From Toolbars

Add Custom Menus

Add Subtotals To Worksheets

Create And Remove Custom Filters

Use The Histogram Analysis Tool

Create Scenarios

Use Solver

Create and Modify List Ranges

Create And Apply Custom Number Formats

Apply Conditional Formatting

Add Data Validation Criteria To Cells

Modify Default Font Settings

Edit Templates

Create New Workbooks Based on User-defined Templates

Modify Workbook Properties

Change The Default Template And Modify Template Settings

Create Named Ranges

Use Named Ranges In Formulas

Format PivotTables

Show And Hide Information In PivotTables

Import Data From Text Files

Link To Web Page Data

Publish Excel Worksheets To The Web

Examine XML In Microsoft Office Excel 2003

Use XML to Share Excel Data

Add, Modify, And Delete Maps

Understand Pivot Tables

Use Lookup Functions

Export Excel Data To Other Applications

Create PivotTables

Crop And Rotate Graphics

Circle Invalid Data

Use Database Functions

Track Changes

Add, Hide, and Show Detail Information In PivotTables

Preview And Save PivotTables As Interactive Web Pages

Create PivotCharts

Set The Default Number Of Worksheets

Accept Or Reject Changes

Control Image Contrast And Brightness

Scale And Resize Graphics

Apply Formats To Data Series

Explore Formula Auditing

Trace Precedents

Trace Dependents

Objectives:

This course introduces the student to the advanced concepts of Excel 2003.

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