Home > Continuing Education > 6 Hour Programs

Computer Training

PROGRAMS FOR BEGINNERS

CC 513 Word for Beginners 18 hours (6 sessions) $300

This 18-hour course is designed for beginners. Learn what you need to know about the PC, Windows and Microsoft Word to be able to get up and running with some confidence. Everyone in the class is a mature adult who wants to learn to use a computer, so everyone is in the same boat. There are no prerequisites. A certificate of completion is awarded at the end of the course.

001 1/23/07-2/08/07 T/Th 7:00-10:00pm CLC-235 Susan Rasmussen

002 2/27/07-3/22/07 T/Th 9:30am-12:30pm E-112 Marion Keegan

(no class 3/13, 3/15)

003 4/10/07-4/26/07 T/Th 7:00-10:00pm CLC-235 Susan Rasmussen

004 5/07/07-5/23/07 M/W 9:30am-12:30pm E-112 Marion Keegan

CC 511 Intro to the PC & Windows ▲ 6 hours $140

This class is for new users of the Personal Computer and is the prerequisite for many Level I classes in this catalog. Learn about the parts of the computer, how a computer operates, and how to use the mouse and keyboard. Beginning Windows topics are covered: understanding and manipulating different types of screens, running programs, and beginning to understand files and folders.

001 1/16/07-1/18/07 T/Th 9:30am-12:30pm E-112 Marion Keegan

002 3/03/07-3/10/07 Sat 9:30am-12:30pm E-112 Diane Kerner

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

CC 524 More About Windows & Folders ▲ 5 hours $100

This class is designed for two groups of people: new users who have just taken Intro to the PC and Windows, or people who have been using a PC for a while and are still confused about folders. Create and use folders in Windows, in Microsoft Word and in Microsoft Excel. Practice finding files, and moving and copying files between different folders. Learn more Windows topics such as: adding items to the Start menu, creating Shortcut icons on the Desktop, using the Recycle Bin, changing the background of the Desktop screen, and using the Calculator.

Prerequisite: Intro to the PC and Windows or equivalent PC experience.

001 1/23/07-1/25/07 T/Th 9:30am-12:00pm E-112 Marion Keegan

002 3/24/07-3/31/07 Sat 9:30am-12:00pm E-112 Diane Kerner

003 4/17/07-4/19/07 T/Th 9:30am-12:00pm E-112 Marion Keegan

CC 503 Internet for Beginners 3 hours $75

This introductory course acquaints the beginner with the World Wide Web. Learn how to find a particular web site or search for specific information on the Internet. Other topics include printing web pages, keeping track of favorite web sites, and viewing a history of web sites observed on different days.

Prerequisites: Proficiency with the mouse, and basic knowledge of the keyboard and Microsoft Windows. Take Intro to the PC & Windows if you do not have the prerequisite experience.

001 1/30/07 Tue 9:30am-12:30pm E-112 Marion Keegan

002 4/14/07 Sat 9:30am-12:30pm E-112 Diane Kerner

003 5/01/07 Tue 9:30am-12:30pm E-112 Marion Keegan

CC 504 Email for Beginners 3 hours $75

This beginning email course covers sending and receiving email, using attachments, replying to and forwarding messages, and deleting email. Other topics include setting up filters and groups.

Prerequisites: Knowledge of basic Internet usage or Internet for Beginners, plus basic mouse and keyboard skills. Take Intro to the PC & Windows if you do not have the prerequisite experience.

001 2/01/07 Thur 9:30am-12:30pm E-112 Marion Keegan

002 5/03/07 Thur 9:30am-12:30pm E-112 Marion Keegan

BUYING AND SELLING ON eBAY

CC 483 eBay: Selling Basics 3 hours $80

If you have been buying on eBay, and want to learn how to sell, or simply pick up new tips, this is the right class for you. Topics covered: how to open a seller account, research and create listings, improve your listings with better descriptions and photography, open and use a PayPal account, monitor your listings, and complete transactions.

001 2/07/07 Wed 6:00pm-9:30pm TEC-119 Harvey Levine

002 3/24/07 Sat 9:00am-12:30pm TEC-119 Harvey Levine

