Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

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 options

                               A-1:                               Zooming in and out on a large worksheet


                               A-2:                               Using the Freeze Panes command


                               A-3:                               Splitting a worksheet into panes


                               Topic B: 0  Hiding, displaying, and outlining data

                               B-1:                               Hiding and unhiding columns and worksheets


                               B-2:                               Creating an outline


                               Topic C: 0  Printing large worksheets

                         C-1:                         Setting print titles


                         C-2:                         Setting page breaks


                         C-3:                         Using Page Break Preview


                         Unit 2 :  Using multiple worksheets and workbooks

                               Topic A: 0  Using multiple worksheets

                               A-1:                               Navigating between multiple worksheets


                               A-2:                               Naming worksheets and coloring tabs


                               A-3:                               Working with multiple worksheets


                               A-4:                               Previewing and printing multiple worksheets


                               Topic B: 0  Linking worksheets by using 3-D formulas

                               B-1:                               Creating 3-D formulas


                               B-2:                               Adding a Watch window


                               Topic C: 0  Consolidating data

                               C-1:                               Using the Consolidate command


                               Topic D: 0  Linking workbooks

                               D-1:                               Switching between workbooks


                               D-2:                               Examining external links in a worksheet


                               D-3:                               Creating external links in a worksheet


                               D-4:                               Editing links


                               Topic E: 0  Managing workbooks

                         E-1:                         Creating a workspace


                         Unit 3 :  Customizing Excel

                               Topic A: 0  Using the Options dialog box

                               A-1:                               Changing view options


                               A-2:                               Changing general options


                               A-3:                               Changing calculation options


                               Topic B: 0  Customizing toolbars and menus

                         B-1:                         Showing and hiding toolbars


                         B-2:                         Moving and docking toolbars


                         B-3:                         Customizing and restoring toolbars


                         B-4:                         Customizing a menu


                         B-5:                         Exploring short menus and smart menus


                         Unit 4 :  Advanced formatting

                               Topic A: 0  Borders and shading

                               A-1:                               Adding borders to a cell or range


                               A-2:                               Adding shading to a cell or range


                               Topic B: 0  Using special number formats

                               B-1:                               Using special formats


                               B-2:                               Controlling the display of zero values


                               B-3:                               Creating custom formats


                               B-4:                               Applying conditional formatting


                               Topic C: 0  Working with dates

                               C-1:                               Using date and time formats


                               C-2:                               Using the NOW and DATE functions


                               C-3:                               Performing calculations on dates


                               Topic D: 0  Working with styles

                               D-1:                               Observing built-in styles


                               D-2:                               Creating and applying styles


                               D-3:                               Modifying styles


                               Topic E: 0  Other advanced formatting

                         E-1:                         Merging cells


                         E-2:                         Changing a cell\'s orientation


                         E-3:                         Splitting cells


                         Unit 5 :  List management

                               Topic A: 0  Examining lists

                               A-1:                               Examining the structure of a list


                               Topic B: 0  Sorting and filtering lists

                               B-1:                               Sorting a list by using the Standard toolbar


                               B-2:                               Sorting a list by using the Sort command


                               B-3:                               Filtering a list by using AutoFilter


                               Topic C: 0  Advanced filtering

                         C-1:                         Using the Custom AutoFilter criteria


                         C-2:                         Using the Advanced Filter dialog box


                         C-3:                         Copying filtered results to another range


                         Unit 6 :  Advanced charting

                               Topic A: 0  Chart formatting options

                               A-1:                               Adjusting the scale of a chart


                               A-2:                               Formatting a data point


                               Topic B: 0  Using combination charts

                               B-1:                               Creating a combination chart


                               B-2:                               Creating a trendline


                               Topic C: 0  Using graphic elements

                         C-1:                         Adding graphic elements


                         C-2:                         Formatting a graphic element


                         C-3:                         Adding a picture to a worksheet


                         Unit 7 :  Documenting and auditing

                               Topic A: 0  Auditing features

                               A-1:                               Tracing precedent and dependent cells


                               A-2:                               Tracing errors


                               Topic B: 0  Comments and text boxes

                               B-1:                               Viewing comments in a worksheet


                               B-2:                               Adding a comment


                               B-3:                               Managing comments


                               B-4:                               Creating a text box


                               Topic C: 0  Protection

                               C-1:                               Password-protecting a worksheet


                               C-2:                               Protecting part of a worksheet by unlocking cells


                               C-3:                               Discussing digital signatures


                               Topic D: 0  Workgroup collaboration

                         D-1:                         Sharing a workbook


                         D-2:                         Merging workbooks


                         D-3:                         Tracking changes in a workbook


                         Unit 8 :  Using templates

                               Topic A: 0  Built-in templates

                               A-1:                               Using the Sales Invoice template


                               A-2:                               Using the ExpenseStatement template


                               Topic B: 0  Creating and managing templates

               B-1:               Creating a template


               B-2:               Modifying a template


               B-3:               Using an alternate template location


               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

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