MICROSOFT OFFICE SUITE TRAINING

All of our Microsoft classes are windows based. CCM instructors utilize the Windows operating system to teach computer-based courses and the Microsoft applications. Using a laptop or PC with the Windows operating system is recommended, but not required. Note that if you are using a non-Windows based laptop or other operating system, you will have slightly different functionality than how an application will function and appear on your instructor’s computer.

Any of these courses can be brought to your place of business! Train your employees onsite at your workplace, at our Randolph campus, or through remote-live training on a schedule that works for you. Contact us at cbt@ccm.edu or 973-328-5188 to learn more.

EXPLORE OPTIONS TO IMPROVE SKILLS OR GET CERTIFIED!

CERTIFICATION BENEFITS:

  • Reflect proven technical skills with an industry valued credential, Microsoft Office Specialist (MOS)
  • Get a professional edge by providing globally recognized, industry endorsed evidence of skills mastery
  • Guarantee potential employers of your skill set competence
  • Increase your visibility and hiring potential
  • Realize higher wages. MOS certification can earn an entry-level business employee as much as $16,000 more in annual salary than uncertified peers
  • Build confidence and competency in using Microsoft applications

Upon earning a certification, 23% of Microsoft certified technologists reported receiving up to a 20% salary increase. What’s more, certified employees are often entrusted with supervising their peers—putting them on the fast track for a promotion. (Microsoft.com)

MICROSOFT OFFICE EXCEL MO-200 CERTIFICATION (MOS-312E) – OFFERED YEAR ROUND!

BUSINESS ANALYTICS WITH EXCEL (CPC-635E)

PREREQUISITE: Proficient/intermediate knowledge of MS Excel.

Learn how data science is applied in business. Explore concepts in correlation, regression analysis, hypothesis testing and multivariate analysis. Learn how correlation helps to understand portfolio diversification and design. ‘What If’ analysis will be covered utilizing the Solver and Goal Seek features of Excel. Students will need to save their work to their local computer or a flash drive.

*Textbook required. Visit https://ccm.edu/workforce/textbook-information

INSTRUCTOR: Rreze Zejnullahi-Berisha, MA

Tues and Thurs, Sept 13-22, 6:30-8:30 p.m.

Remote-Live

4 sessions: 8 hrs, CEU 0.8 

EXCEL FOR BEGINNERS

EXCEL FOR BEGINNERS

PREREQUISITE:  Basic understanding of Microsoft Windows.

This course will introduce you to Microsoft Excel basics includ­ing creating spreadsheets, formulas, functions, text, formatting and charts. At the completion of this course, you will be able to perform basic Excel skills such as modifying an existing worksheet, building worksheets, copying and moving cells and much more.

INSTRUCTORS: Emily O’Brien and Roberta Principe

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

INSTRUCTORS: Emily O’Brien, AS, Roberta Principe, MS

Mon and Wed, Oct 10-19, 6:30-8:30 p.m.

Remote-Live

4 sessions, 8 hrs, CEU 0.8

 or

Mon and Thurs, Nov 7-10, 1-5 p.m.

Remote-Live

2 sessions, 8 hrs, CEU 0.8

 or

Mon, Tues, Wed, Thurs, Dec 5-8, 6:30-8:30 p.m.

Remote-Live

4 sessions, 8 hrs, CEU 0.8

EXCEL INTERMEDIATE

PREREQUISITE:  Basic understanding of Microsoft Excel.

This course will continue with Microsoft Excel topics includ­ing: Functions, Formula auditing group, Named Ranges, Database functionality, Freeze Panes, Page Break Preview, Data Validation, Filtering, Tables, a quick intro to Pivot Tables and more.

INSTRUCTOR: Roberta Principe, MS

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon and Thurs, Nov 14-17, 1-5 p.m.

Remote-Live

2 sessions, 8 hrs, CEU 0.8

EXCEL ADVANCED

EXCEL ADVANCED

PREREQUISITE:  Intermediate understanding of Microsoft Excel.

