PCP 329
Microsoft Office 2010 Introduction
Learn the basics of MS Office 2010 Word, Excel, PowerPoint, and Access by doing hands-on projects. Create and edit Word documents, produce an Excel spreadsheet with basic formulas and functions, create a PowerPoint presentation, and develop an Access database. Prerequisite: Windows Intro or equivalent knowledge.
Total Cost: $399 (Tuition: $170 Fees: $229)

PCA 565
Microsoft Office 2010 Integration
Learn the data and information sharing properties of the Office applications. Learn how to integrate Word, Excel, PowerPoint and Access with each other and with other programs and to multitask using multiple Office programs together. Prerequisite: Microsoft Office 2010 Intro or equivalent knowledge.
Total Cost: $289 (Tuition: $116 Fees: $173)

PCP 296
Access 2010 Introduction
Examine database concepts, the Access 2010 environment, and the Help systems and learn how to design and create databases, and create queries, forms, and reports. Prerequisite: Windows Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 307
Access 2010 Intermediate
Learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculate fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts. Prerequisite: Access 2010 Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 304
Access 2010 Advanced
Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and backup databases; password protect and encrypt databases; and set Access options and properties. Prerequisite: Access 2010 intermediate or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 298
Excel 2010 Introduction
Learn how to create, edit, format, and print basic Excel 2010 worksheets. Prerequisite: Windows Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 301
Excel 2010 Intermediate
Work with more advanced formatting options including styles, themes, backgrounds, outlines and subtotals, cell names, and tables. Save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. Also covered is advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates. Prerequisite: Excel 2010 Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 306
Excel 2010 Advanced
Learn advanced formulas, lookup functions, data validation and database functions, PivotTables and PivotCharts, importing and exporting data, and how to query external databases. Also learn about the analytical features, running and recording macros, SmartArt graphics, and conditional formatting with graphics. Prerequisite: Excel 2010 Intermediate or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 328
Excel 2010 Pivot Tables
Learn to create and work with PivotTables to increase productivity and produce reports in minutes instead of hours. Go from creating basic PivotTables to building a dynamic PivotTable reporting system. Prerequisite: Excel 2010 Advanced or equivalent knowledge.
Total Cost: $249 (Tuition: $105 Fees: $144)

PCA 573
Excel 2010 VBA Programming
Designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Prerequisite: Excel 2010 Advanced or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 299
PowerPoint 2010 Introduction
Learn to create, save, and rearrange presentations. Learn to format text, use drawing objects, work with graphics, insert tables and charts, use templates and themes, slide masters, and transition effects. Prerequisite: Windows Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 305
PowerPoint 2010 Advanced
Customize the PowerPoint interface, apply themes and templates, and work with SmartArt graphics and tables. Also learn how to add multimedia content and interactive elements to slides, and learn about presentation distribution options including PDF, HTML, and online broadcasts. Prerequisite: PowerPoint 2010 Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 300
Word 2010 Introduction
Enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. Also create tables, insert headers and footers, proof and print documents, and insert graphics. Prerequisite: Windows Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 303
Word 2010 Intermediate
Work with styles, sections, and columns and use the Navigation pane to work with outlines. Also, format tables, print labels and envelopes, work with graphics, use document templates, manage document revisions, and work with Web features. Prerequisite: Word 2010 Intro or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCP 302
Word 2010 Advanced
Learn how to perform mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. Also learn to create macros, customize the ribbon and Quick Access toolbar, and work with XML documents. Prerequisite: Word 2010 Intermediate or equivalent knowledge.
Total Cost: $159 (Tuition: $64 Fees: $95)

PCA 566
Microsoft OneNote 2010
Learn to create, edit, organize, and enhance notes and also integrate them with other applications using Microsoft OneNote 2010. Prerequisite: Windows Introduction
Total Cost: $159 (Tuition: $64 Fees: $95)

