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

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

Excel 2003: Basic

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