Sterling Computer Courses

Microsoft Excel 2007 - Level 2

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 course familiarizes students with intermediate-level spreadsheet features. Students will learn how to convert older workbooks to the new default XML-based file format; customize the Quick Access toolbar; use logical and financial functions; format worksheets using themes, styles, and page breaks; use 3-D references; ready workbooks for the Web; use templates to create workbooks; and insert and manipulate objects such as shapes and SmartArt diagrams into a spreadsheet. They will also learn how to customize workbooks by renaming worksheets; inserting, deleting, and hiding worksheets; and changing the color of worksheet tabs. In addition, the course points out how tables in Excel serve as databases and covers how to convert data ranges into tables, apply table styles, freeze and unfreeze rows and columns, sort tables, and use filters in tables.

Learn To:

This course covers the following topics:

Rename Worksheets

Change Worksheet Tab Colors

Select And Move Sets Of Worksheets

Copy Worksheets

Insert And Delete Worksheets

Hide And Unhide Worksheets

Use Save As

Rename Folders While Saving

Learn About Database Features

Find And Replace Cell Contents

Freeze And Unfreeze Rows

Freeze And Unfreeze Columns

Hide And Unhide Rows And Columns

Sort Lists In Descending Order

Sort Lists In Ascending Order

Understand Filters

Use AutoFilter

Understand Inserting Functions

Explore Logical Functions

Use The IF Function

Use The OR Function

Learn About Financial Functions

Use The FV Function

Use The PMT Function

Use The NOW Function

Understand AutoFormatting

Apply AutoFormats

Modify AutoFormats

Define Styles

Apply And Remove Styles

Indent Text

Rotate Text

Insert And Preview Page Breaks

Modify And Remove Page Breaks

Find And Replace Cell Formats

Understand Inserting Objects

Insert Graphics

Move And Delete Graphics

Create And Modify Graphics

Add Comments

Edit And Remove Comments

Understand 3-D References

Link Worksheets Using 3-D References

Split And Arrange Workbooks

Link Workbooks Using 3-D References

Look At Online Information And The Web

Understand Hyperlinks

Create And Edit Hyperlinks

Use Web Page Preview

Save Worksheets As Web Pages

Save Workbooks As Web Pages

Examine The Research Tool

Insert Supporting Information Into Worksheets

Explore Templates

Create Workbooks Based On Templates

Create New Templates

Objectives:

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

Customize workbooks

Use database features in Excel

Work with functions

Format worksheets with AutoFormat and styles

Add and manipulate objects in worksheets

Link worksheets and workbooks with 3-D references

Use existing templates and create new ones

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