Are you entering the workforce for the first time? Returning after a long absence? Starting a new career? Get a thorough introduction to Microsoft Office Applications used in most businesses, learn touch-typing skills to improve your productivity, and learn effective techniques and strategies to get the job you want. Take one course or the entire series. Take your time, get instructor feedback, go at a slower pace. Lots of practice time.

• Professional Development
• Computer Keyboarding
• Web Apps for Business Productivity
• A Simplified Guide to File Management
• A Simplified Guide to Using the Computer, Internet, and Email
• Word Simplified
• Excel Simplified
• PowerPoint Simplified

For more details or to find out information about classes at the Eastpoint Workforce Development Center, call 443-840-5846 or email Gail Wachter (click on the name to send an email) 

PCP 498
A Simplified Guide to Windows File Management
Do you have trouble finding files on your PC? Are all of your files located in one place or library such as "Documents" or "My Documents?" Create and organize folders just like you would in a file cabinet. Practice moving and copying files from one folder to another and/or a flash drive. Learn how to copy files to a CD. Find out how to rename, delete, and restore deleted files. Learn how to create icons on your desktop to gain quick access to files, folders, and programs you use frequently.
Total Cost: $89 (Tuition: $39 Fees: $50)

PCP 949
Word Simplified - (24 Hours)
Start at the beginning and learn Introductory and Intermediate Microsoft Word skills in a slower paced environment with plenty of practice projects and instructor feedback. Discover how to create, save, and edit documents. Practice formatting text, paragraphs, and documents. Generate envelopes and labels during in class practice exercises.
Total Cost: $349 (Tuition: $133 Fees: $216)

PCP 946
Excel Simplified - (24 Hours)
Establish a foundation and learn Introductory and Intermediate Microsoft Excel skills in a slower paced environment with plenty of practice projects and instructor feedback. Learn to create, save, and edit spreadsheets. Discover how to format cells, add borders and shading, move and copy data. Find out how to insert formulas, sort and filter data in a list, and create charts.
Total Cost: $349 (Tuition: $133 Fees: $216)

PCP 947
PowerPoint Simplified - (24 hours)
Start at the beginning and learn Microsoft PowerPoint in a slower paced environment with plenty of practice projects and instructor feedback. Create and save a PowerPoint presentation for delivery in front of audience. Learn how to create and add slides, format text, add and modify images, tables, diagrams, drawing objects and charts. Discover how to enhance a presentation using animation and sound.
Cost: $349 (Tuition: $133 Fees: $216)

For details on these classes, or for information about Back to Work Series classes at the Eastpoint Workforce Development Center, call 443-840-5846 or email: gwachter@ccbcmd.edu

Office Technology training programs:

• Clerk Typist/Receptionist Module 1
• Medical Secretary Modules 1 & 2
• Office Information Processor Modules 1 & 3
• Certified Office Specialist Module 3

Course selections for modules are based on prior course work and experience and can be combined in a variety of ways to meet individual career goals.

Module 1 – Basic Office Skills
In a few short weeks, acquire the skills needed to apply for positions such as general office clerk, clerk typist and receptionist.

Module 2 – Medical Office Training
Prepare to work in a medical office by including medical terminology in any office skills training program.

Module 3 – Microsoft Office Suite
Discover the best way to prepare for Microsoft certification. We'll be happy to advise you on the best way to train for certification exams.

Self-Paced Courses:

• Keyboarding I & II
• Introduction to Windows
• Microsoft Word
• MS Word, Excel, Access, & PowerPoint
• Machine Transcription
• Medical Terminology
• Medical Transcription

* CCBC is an Authorized Testing Center for Microsoft Office Specialist Certification. All self-paced classes and training modules are held at CCBC Catonsville and can be combined in a variety of ways to meet individualized program needs.

Register now for one course or a series of courses. Contact Georgia Nunnally at 443-840-4206 or email gnunnally@ccbcmd.edu to schedule an advisement and registration appointment.