This course will continue with Microsoft Excel topics includ­ing: Vlookup, Match, Index, Importing/Exporting Data, Analytical Tools, Goal Seek, Scenario, Solver, Running and Recording a Macro, Buttons, Shortcuts, Combo Charts, and more.

INSTRUCTOR: Roberta Principe, MS

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon and Thurs, Nov 28-Dec 1, 1-5 p.m.

Remote-Live

2 sessions, 8 hrs, CEU 0.8

TOP EXCEL TOOLS FOR EFFICIENCY

TOP EXCEL TOOLS FOR EFFICIENCY

PREREQUISITE: Intermediate Excel or equivalent.

This training is dedicated to learning quick tricks on the top must-have skills for improving your efficiency with Excel: Data Validation, Logical Functions, Conditional Formatting, Lookup and Reference Functions, and Pivot Tables. These tools will help increase your productivity and motivate you to tackle your spreadsheets with ease. Join this quick power training to help boost your effectiveness and efficiency in Excel.

INSTRUCTOR: Emily O’Brien

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Tues and Thurs, Nov 1-3, 6-9 p.m.

Remote-Live

2 sessions, 6 hrs, CEU 0.6

EXCEL FUNCTIONS

EXCEL FUNCTIONS: ENHANCE YOUR WORKSHEETS 

PREREQUISITE: Understand and use basic Excel functions.

This course is designed for participants who have a basic knowledge of Excel functions and want to discover how advanced functions can help save time at work. Learn how to analyze data using advanced formula skills by focusing on functions from various categories within the function library. Also learn how to create conditional formatting rules using formulas, perform complex calculations using Array formulas and create customized lists using data validation.

INSTRUCTOR: Roberta Principe, MS

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon and Wed, Dec 12-14, 1-5 p.m.

Remote-Live

2 sessions, 8 hrs, CEU 0.8

EXCEL: PIVOT TABLES & BEYOND

PREREQUISITE: Intermediate Excel or equivalent.

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data, but Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that meaningfully presents it to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

INSTRUCTOR: Roberta Principe, MS

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon and Thurs, Dec 5-8, 1-5 p.m.

Remote-Live

2 sessions, 8 hrs, CEU 0.8

MICROSOFT OFFICE EXCEL MO-200 CERTIFICATION (MOS-312E)

Microsoft Excel is one of the most sought-after skills in today’s job market. Demonstrate your knowledge of Excel 2019 by becoming MO-200 Microsoft Excel Certified. Work with Excel spreadsheets in simple to sophisticated ways. Create, modify and format worksheets, modify cells, columns and rows and print and manage workbooks. Formulas, insert functions, conditional formatting and templates will be covered, as well as charts, pivot tables and many other amazing Excel tools. These essential and advanced Excel skills will make you invaluable. Certification preparation includes live practice with the instructor. Earn the latest Excel certification, Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) MO-200. Boost your resume even further with Special Topics in Excel!

This course includes an electronic textbook and an exam voucher for the Microsoft Office Specialist: Excel Associate (Excel and Excel 2019), MO-200, at CCM’s state-of-the art Testing Center. On the first day of class, receive your test access code, GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake. CCM’s Testing Center is located in the Learning Resource Center. This certification does not expire.

INSTRUCTOR: Rreze Zejnullahi-Berisha, MA

Sat, Oct 29-Dec 10, 9 a.m.-1 p.m. (No class Nov 26)

Remote-Live                

6 sessions: 24 hrs, CEU 2.4

Course: 88732

Cost: $499

REGISTER HERE

MS PROJECT 2019 (PMC-130E)

Microsoft Project is the most popular project planning tool in the world, used in over 100 countries. With this hands-on course, gain the knowledge to be able to:

  • Develop a plan, build a schedule and assign resources
  • Track and manage tasks, resources and budgets
  • Analyze workloads to share resources across multiple projects
  • Apply best practice principles to plan, manage, maintain and direct projects
  • Produce project status charts and reports

