Microsoft Office 2003 CoursesMS 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 - LevelI6 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.
0011/29/08-1/31/08T/Th6:30-9:30pmE-112Gladys Ravettine 0022/22/08F9:30am-4:30pmCLC-235Marion Keegan 0033/04/08-3/06/08T/Th6:30-9:30pmE-112Diane Kerner 0044/08/08-4/10/08T/Th9:30am-12:30pmE-112Marion Keegan CC 467 Mail Merge20033 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.
0014/18/08F9:30am-12:30pmCLC-235Marion Keegan CC 398Word 2003 - LevelII6 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. 0012/12/08-2/13/08T/W6:30-9:30pmE-112Gladys Ravettine 0023/14/08F9:30am-4:30pmCLC-235Marion Keegan CC 399Word 2003 Level III6 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. 0015/02/08F9:30am-4:30pmCLC-235Marion Keegan
CC 400Excel 2003 Level I6 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. 0011/22/08-1/24/08T/Th6:30-9:30pmE-112Diane Kerner 0021/23/08W9:30am-4:30pmE-112Marion Keegan 0032/29/08F9:30am-4:30pmCLC-235Marion Keegan 0043/11/08-3/13/08T/Th6:30-9:30pmE-112Diane Kerner 0054/01/08-4/03/08T/Th9:30am-12:30pmE-112Marion Keegan 0065/03/08-5/10/08Sat9:30am-12:30pmC-304 Diane Kerner 0017/8/08-7/10/08T/Th6:30-9:30pmE-112Diane Kerner
CC 478 Excel 2003 - Level II6 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.
0011/30/08W9:30am-4:30pmE-112Marion Keegan 0023/05/08W9:30am-4:30pmCLC-235Marion Keegan 0034/04/08F9:30am-4:30pmCLC-235Marion Keegan 0044/15/08-4/17/08T/Th6:30-9:30pmE-112Diane Kerner 0017/29/08-7/31/08T/Th6:30-9:30pmE-112Diane Kerner
CC 487Excel 2003 - Charting3 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. 0012/25/08M10:00am-1:00pmE-112Donna Casciano 0024/01/08T6:30-9:00pmE-112Diane Kerner 0017/15/08T6:30-9:00pmE-112Diane Kerner CC 488Excel 2003 - Database3 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. 0012/27/08W10:00am-1:00pmE-112Donna Casciano 0024/03/08Th6:30-9:30pmE-112Diane Kerner 0017/17/08Th6:30-9:30pmE-112Diane Kerner CC 476Excel 2003 - Macros3 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.
0014/11/08F9:30am-12:30pmCLC-235Marion Keegan 0025/22/08Th6:00-9:00pmE-112Donna Casciano CC 500Excel 2003 - Pivot Tables3 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. 0015/29/08Th6:00-9:00pmE-112Donna Casciano CC 479Excel 2003 Level III Advanced Features6 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. 0015/09/08F9:30am-4:30pmCLC-235Marion Keegan
CC 403Access 2003 Level I6 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. 0012/12/08-2/14/08T/Th10:00am-1:00pmE-112Donna Casciano 0026/02/08-6/04/08M/W10:00am-1:00pmE-112Donna Casciano 0018/05/08-8/07/08T/Th6:30-9:30pmE-112Donna Casciano
CC 404Access 2003 Level II6 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. 0012/19/08-2/21/08T/Th10:00am-1:00pmE-112Donna Casciano 0026/09/08-6/11/08M/W10:00am-1:00pmE-112Donna Casciano CC 507Access 2003 - Forms3 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. 0013/20/08Th10:00am-1:00pmE-112Donna Casciano CC 508Access 2003 - Reports3 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. 0013/18/08T10:00am-1:00pmE-112Donna Casciano CC 405PowerPoint 2003 Level I6 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.
0013/07/08F9:30am-4:30pmCLC-235Marion Keegan 0024/29/08-5/01/08T/Th6:30-9:30pmE-112Diane Kerner CC506PowerPoint 2003 Level II3 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.
0014/16/08W10:00am-1:00pmE-112Donna Casciano 0026/03/08T6:30-9:30pmCLC-235Gladys Ravettine |