Sterling Computer Courses

Microsoft Excel 2000 - 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:

Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and filter lists, and import and export data. In addition, students will be taught how to use PivotTables, PivotCharts, and data analysis tools and how to merge and link workbooks. In teaching how to share workbooks, the importance of proper management and password protection is stressed.

Learn To:

This course covers the following topics:

Understanding Relational Databases

Understanding Lists

Selecting Cells

Understanding Pivot Tables

Import data from text files - drag-and-drop

Import data from text files - insert

Import from other applications

Import a table from an HTML file (insert, drag and drop - including HTML round tripping)

Export to other applications

Apply templates

Edit templates

Create templates

Using a workspace

Link workbooks

Apply number formats (accounting, currency, number)

Create custom number formats

Use conditional formatting

Print and preview multiple worksheets

Use the Report Manager

Add and delete a named range

Use a named range in a formula

Use Lookup Functions (Hlookup or Vlookup)

Hide and display toolbars

Customize a toolbar

Assign a macro to a command button

Record macros

Run macros

Edit macros

Work with the Auditing Toolbar

Trace errors (find and fix errors)

Trace precedents (find cells referred to in a specific formula)

Trace dependents (find formulas that refer to a specific cell)

Apply conditional formats

Perform single and multi-level sorts

Use grouping and outlines

Use data forms

Use subtotaling

Apply data filters

Extract data

Query databases

Use data validation

Use PivotTable autoformat

Use Goal Seek

Create pivot chart reports

Work with Scenarios

Use Solver

Use data analysis and PivotTables

Create interactive PivotTables for the Web

Add fields to a PivotTable using the Web browser

Create, edit and remove a comment

Apply and remove worksheet and workbook protection

Change workbook properties

Apply and remove file passwords

Track changes (highlight, accept, and reject)

Create a shared workbook

Merge workbooks

Creating Pivot Tables

Publish An Interactive Pivot Table To The Web

Objectives:

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

Use data forms and named ranges

Apply data filters and use macros

Import and export data to and from databases and HTML

Use data analysis tools like solver, scenarios, and goal seek

Protect, share, and manage workbooks

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