Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

Provides competency in creating workbooks, modifying worksheets, formatting worksheets and printing worksheets.

Course Outline

             Unit 1 :           Getting started

           Topic A: 0   Spreadsheet terminology

           A-1:           Discussing spreadsheet terminology


           Topic B: 0   Exploring the Excel window

           B-1:           Starting Excel


           B-2:           Examining Excel window components


           Topic C: 0   Getting help

           C-1:           Using the Ask a Question box


           C-2:           Working with the Office Assistant


           C-3:           Using the Help task pane


           Topic D: 0   Opening and navigating workbooks

           D-1:           Opening a workbook


           D-2:           Navigating a worksheet


           Topic E: 0   Closing workbooks

             E-1:             Closing a workbook and Excel


             Unit 2 :           Entering and editing data

           Topic A: 0   Creating workbooks

           A-1:           Creating a default Excel workbook


           Topic B: 0   Entering and editing labels and values

           B-1:           Entering labels and values


           B-2:           Editing a label


           B-3:           Finding and replacing


           Topic C: 0   Entering and editing formulas

           C-1:           Entering a formula by typing


           C-2:           Using the mouse to enter cell references


           C-3:           Editing a formula          


           Topic D: 0   Saving and updating workbooks

             D-1:             Saving a workbook


             D-2:             Changing and updating a workbook


             Unit 3 :           Modifying a worksheet

           Topic A: 0   Moving and copying data

           A-1:           Moving data in a worksheet


           A-2:           Copying data in a worksheet


           A-3:           Moving data by using the drag-and-drop method


           A-4:           Copying data by using the drag-and-drop method


           A-5:           Copying data by using the Clipboard


           Topic B: 0   Moving and copying formulas

           B-1:           Using shortcut menus to move formulas


           B-2:           Copying a formula


           B-3:           Using the fill handle to copy formulas


           Topic C: 0   Using absolute references

           C-1:           Observing the limitations of relative references


           C-2:           Using absolute references


           Topic D: 0   Inserting and deleting ranges

             D-1:             Inserting a range


             D-2:             Inserting a row


             D-3:             Deleting a range


             Unit 4 :           Using functions

           Topic A: 0   Entering functions

           A-1:           Entering a SUM function


           A-2:           Using the mouse to enter a function argument


           A-3:           Inserting a SUM function


           Topic B: 0   Using AutoSum

           B-1:           Using the AutoSum button


           B-2:           Using AutoSum to enter several SUM functions


           Topic C: 0   Using AVERAGE, MIN, and MAX

             C-1:             Using AVERAGE


             C-2:             Using MIN


             C-3:             Using MAX


             Unit 5 :           Formatting worksheets

           Topic A: 0   Formatting text

           A-1:           Formatting text by using the toolbar


           A-2:           Formatting a non-contiguous range


           A-3:           Using the Format Cells dialog box to format text


           Topic B: 0   Formatting rows and columns

           B-1:           Changing column widths and row heights


           B-2:           Setting alignment


           B-3:           Applying borders to ranges


           B-4:           Using the border-drawing pencil


           Topic C: 0   Number formatting

           C-1:           Using the Formatting toolbar to format numbers


           C-2:           Exploring the Number tab


           C-3:           Creating a conditional format


           Topic D: 0   Using Format Painter and AutoFormat

             D-1:             Copying and clearing formatting


             D-2:             Using the AutoFormat dialog box to format a range


             D-3:             Using Find and Replace to change cell formats


             Unit 6 :           Printing

           Topic A: 0   Preparing to print

           A-1:           Checking spelling in a worksheet


           A-2:           Using the Research task pane


           A-3:           Previewing a worksheet


           Topic B: 0   Page Setup options

           B-1:           Setting page orientation


           B-2:           Setting margins


           B-3:           Creating custom headers and footers


           B-4:           Displaying gridlines and observing sheet options


           Topic C: 0   Printing worksheets

             C-1:             Printing a worksheet


             C-2:             Working with the print area


             Unit 7 :           Creating charts

           Topic A: 0   Chart basics

           A-1:           Creating a chart


           A-2:           Examining chart elements


           A-3:           Creating an embedded chart


           Topic B: 0   Modifying charts

           B-1:           Changing a chart type


           B-2:           Formatting chart elements


           B-3:           Modifying an embedded chart


           Topic C: 0   Printing charts

             C-1:             Printing a chart


             Unit 8 :           Web features

           Topic A: 0   Saving workbooks as Web pages

           A-1:           Saving a workbook


           A-2:           Using the Publish as Web Page dialog box


           Topic B: 0   Hyperlinks

           B-1:           Inserting and editing hyperlinks


           Topic C: 0   Sending workbooks via e-mail

   C-1:   Using e-mail to share a workbook


   Appendix A :           Instant messaging

           Topic A: 0   Instant messages

   Appendix B :           Alternative user input

           Topic A: 0   Speech recognition

           Topic B: 0   Handwriting recognition

   Appendix C :           MOS exam objectives map

           Topic A: 0   Core exam objectives

           Topic B: 0   Expert exam objectives

Prerequisites & Certificates

Windows 2000: Basic

Certificates offered

All program fees include a manual on CD complete with self study lessons. Course manuals can be purchased for an additional fee and are dependent on subject and level. The manual fee is a passed through cost to our clients.
Upon completion of the each program each participant will receive a certificate of completion.
Parking is available for our students at the rear of the building.Please, donít park in the reserved parking spaces around the building, your car will be tagged and/or towed away.
Our courses run between 9:00AM Ė 4:00PM. There are two 15 minutes coffee breaks: one at 10:30AM and the other are at 2:30PM. The lunch break is between 12:00AM and 1:00PM.
Coffee and suitable drinks are provided by us during the course. There are numerous restaurants and take-out places in the area, or you may prefer to bring your own lunch and enjoy it on site. Microwave and fridge available.

Cancellation Policy
Commitment of resources and industry standards require that we be notified of any cancellation. As such, you may reschedule any training course up to five (5) working days before the actual training date. Simply call us, and we send you a new registration confirmation without extra charge. If training is rescheduled less than five (5) working days before the training date, a rescheduling fee of 50% of the course fee will be invoiced.

The latest time we accept rescheduling is until noon on the working day before
the training date. "No-shows" without prior notification are charged as if you had attended the course. There are no refunds. We reserve the right to cancel any course and reschedule if attendance is not sufficient to run the course. In this case you will be notified, usually five (5) working days or more prior to the
training day and the training is rescheduled.

Map & Reviews
Careers in Transition
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.


This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 361 times.