Provides competency in organizing, modifying, consolidating and protecting data from multiple worksheets, working with advanced functions, formatting and charts.
- Course Outline
This course provides competency in organizing and consolidating data from multiple worksheets, adjusting the screen display, working with advanced functions, using advanced formatting features, using advanced print options, filtering data, using comments, naming worksheet ranges and formulas, creating and modifying charts, protecting data, importing and exporting data, saving worksheets and workbooks as Web pages, and publishing worksheets and workbooks to the Web.
Unit 1 : Working with large worksheets
Topic A: 0 Viewing optionsA-1: Zooming in and out on a large worksheet
Topic B: 0 Hiding, displaying, and outlining dataB-1: Hiding and unhiding columns and worksheets
Topic C: 0 Printing large worksheetsC-1: Setting print titles
Unit 2 : Using multiple worksheets and workbooks
Topic A: 0 Using multiple worksheetsA-1: Navigating between multiple worksheets
Topic B: 0 Linking worksheets by using 3-D formulasB-1: Creating 3-D formulas
Topic C: 0 Consolidating dataC-1: Using the Consolidate command
Topic D: 0 Linking workbooksD-1: Switching between workbooks
Topic E: 0 Managing workbooksE-1: Creating a workspace
Unit 3 : Customizing Excel
Topic A: 0 Using the Options dialog boxA-1: Changing view options
Topic B: 0 Customizing toolbars and menusB-1: Showing and hiding toolbars
Unit 4 : Advanced formatting
Topic A: 0 Borders and shadingA-1: Adding borders to a cell or range
Topic B: 0 Using special number formatsB-1: Using special formats
Topic C: 0 Working with datesC-1: Using date and time formats
Topic D: 0 Working with stylesD-1: Observing built-in styles
Topic E: 0 Other advanced formattingE-1: Merging cells
Unit 5 : List management
Topic A: 0 Examining listsA-1: Examining the structure of a list
Topic B: 0 Sorting and filtering listsB-1: Sorting a list by using the Standard toolbar
Topic C: 0 Advanced filteringC-1: Using the Custom AutoFilter criteria
Unit 6 : Advanced charting
Topic A: 0 Chart formatting optionsA-1: Adjusting the scale of a chart
Topic B: 0 Using combination chartsB-1: Creating a combination chart
Topic C: 0 Using graphic elementsC-1: Adding graphic elements
Unit 7 : Documenting and auditing
Topic A: 0 Auditing featuresA-1: Tracing precedent and dependent cells
Topic B: 0 Comments and text boxesB-1: Viewing comments in a worksheet
Topic C: 0 ProtectionC-1: Password-protecting a worksheet
Topic D: 0 Workgroup collaborationD-1: Sharing a workbook
Unit 8 : Using templates
Topic A: 0 Built-in templatesA-1: Using the Sales Invoice template
Topic B: 0 Creating and managing templatesB-1: Creating a template
Appendix A : Web discussions
Topic A: 0 Creating and responding to Web discussions
Appendix B : MOS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
- Prerequisites & Certificates
Excel 2003: 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 561 times.