003 5/02/07 Wed 6:00pm-9:30pm TEC-119 Harvey Levine

Note: Instructors will provide refreshments for Saturday, 3/24/07, A Day of eBay.

CC 493 eBay: Beyond the Basics 3 hours $80

If you have been selling on eBay, and want to learn how to get the most out of your listings, this is the right class for you. Topics covered: how to start/and or grow an eBay-based business, choose the right listing format, create compelling listings, use eBay listing tools, market your eBay business, benefits of an eBay store, pack and ship inventory, and use online payments from PayPal.

001 3/24/07 Sat 1:30-5:00pm TEC-119 Harvey Levine

Note: Instructors will provide refreshments for Saturday, 3/24/07, A Day of eBay.

MICROSOFT OFFICE COURSES

CC 397 Word I ▲ 6 hours $140

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 2/02/07 Fri 9:30am-4:30pm E-112 Marion Keegan

002 2/27/07-3/01/07 T/Th 6:30-9:30pm CLC-235 Gladys Ravettine

003 5/21/07-5/23/07 M/W 6:30-9:30pm E-112 Diane Kerner

CC 467 Mail Merge 3 hours $75

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 2/23/07 Fri 9:30am-12:30pm E-112 Marion Keegan

002 5/11/07 Fri 9:30am-12:30pm E-112 Marion Keegan

CC 398 Word II 6 hours $140

Learn to create 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/09/07 Fri 9:30am-4:30pm E-112 Marion Keegan

002 3/20/07-3/22/07 T/Th 6:30-9:30pm CLC-235 Gladys Ravettine

003 6/04/07-6/06/07 M/W 6:30-9:30pm E-112 Diane Kerner

CC 399 Word III 6 hours $140

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 3/02/07 Fri 9:30am-4:30pm E-112 Marion Keegan

CC 400 Excel I Introduction ▲ 6 hours $140

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/19/07 Fri 9:30am-4:30pm E-112 Marion Keegan

002 2/13/07-2/15/07 T/Th 6:00-9:00pm E-112 Donna Casciano

003 3/30/07 Fri 9:30am-4:30pm CLC-235 Marion Keegan

004 4/05/07-4/12/07 Thur 6:30-9:30pm E-112 Gladys Ravettine

005 5/08//07-5/10/07 T/Th 9:30am-12:30pm E-112 Donna Casciano

CC 478 Excel II Intermediate Topics 6 hours $140

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/26/07 Fri 9:30am-4:30pm E-112 Marion Keegan

002 2/20/07-2/22/07 T/Th 6:00-9:00pm E-112 Donna Casciano

003 4/13/07 Fri 9:30am-4:30pm CLC-235 Marion Keegan

004 5/03/07-5/10/07 Thur 6:30-9:30pm CLC-235 Gladys Ravettine

005 5/15/07-5/17/07 T/Th 9:30am-12:30pm E-112 Donna Casciano

CC 487 Excel Charting 3 hours $75

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 3/06/07 Tue 6:00-9:00pm E-112 Donna Casciano

002 5/29/07 Tue 9:30am-12:30pm E-112 Donna Casciano

CC 488 Excel Database 3 hours $75

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 3/08/07 Thur 6:00-9:00pm E-112 Donna Casciano

002 5/31/07 Thur 9:30am-12:30pm E-112 Donna Casciano

CC 476 Excel Macros 3 hours $75

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 3/20/07 Tue 6:00-9:00pm E-112 Donna Casciano

002 6/05/07 Tue 9:30am-12:30pm E-112 Donna Casciano

CC 500 Excel Pivot Tables 3 hours $75

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 3/22/07 Thur 6:00-9:00pm E-112 Donna Casciano

002 6/07/07 Thur 9:30am-12:30pm E-112 Donna Casciano

CC 479 Excel III 6 hours $140

Advanced Formulas & Functions

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 4/17/07-4/19/07 T/Th 6:00-9:00pm E-112 Donna Casciano

002 6/12/07-6/14/07 T/Th 9:30am-12:30pm E-112 Donna Casciano

CC 439 QuickBooks 12 hours $280
(4 sessions)

