Home PC Basics Microsoft Office Microsoft Outlook Misc. Contact Us

Sterling Computer Courses

*

Microsoft Excel 2002 - 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.

Screenshot - Click Me Screenshot - Click Me Screenshot - Click Me

Overview:

This course introduces students to basic spreadsheet features and acquaints students with Microsoft Excel 2002 tools by using real-life scenarios and projects. Students will learn to manage workbooks, work with cells and cell data, format and print worksheets, create and revise formulas, and create charts from worksheet data. Students will also become familiar with Excel's introductory-level new features, such as smart tags and speech recognition.

Learn To:

This course covers the following topics:

  • Understand Excel 2002
  • Open Excel
  • Look At The Office Assistant
  • Disable The Office Assistant
  • Examine The Excel Window
  • Understand Smart Tags
  • Open Workbooks
  • View Worksheets
  • Go To Specific Cells
  • Save Workbooks In New Folders
  • Close Workbooks
  • Use The Task Pane To Create Workbooks
  • Enter Cell Content
  • Edit Cell Content
  • Check Spelling
  • Insert And Delete Cells
  • Merge And Split Cells
  • Insert And Delete Columns And Rows
  • Modify Column Width And Row Height
  • Look At The Clipboard Task Pane
  • Examine Cut, Copy, and Paste
  • Cut And Paste Data
  • Copy And Paste Data
  • Use Paste Special
  • Move Cells And Ranges
  • Understand Fills
  • Fill A Series
  • Fill By Example
  • Understand Formulas
  • Understand Cell References
  • Use Cell References In Formulas
  • Enter A Formula In The Formula Bar
  • Copy And Edit Formulas
  • Understand Functions
  • Build Functions
  • Look At Function Argument ScreenTips
  • Use AutoSum And AutoCalculate
  • Calculate Sums Using The Insert Function
  • Calculate Averages Using The Insert Function
  • Create Minimum Functions
  • Create Maximum Functions
  • Understand Date And Number Formatting
  • Format Numbers
  • Change Text Alignment
  • Wrap Text Within Cells
  • Modify Text Appearance
  • Apply Shading
  • Use The Format Painter
  • Use Border Drawing
  • Examine Charts
  • Use The Chart Wizard
  • Change Chart Types
  • Elevate, Rotate, Resize, And Position Charts
  • Edit And Resize Chart Titles
  • Understand Printing
  • Preview Worksheets
  • Change Page Orientation And Scaling
  • Set Page Margins And Alignment
  • Create Headers And Footers
  • Select Print Options
  • Set, Print, And Clear Print Areas
  • Print Selections
  • Print Worksheets And Workbooks
  • Examine The Ask A Question Feature
  • Ask Help A Question
  • Use The Answer Wizard
  • Use The Help Mouse Pointer


    • Objectives:

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

  • Work with cells, rows, and columns
  • Move and copy data
  • Explore cell references and formulas
  • Work with charts
  • Format cell and cell content


    • 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.

    Existing customer username (e.g.C4U9283479)


    Related Links:

    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