Provides competency in creating workbooks, modifying worksheets, formatting worksheets and printing worksheets.
- Course Outline
Unit 1 : Getting started
Topic A: 0 Spreadsheet terminologyA-1: Discussing spreadsheet terminology
Topic B: 0 Exploring the Excel windowB-1: Starting Excel
Topic C: 0 Getting helpC-1: Using the Ask a Question box
Topic D: 0 Opening and navigating workbooksD-1: Opening a workbook
Topic E: 0 Closing workbooksE-1: Closing a workbook and Excel
Unit 2 : Entering and editing data
Topic A: 0 Creating workbooksA-1: Creating a default Excel workbook
Topic B: 0 Entering and editing labels and valuesB-1: Entering labels and values
Topic C: 0 Entering and editing formulasC-1: Entering a formula by typing
Topic D: 0 Saving and updating workbooksD-1: Saving a workbook
Unit 3 : Modifying a worksheet
Topic A: 0 Moving and copying dataA-1: Moving data in a worksheet
Topic B: 0 Moving and copying formulasB-1: Using shortcut menus to move formulas
Topic C: 0 Using absolute referencesC-1: Observing the limitations of relative references
Topic D: 0 Inserting and deleting rangesD-1: Inserting a range
Unit 4 : Using functions
Topic A: 0 Entering functionsA-1: Entering a SUM function
Topic B: 0 Using AutoSumB-1: Using the AutoSum button
Topic C: 0 Using AVERAGE, MIN, and MAXC-1: Using AVERAGE
Unit 5 : Formatting worksheets
Topic A: 0 Formatting textA-1: Formatting text by using the toolbar
Topic B: 0 Formatting rows and columnsB-1: Changing column widths and row heights
Topic C: 0 Number formattingC-1: Using the Formatting toolbar to format numbers
Topic D: 0 Using Format Painter and AutoFormatD-1: Copying and clearing formatting
Unit 6 : Printing
Topic A: 0 Preparing to printA-1: Checking spelling in a worksheet
Topic B: 0 Page Setup optionsB-1: Setting page orientation
Topic C: 0 Printing worksheetsC-1: Printing a worksheet
Unit 7 : Creating charts
Topic A: 0 Chart basicsA-1: Creating a chart
Topic B: 0 Modifying chartsB-1: Changing a chart type
Topic C: 0 Printing chartsC-1: Printing a chart
Unit 8 : Web features
Topic A: 0 Saving workbooks as Web pagesA-1: Saving a workbook
Topic B: 0 HyperlinksB-1: Inserting and editing hyperlinks
Topic C: 0 Sending workbooks via e-mailC-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
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 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.
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 340 times.