Take control and save time with an easy-to-use accounting program for small business owners. Create professional invoices, make deposits, write checks, receive payments, enter and pay bills, issue credit memos, reconcile accounts, generate important financial statements and reports. No prior knowledge of accounting is required.

Prerequisites: Introduction to PC & Windows or equivalent experience.

001 1/29/07-2/19/07 Mon 6:30-9:30pm E-112 Annette Rakowski

002 3/21/07-4/11/07 Wed 1:30-4:30pm E-112 Annette Rakowski

CC 515 QuickBooks for Accountants 10 hours $250
(4 sessions)

This course is designed for Accountants only.

QuickBooks helps you manage your practice, increase revenues, and better support your clients. Be in a good position to provide your clients with integrated and recurring professional services, such as financial reporting, account analysis, payroll, etc. This hands-on course provides you with the tools you need to use QuickBooks and to help your clients. It covers the same material as the CC 439 QuickBooks course plus the CC 495 Integrating QuickBooks with Excel & Quicken.

Successful completion of this course earns a Certificate of Completion from Bergen Community College and 12 CPE credits, recognized by the NJ State Board of Accountancy. We are Sponsor # 20CE00062600.

Prerequisite: Intro to PC & Windows or equivalent experience.

001 6/05/07-6/14/07 T/Th 6:00-8:30pm E-112 Jay Mehta, CPA, CFP�

CC 403 Access I ▲ 6 hours $140

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.

001 1/22/07-1/24/07 M/W 9:30am-12:30pm E-112 Donna Casciano

002 3/26/07-3/27/07 M/T 6:00-9:00pm E-112 Donna Casciano

CC 404 Access II 6 hours $140

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 1/29/07-1/31/07 M/W 9:30am-12:30pm E-112 Donna Casciano

002 4/09/07-4/10/07 M/T 6:00-9:00pm E-112 Donna Casciano

NEW

CC 507 Access Forms 3 hours $75

Learn to create forms for data entry and for lookup, customize and format forms. Develop Forms/Subforms for displaying data from related tables. Create calculation expressions in forms. Insert photos and graphics into forms.

Prerequisite: Access II or comparable experience.

001 2/12/07 Mon 9:30am-12:30pm E-112 Donna Casciano

002 4/23/07 Mon 6:00-9:00pm E-112 Donna Casciano

CC 508 Access Reports 3 hours $75

Learn to create, customize, format and group data in reports. Develop Reports/Subreports for printing data from related tables. Create calculation expressions in forms. 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 2/05/07 Mon 9:30am-12:30pm E-112 Donna Casciano

002 4/16/07 Mon 6:00-9:00pm E-112 Donna Casciano

CC 457 Access III 6 hours $140

Develop a switchboard to simplify various database activities. Create command buttons and macros to automate many functions of the database. Design Union Queries and Action Queries. Use Access functions.

Prerequisite: Access II or comparable experience.

001 2/26/07-2/28/07 M/W 9:30am-12:30pm E-112 Donna Casciano

002 4/30/07-5/01/07 M/T 6:00-9:00pm E-112 Donna Casciano

CC 405 PowerPoint I ▲ 6 hours $140

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 2/16/07 Fri 9:30am-4:30pm E-112 Marion Keegan

002 5/22/07-5/24/07 T/Th 6:30-9:30pm E-112 Gladys Ravettine

CC 505 PowerPoint Drawing & Templates 3 hours $75

Learn drawing techniques and how to customize graphics. Create colorful backgrounds. Learn to use Masters to customize Design Templates. Use your drawing skills to create your own Design Templates to personalize your presentations. Prerequisite: Powerpoint I.

001 3/05/07 Mon 9:30am-12:30pm E-112 Donna Casciano

002 6/18/07 Mon 6:00-9:00pm E-112 Donna Casciano

CC 506 PowerPoint Slide Show & Animation 3 hours $75

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 3/19/07 Mon 9:30am-12:30pm E-112 Donna Casciano

002 6/20/07 Wed 6:00-9:00pm E-112 Donna Casciano


© 2008 Bergen Community College 400 Paramus Road, Paramus, New Jersey 07652, 201-447-7100