Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


Providing the same concepts as delivered in level one, focusing on the new user with little to no experience with computers.


 
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
Pre-Requisites

New User

Certificates offered

MANUALS / CERTIFICATES
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
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.
BREAKS AND LUNCH
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.
REFRESHMENTS
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 ]

Reviews
 

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.

need-to-train-a-group-banner

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 213 times.