Microsoft Office 2003 Courses

MS Office:  2003 or 2007?

What version of MS Office is right for you?

Courses are clearly marked as to what version of Microsoft Office is used in that class, 2003 or 2007. Be sure to register for a class using the correct version for you. Choose the version that is on the computer you plan to use. If you are preparing for a new job, find out what version the company is using.

MICROSOFT OFFICE 2003 COURSES

CC 397   Word 2003 - Level  I               6 hours                       $105

Learn to Create, Edit, Save, and Print documents. Use Spell Check, Tabs, Fonts, Indents, and Bullets. Set Margins, Page Breaks, and create Page Numbers, Envelopes, and Mailing Labels.

Prerequisite:  Intro to PC & Windows or equivalent experience.

001  1/29/08-1/31/08      T/Th        6:30-9:30pm       E-112            Gladys Ravettine

002  2/22/08                   F             9:30am-4:30pm  CLC-235       Marion Keegan

003  3/04/08-3/06/08      T/Th        6:30-9:30pm       E-112            Diane Kerner

004  4/08/08-4/10/08      T/Th        9:30am-12:30pm                     E-112         Marion Keegan

CC 467   Mail Merge            2003                                       3 hours                       $58

Create and import data for merging letters, mailing labels, envelopes, etc. Also create various directories for attractive and useful printed reports of the data itself. Prerequisite:  Word I or equivalent experience.

001  4/18/08             F             9:30am-12:30pm   CLC-235       Marion Keegan

CC 398   Word 2003 - Level  II                    6 hours                       $105

 Tables, Headers and Footers, Hanging Indents, Borders and Shading. Use Sort, Find and Replace, ClipArt, WordArt and Drawing Tools.

Prerequisite:  Word I or equivalent experience.

001  2/12/08-2/13/08      T/W        6:30-9:30pm          E-112         Gladys Ravettine

002  3/14/08                   F             9:30am-4:30pm     CLC-235    Marion Keegan

CC 399   Word 2003  Level III                  6 hours                       $105

Set up Columns and use section breaks. Create Templates and Macros. Customize Toolbars and develop Fill-In Forms.

Prerequisite:  Word II or equivalent experience.

001  5/02/08                F             9:30am-4:30pm     CLC-235          Marion Keegan
 

CC 400   Excel 2003  Level I                  6 hours                       $105

Learn to create, edit, save and print spreadsheets; use AutoSum, AutoFill. Develop formulas and simple functions to do calculations. Format text data, numbers and dates. Use Page Setup for Margins, Headers and Footers, and to learn Printing techniques.

Prerequisite:  Intro to PC & Windows or equivalent experience.

001  1/22/08-1/24/08      T/Th        6:30-9:30pm         E-112        Diane Kerner

002  1/23/08                   W            9:30am-4:30pm   E-112        Marion Keegan

003  2/29/08                   F             9:30am-4:30pm   CLC-235    Marion Keegan

004  3/11/08-3/13/08      T/Th        6:30-9:30pm         E-112        Diane Kerner

005  4/01/08-4/03/08      T/Th        9:30am-12:30pm   E-112        Marion Keegan

006  5/03/08-5/10/08      Sat          9:30am-12:30pm   C-304       Diane Kerner

001  7/8/08-7/10/08        T/Th        6:30-9:30pm         E-112        Diane Kerner

CC 478   Excel 2003 - Level II                     6 hours                       $105

Review Excel basics and expand your knowledge of formula writing and basic functions: Sum, Average, If, Countif, Sumif and more. Manage sheets and learn to create formulas across multiple sheets. Work efficiently by splitting and freezing windows; hiding columns; creating range names, comments and passwords. Prerequisite:  Excel I plus experience working with Excel.

001  1/30/08                   W            9:30am-4:30pm  E-112         Marion Keegan

002  3/05/08                   W            9:30am-4:30pm  CLC-235    Marion Keegan

003  4/04/08                   F             9:30am-4:30pm  CLC-235    Marion Keegan

004  4/15/08-4/17/08      T/Th        6:30-9:30pm       E-112         Diane Kerner

001  7/29/08-7/31/08      T/Th        6:30-9:30pm       E-112         Diane Kerner

CC 487   Excel 2003 - Charting                   3 hours                       $58

Learn to create and edit Pie Charts, Bar Charts. Learn to format charts, move charts from sheet to sheet and to create your own chart custom templates. Create ˇ°quickˇ± charts with one keystroke.

Prerequisite:  Excel I or equivalent experience.

001  2/25/08                M            10:00am-1:00pm   E-112         Donna Casciano

002  4/01/08                T             6:30-9:00pm          E-112         Diane Kerner

001  7/15/08                T             6:30-9:00pm          E-112         Diane Kerner

CC 488   Excel 2003 - Database       3 hours                                   $58

Explore Excel's database capabilities: learn to sort and filter data, create automatic subtotals. Learn the VLookup function plus other database functions including ways to clean up imported data.