INSTRUCTOR: Thomas Schnipp, M.Ed., PMP

Tues and Thurs, Jan 10-26, 2023, 6:30-9 p.m.

On campus: HH 114

6 sessions: 15 hours, CEU 1.5

Course: 28413

Cost: $329

REGISTER HERE

OFFICE AND 365

INTRODUCTION TO MICROSOFT OFFICE AND 365

PREREQUISITE: Basic Windows knowledge and computer skills.

Could you use a basic tutorial on Microsoft tools that are on PCs? This beginner-level course is an introduction to the most popular Microsoft Office applications: Outlook, Word, Excel and PowerPoint, as well as MS 365, the cloud-based version of the MS Office package. Students with no prior MS Office experience should start with this course and progress to the Essentials courses, with a goal of becoming a certified MS Office Specialist.

INSTRUCTOR: Patricia Callahan, MBA

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon & Wed, Oct 24, 4-7 p.m. AND Oct 26, 5:30-8:30 p.m. (new times)

Remote-Live

2 sessions: 6 hrs, CEU 0.6

ONE NOTE

MICROSOFT ONE NOTE – INTRODUCTION

Microsoft OneNote is a powerful tool that provides a wide range of features for all users. Getting the most out of those features is the focus of this workshop. Topics covered in this workshop include creating and customizing notebooks, formatting text, drawing shapes, picture tasks, customizing pages, using page templates, working with sections, syncing a notebook, managing notebook properties and OneNote files. The course also covers tools for editing, sharing , and collaborating.

OUTLOOK

OUTLOOK IN A NUTSHELL

PREREQUISITE: Basic understanding of Microsoft Windows.

Outlook is Microsoft’s tool for managing your email, contacts and calendars. In this course, you will learn to use Outlook to send, receive and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself and customize the Outlook interface to suit your working style. Don’t deal with a disorganized inbox; learn to use Outlook’s powerful features to stay on top of messages and schedules.

INSTRUCTOR: Patricia Callahan, MBA

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon and Wed, Nov 7-9, 4-7 p.m.

Remote-Live

2 sessions, 6 hrs, CEU 0.6

PIVOT TABLES AND BEYOND

EXCEL: PIVOT TABLES & BEYOND

PREREQUISITE: Intermediate Excel or equivalent.

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data, but Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that meaningfully presents it to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

INSTRUCTOR: Roberta Principe, MS

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon and Thurs, Dec 5-8, 1-5 p.m.

Remote-Live

2 sessions, 8 hrs, CEU 0.8

POWERPOINT - INTRODUCTION

PREREQUISITE: Basic understanding of Microsoft Windows.

Presentations can sometimes be monotonous, but with Microsoft PowerPoint you can learn to make them compelling. Master the basic features and functions of Microsoft PowerPoint, a powerful presentation tool. Perform advanced text editing, add and create graphics, modify objects and animate presentations.

INSTRUCTOR: Emily O’Brien, AS

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Tues and Thurs, Oct 25-27, 6:30-8:30 p.m.

Remote-Live

2 sessions, 4 hrs, CEU 0.4

POWERPOINT - ADVANCED

POWERPOINT: ADVANCED DESIGN SKILLS TO CREATE CUTTING EDGE PRESENTATIONS

PREREQUISITE: Working knowledge of PowerPoint.

This course is for those who already know how to create a PowerPoint presentation but want to learn advanced functions that will make your presentation sensational. Capture your audience with easy to use, impressive and powerful PowerPoint features that most people do not know about. Keep your audience’s attention with engaging messages and graphics that communicate a clear message. Have your charts build themselves before your viewers’ eyes. Learn to use these helpful tools without a huge commitment of time.

INSTRUCTOR: CCM staff

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

TBD

Remote-Live

2 sessions, 4 hrs, CEU 0.4

SHAREPOINT

