Sterling Computer Courses

Microsoft Excel 2007 - Level 1

Duration: Approx. 7 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 introduces students to Microsoft Office Excel 2007. It covers basic spreadsheet features and acquaints students with Excel's tools. Students will learn to manage workbooks, work with cells and cell data, format and print worksheets, create and revise formulas, work with basic functions, use fills to save data entry time, and create and modify charts from worksheet data. They will also be introduced to the main interface changes of Microsoft Office 2007, such as the Ribbon, Quick Access toolbar, and the Mini toolbar. Finally, students will also learn how to access and use the Excel Help feature.

Learn To:

This course covers the following topics:

Use Border Drawing

Copy And Paste Data

Merge And Split Cells

Use AutoSum And AutoCalculate

Use Paste Special

Use Cell References In Formulas

Apply Shading

Wrap Text Within Cells

Look At The Office Assistant

Use The Task Pane To Create Workbooks

Understand Functions

Ask Help A Question

Use The Format Painter

Modify Column Width And Row Height

Elevate, Rotate, Resize, And Position Charts

Look At The Clipboard Task Pane

Print Selections

Calculate Sums Using The Insert Function

Edit Cell Content

Enter Cell Content

Understand Microsoft Office Excel 2003

Copy And Edit Formulas

Understand Date And Number Formatting

Fill A Series

Examine Charts

Change Page Orientation And Scaling

Look At Function Argument ScreenTips

Close Workbooks

Understand Cell References

Fill By Example

Examine Cut, Copy, And Paste

Calculate Averages Using The Insert Function

Edit And Resize Chart Titles

Format Numbers

Understand Formulas

Cut And Paste Data

Insert And Delete Cells

Build Functions

Select Print Options

Print Worksheets And Workbooks

Change Text Alignment

Save Workbooks In New Folders

Change Chart Types

Set, Print, And Clear Print Areas

Understand Fills

Enter A Formula In The Formula Bar

Open Microsoft Office Excel 2003

Understand Printing

View Worksheets

Set Page Margins And Alignment

Examine The Excel Window

Insert And Delete Columns And Rows

Preview Worksheets

Move Cells And Ranges

Create Minimum Functions

Use The Chart Wizard

Open Workbooks

Create Headers And Footers

Go To Specific Cells

Check Spelling

Create Maximum Functions

Examine The Help Task Pane

Modify Text Appearance

Objectives:

This course introduces the student to the basic concepts of Excel 2007.

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