Microsoft Office 2007 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.

CC 530   Word 2007 – Level I                     6 hours                       $105

Learn to create, edit, spell check, save and print documents. Set Margins, Page Breaks, Page Numbers and change from Portrait to Landscape. Change Fonts, Align Paragraphs. Customize the Quick Access Toolbar for easy access to favorite commands. Prerequisite:  Intro to the PC & Windows or equivalent experience.

001  1/22/08-1/24/08      T/Th        10:00am-1:00pm   E-112         Donna Casciano

002  3/11/08-3/13/08      T/Th        7:00-10:00pm        CLC-235    Susan Rasmussen

003  3/31/08-4/02/08      M/W       10:00am-1:00pm   E-112         Donna Casciano

001  7/15/08                   Tue         9:30am-4:30pm     E-112         Donna Casciano

NEW

CC 535   Word 2007 – Level II                    6 hours                       $105

Learn to create Tables, Headers and Footers, Hanging Indents, Borders and Shading. Use Sort, Find and Replace, ClipArt, WordArt, SmartArt and Drawing Tools. Prerequisite:  Word I or equivalent experience.

001  3/03/08-3/05/08      M/W       10:00am-1:00pm   E-112         Donna Casciano

002  4/15/08-4/17/08      T/Th        6:30-9:30pm          S-343         Gladys Ravettine

003  4/29/08-5/01/08      T/Th        10:00am-1:00pm   E-112         Donna Casciano

001  7/22/08                   Tue         9:30am-4:30pm     E-112+       Gladys Ravettine

CC 545   Mail Merge            2007                                       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  7/8/08               T             10am-1pm             E-112            Donna Casciano

CC 549   Word 2007-Level III                                             6 hours           $105

Set up newspaper style columns and use section breaks for complex page numbering and for mixing Portrait and Landscape pages. Create Templates and Macros and develop fill-in forms. Prerequisite:  Word II or equivalent experience.

001  8/04/08-08/08/08 M/W       10am-1pm             E-112               Donna Casciano

CC 531   Excel 2007 – Level I                                  6 hours           $105

Learn to create, edit, save and print spreadsheets; use AutoSum and AutoFill. Develop formulas and simple functions to do calculations. Format text data, numbers and dates. Set Margins, create Headers and Footers, and learn printing techniques. Use the Quick Access Toolbar for easy access to favorite commands. Prerequisite:  Intro to the PC & Windows or equivalent experience.

001  1/29/08-1/31/08      T/Th        10:00am-1:00pm   E-112         Donna Casciano

002  3/04/08-3/06/08      T/Th        7:00-10:00pm        CLC-235    Susan Rasmussen

003  4/07/08-4/09/08      M/W       10:00am-1:00pm   E-112         Donna Casciano

004  5/20/08-5/22/08      T/Th        7:00-10:00pm        CLC-235    Susan Rasmussen

001  7/16/08                   Wed        9:30am-4:30pm     E-112+       Gladys Ravettine

002  8/05/08-8/07/08      T/Th        7:00-10:00pm        CLC-235    Susan Rasmussen

NEW

CC 536   Excel 2007 – 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  3/10/08-3/12/08      M/W       10:00am-1:00pm   E-112         Donna Casciano

002  5/06/08-5/08/08      T/Th        10:00am-1:00pm   E-112         Donna Casciano

001  7/23/08                   Wed        9:30am-4:30pm     E-112+       Gladys Ravettine

NEW

CC 537    Excel 2007 - 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  5/21/08                   W            10:00am-1:00pm   E-112         Donna Casciano

NEW

CC 538   Excel 2007 - 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  5/28/08                   W            10:00am-1:00pm   E-112         Donna Casciano

CC 546   Excel 2007 - 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  7/10/08                Th           10:00am-1:00pm      E-112         Donna Casciano

CC 547   Excel 2007 - 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  7/24/08                Th           10:00am-1:00pm      E-112         Donna Casciano

CC 548   Excel 2007 – Level III – Advanced Features      6 hours                 $105

Create more complex Megaformulas and Array Formulas. Work with more advanced functions: Match, Index, Rank, Trend and Frequency. Chart a frequency distribution.

Prerequisite:  Excel II or equivalent experience.

001  8/18/08-8/20/08      M/W       10:00am-1:00pm   E-112         Donna Casciano

NEW

CC 539   PowerPoint 2007 – Level I                       6 hours           $105 

Text Slides, Charts, and Organizational Charts for presentations. Enhance slides with ClipArt, WordArt and SmartArt. 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  4/22/08-4/24/08      T/Th        10:00am-1:00pm   E-112         Donna Casciano

001  7/24/08                   Th           9:30am-4:30pm     E-112       Gladys Ravettine

CC 550   PowerPoint 2007 – Slide Show    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  7/31/08                Th           10:00am-1:00pm   E-112         Donna Casciano