Microsoft SharePoint is an online collaboration tool that is very prominent for businesses and organizations. At the end of this course, users will be able to navigate through SharePoint, search documents, content, libraries and lists. They will know how to update their SharePoint profile, use SharePoint with Microsoft Office and access SharePoint from mobile devices. This workshop is highly interactive and provides numerous opportunities for application to the participants’ workplace and practice of skills learned.

INSTRUCTOR: Patricia Callahan, MBA

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Tues and Thurs, Oct 18-20, 4-7 p.m.

Remote-Live

2 sessions: 6 hrs, CEU 0.6

 or

Tues and Thurs, Nov 15-17, 4-7 p.m.

Remote-Live

2 sessions: 6 hrs, CEU 0.6

TEAMS

MICROSOFT TEAMS: COLLABORATIVE COMMUNICATION IN THE WORKPLACE

PREREQUISITE: Solid comfort level using a computer and assorted software programs.

This course will be using a live instructor-led video conferencing tool (Zoom on Day 1; Teams on Day 2). The course consists of two live virtual sessions, hands-on exercises and an at-home practice assignment in between sessions. The requirements for your participation are Internet access and a computer/laptop with audio and video/camera.

Microsoft Teams is the pivotal communications app included in Office 365. It maximizes and heightens both group and one-on-one work collaboration. Navigate the interface and features as well as its seamless integration with other Microsoft apps. Learn to create and manage teams, send instant messages, initiate and manage audio and video conferencing, share, edit, and present files in an online meeting, set up scheduled meetings, create impromptu gatherings, share your screen, record meetings using Microsoft Stream, as well as add other program apps and web resources to any of your teams.

INSTRUCTOR: Rita Williams-Bogar, MBA, CPCU, ARM, AU, AINS, ChFC

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Mon and Wed, Dec 12-14, 9 a.m.-12 p.m.

Remote-Live

2 sessions: 6 hrs, CEU 0.6

WORD

MICROSOFT WORD

PREREQUISITE: a working knowledge of Microsoft Windows 10 to take this course.

Microsoft Word is so much more than just typing into documents. In this eight-hour introductory course, we will teach you how to create and manage professional quality Word documents with ease, while improving your overall efficiency using the application. You will learn about different document types, how to use templates, create lists, tables, add borders, formatting, spell check, readability and much more.

INSTRUCTOR: Patricia Callahan, MBA

This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. To see if you qualify, or to explore all of our grant-supported classes, please click here. If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at wfd@ccm.edu so we can assist with enrollment.

Tues and Thurs, Nov 1-10, 4-6 p.m.

Remote-Live

4 sessions: 8 hrs, CEU 0.8

VISUAL BASIC APPLICATIONS IN EXCEL (CPC-624E)

VISUAL BASIC APPLICATIONS IN EXCEL (CPC-624E)

PREREQUISITE: Proficient knowledge of MS Excel.

Make your Excel spreadsheets much more powerful. Learn to record macros and about the basics of VB programming. The course will teach you to read, write and debug VB code, how to pass lists and floating variables though VB, to use conditional statements, and create input and message boxes. At the end of this course, you will be familiar with the VBA programming language as it applies to Microsoft Excel and will apply this knowledge to make interactive and fully functional spreadsheets. Students will need to save their work to their local computer or a flash drive.

INSTRUCTOR: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

Tues and Thurs, Dec 6-13, 6:30-8:30 p.m.

Remote-Live

3 session: 6 hrs, CEU 0.6

Course: 88873

Cost: $299

REGISTER HERE

Even if you do not take one of CCM’s Microsoft Office courses, you can still sit for a Microsoft Office Specialist Certification at the conveniently located CCM Testing Center in the Learning Resource Center.

  • 77-725: MS Office Word 2016
  • 77-726: MS Office Word 2016 Expert
  • 77-727: MS Office Excel 2016
  • 77-728: MS Office Excel 2016 Expert
  • 77-729: MS Office PowerPoint
  • 77-731: MS Office Outlook

CCM’s examination fee is $150 and includes GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.

For more information, visit www.ccm.edu/testing