Prerequisite:  Excel I or equivalent experience.

001  2/27/08                W            10:00am-1:00pm      E-112         Donna Casciano

002  4/03/08                Th           6:30-9:30pm             E-112         Diane Kerner

001  7/17/08                Th           6:30-9:30pm             E-112         Diane Kerner

CC 476   Excel 2003 - Macros          3 hours                                   $58
Macros are recordings of keystrokes and mouse actions that can be used to automate repetitive tasks. Macros can be stored and played back at any time. Add buttons to a toolbar for easy playback of general macros that can be used in any workbook. Create buttons within a sheet for playback of macros unique to that book. Prerequisite:  Excel II or Charting and Database.

001  4/11/08                F             9:30am-12:30pm      CLC-235    Marion Keegan

002  5/22/08                Th           6:00-9:00pm             E-112         Donna Casciano

CC 500   Excel 2003 - Pivot Tables              3 hours                       $58

Use Pivot Tables to make large, complex sets of data more comprehensible and easier to understand at a glance. You can quickly change the layout to see limitless views of the data. You can count items, see sums, averages, quickly calculate percentages and more.

Prerequisite:  Excel II or Excel Database or equivalent knowledge.

001  5/29/08                Th           6:00-9:00pm             E-112         Donna Casciano

CC 479   Excel 2003 Level III    Advanced Features      6 hours                 $105

Create Megaformulas and Array Formulas. Learn more advanced functions: Match, Index, Rank, Trend and Frequency. Chart a frequency distribution. Create Combo Boxes and Spinners.

Prerequisite:  Excel II or equivalent experience.

001  5/09/08                   F             9:30am-4:30pm     CLC-235    Marion Keegan

CC 403   Access 2003  Level I               6 hours                       $105

Learn to create, edit and print database tables. Set Properties, Sort and Filter data. Create queries for text, number, date and Yes/No data. Use calculations in queries. Create a Data Entry Form. Create Reports using Wizards; Group data in Reports and set up Mailing Labels.

Prerequisite:  Intro to PC & Windows or equivalent experience.

To learn the full range of skills needed to successfully create a database, it is recommended that students take level II immediately following Access 2003 - Level I.

001  2/12/08-2/14/08         T/Th        10:00am-1:00pm   E-112      Donna Casciano

002  6/02/08-6/04/08         M/W       10:00am-1:00pm   E-112      Donna Casciano

001  8/05/08-8/07/08         T/Th        6:30-9:30pm          E-112      Donna Casciano

CC 404   Access 2003  Level II                   6 hours                       $105

Design complex databases with multiple tables. Use more advanced table properties and OLE and Memo data type fields. Apply Referential Integrity to table relationships. Create Autolookups for Queries and Forms. Create advanced Queries with calculations, conditional calculations, Crosstabs and the Totals tool. Prerequisite:  Access I or comparable experience.

001  2/19/08-2/21/08         T/Th        10:00am-1:00pm   E-112      Donna Casciano

002  6/09/08-6/11/08         M/W       10:00am-1:00pm   E-112      Donna Casciano

CC 507   Access 2003 - Forms                      3 hours                       $58

Learn to create forms for data entry and for lookup, customize and format forms. Develop Forms/Subforms for displaying data from related tables. Insert photos and graphics into forms. Prerequisite:  Access II or comparable experience.

001  3/20/08                Th           10:00am-1:00pm                        E-112         Donna Casciano

CC 508   Access 2003 - Reports                   3 hours                       $58

Learn to create, customize, format and group data in reports. Develop Reports/Subreports for printing data from related tables. Create 2-column reports, use Parameter Queries in reports, and link a report to Excel data. Prepare reports to be used as e-mail attachments. Insert photos and graphics into reports. Prerequisite:  Access II or comparable experience.

001  3/18/08                T             10:00am-1:00pm                        E-112         Donna Casciano

 CC 405   PowerPoint 2003  Level I                   6 hours           $105

Learn to create Text Slides, Charts, and Organizational Charts for presentations. Enhance slides with ClipArt and WordArt. Learn to print Slides and Audience Handouts. Set up a basic Slide Show with Manual or Automatic Advance. Prerequisite:  Intro to PC & Windows or equivalent experience.

001  3/07/08                   F          9:30am-4:30pm        CLC-235    Marion Keegan

002  4/29/08-5/01/08      T/Th     6:30-9:30pm             E-112         Diane Kerner

CC 506   PowerPoint 2003  Level II          3 hours                       $58

Learn to set up Slide Shows, set timings and loop shows. Use Custom Animation, create motion paths and use Action Settings and Action Buttons to create interactive shows. Add sound to animation and insert a CD track to accompany a show. Insert personal photos for a family show.

Prerequisite:  Powerpoint I.

001  4/16/08                W            10:00am-1:00pm   E-112         Donna Casciano

002  6/03/08                T             6:30-9:30pm          CLC-235    Gladys Ravettine