Whether you are looking for a new job, pursuing advancement opportunities, or want to gain skills to become more productive in your current job, knowledge of the Microsoft Office Suite of applications and validation of proficiency is crucial in today’s work environment. Your ability to utilize Microsoft applications will open doors and improve your ability to compete in the workforce.
What You Will Learn
Explore Microsoft applications in simple to sophisticated ways. These essential and advanced MOS skills will make you invaluable in the workplace.
Learn How to:
Learn how Microsoft applications can boost organization, flow, creativity, collaboration, record keeping, communication, analysis, and so much more.
Curriculum
Instructors guide students from basic knowledge to advanced through a series of sequential classes. Students can choose to start at the beginning or join a higher level class if they have the prerequisite experience. For Excel certification preparation, instructors follow the GMetrix guide to prepare students to sit for the MO-200 Excel exam. Students continue to use GMetrix for practice, and when they reach expected benchmarks of speed and accuracy, they are prepared to take the certification exam.
Careers in the Field
Microsoft Suite is one of the most sought-after skills in almost any career in today’s job market. This is especially true for Microsoft Excel. Becoming proficient in Microsoft Office benefits employers and employees alike. Boost your career prospects with training through the Center for Workforce Development.
“Having been a Mac user for many years, I was unfamiliar with Microsoft products so I decided to take some of these courses to update my skills. The instructors explained and demonstrated everything clearly. I learned a lot about Microsoft, and discovered many similarities with Mac and Google so I increased my knowledge of those as an added benefit. Taking these classes was time well spent.” -Julia C.
Why Study at CCM?
Many of our Microsoft courses are at no cost to employees of New Jersey non-governmental businesses, thanks to a grant from the Department of Labor. Employers have everything to gain by sending employees for no-cost training, which is usually delivered remotely during working hours, evenings, and even on weekends. Such training improves employee productivity, and an employer’s support of workplace education can boost retention. Employees who wish to keep their skills current and relevant will greatly benefit from these courses.
The Excel Certification Prep 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, students receive a 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.
Paying for Your Education
Most of our Microsoft Office courses are offered through our Grant-supported training program, funded through the NJ Department of Labor. The grant-supported classes are at no cost to employees of NJ non-governmental businesses. Others who do not qualify for free classes are welcome to register at a fee.
The Excel Certification prep course at CCM has been approved by the NJ Department of Labor for NJ residents who are unemployed or underemployed and wish to receive a training voucher to pay for this program. If you are un/underemployed, click here for information on how to qualify.
Related Courses
Microsoft Excel Certification Prep (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.
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: Elissa DeRose-Rizzo, MA, MLIS
Tues, May 7-June 25, 5:30-8:30 pm
8 Sessions, 24 hours
Location: Emeriti Hall, EH 211
Course: 28733
Cost: $499
or
Mon and Tues, July 8-29, 9 a.m.-1 p.m. (mandatory Remote-live orientation July 8, 9-10 a.m.)
On campus: HH-114
13 sessions: 24 hrs, CEU 2.4
Course: 58731
Cost: $499
May 7, 2024 – Jun 25, 2024 | 5:30 pm – 8:30 pm
Course ID: 28733
Jul 8, 2024 – Jul 29, 2024 | 9:00 am – 1:00 pm
Course ID: 58731
Excel for Beginners
PREREQUISITE: Basic understanding of Microsoft Windows.
This course will introduce you to Microsoft Excel basics including 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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
INSTRUCTOR: Emily O’Brien, AS
Excel Intermediate
PREREQUISITE: Must have knowledge of Excel for Beginners or equivalent.
This course will continue with Microsoft Excel topics including: 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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
INSTRUCTOR: Lakeisha Garrett, MBA
Tues & Thurs, April 16, 18, 23 & 25, 6:30-8:30 p.m.
Remote-Live
4 sessions: 8 hrs, CEU 0.8
or
INSTRUCTOR: Emily O’Brien, AS
Wed & Thurs, April 17 & 18, 9 a.m.-1 p.m.
Remote-Live
2 sessions: 8 hrs, CEU 0.8
or
INSTRUCTOR: Emily O’Brien, AS
Mon & Tues, May 13 & 14, 9 a.m.-1 p.m.
Remote-Live
2 sessions: 8 hrs, CEU 0.8
or
INSTRUCTOR: Emily O’Brien, AS
Wed & Thurs, June 12 & 13, 9 a.m.-1 p.m. (NEW DATES)
Remote-Live
2 sessions: 8 hrs, CEU 0.8
Excel Advanced
PREREQUISITE: Must have knowledge of Excel Intermediate or equivalent.
This course will continue with Microsoft Excel topics including: Vlookup, Match, Index, Importing/Exporting Data, Analytical Tools, Goal Seek, Scenario, Solver, Running and Recording a Macro, Buttons, Shortcuts, Combo Charts, and more.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Instructor: Lakeisha Garrett, MBA
Top Excel Tools for Efficiency
PREREQUISITE: Must have knowledge of Excel Intermediate 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, AS
Remote-live
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Excel Functions: Enhance your Worksheets
PREREQUISITE: Must have knowledge of Excel Intermediate or equivalent.
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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Excel: Pivot Tables and Beyond
PREREQUISITE: Must have knowledge of Excel Intermediate 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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Instructor: Trish Callahan, MBA
Remote-live
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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Instructor: Trish Callahan, MBA
Remote-live
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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Instructor: Emily O’Brien, AS
Remote-live
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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
SharePoint: Exploring and Understanding how to use Microsoft SharePoint
PREREQUISITE: Working knowledge of Windows 10 and internet browsers.
Microsoft SharePoint is an online collaboration tool that is prominent for businesses and organizations. At the end of this course, users will be able to navigate, update and search SharePoint documents, lists and libraries. Students will learn 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 hands-on opportunities for participants to practice skills learned as well as learn many SharePoint best practices.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Word for Beginners
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.
This class is offered through our Grant-Supported Training program, and is free to employees of NJ non-governmental businesses. 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.
Instructor: Trish Callahan, MBA
Remote-live
Contact Us
Center for Workforce Development, County College of Morris
Student Community Center, Room 125
214 Center Grove Road, Randolph NJ 07869
E: wfd@ccm.edu
P: 973-328-5187
Resources
Excel Certification Prep Course includes test access code, GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake.
Instructors
Trish Callahan, MBA
Trish has about 30 years of Information Technology experience, including years as a business analyst, project manager and information technology trainer. She has taught email, word processing, SharePoint, Service Now and many other applications. Trish serves as a part-time instructor at County College of Morris where she is teaching courses including SharePoint, Excel, MS Word and PowerPoint. Trish received two undergraduate degrees from the University of Utah and an MBA from Centenary College.
Elissa DeRose Rizzo, MA, MLIS
Elissa has been in the education field for nearly 20 years as a teacher, administrator, specialist, adult education instructor, and curriculum and program developer. She earned her Master of Arts in Educational Leadership and a certificate in Educational Assessment from Montclair State University as well as a Master of Library Information Science from Rutgers University. Her focus includes technology training, professional development instruction, instructional support/coaching, program development, curriculum development, research, and Information Literacy.
Lakeisha Garrett, MBA
Lakeisha has more than 20 years of experience in corporate finance which includes working in Accounts Payable, Revenue Recognition, Pricing Strategy and Forecasting. She has worked for various companies such as Reckitt Benckiser, Dun & Bradstreet and Quest Diagnostics. Lakeisha serves as a part-time instructor at County College of Morris where she teaches MS Excel. Lakeisha received a BS from Kean University, MBA from New Jersey Institute of Technology and an MS in Accounting from Rutgers Business School.
Emily O’Brien, AS
Emily has over 20 years of experience as an instructor for CCM’s Workforce Development Department providing instruction in various MS Office applications for corporate clients and open enrollment programs. For more than 25 years, she has provided instruction at the adult level in multiple settings and is a sought after trainer and instructor. Emily is skilled in developing, coordinating and implementing training sessions for client needs and delivering technical information to effectively train non-technical audiences. Emily is an alumna of CCM.
Lorie Pezzuti, BA
Lorie has 30 years of Information Technology experience in the telecommunications industry, where she held various positions in systems analysis and design, programming, and data analytics. She has worked with many corporate colleagues to assist in using technology to solve business problems. Lorie earned a BA in Computer Science from Rutgers University. As a CCM Workforce Development instructor, she hopes to share real world industry scenarios as part of the information technology curriculum.
Rreze Zejnullahi-Berisha, MA
Rreze teaches QuickBooks and Excel at CCM, as well as Economics at Montclair State University, Drew University, and CCM. She has many years of experience using statistical methods to analyze data as applied to academic research and is equally experienced in teaching students about data analysis. She holds a Master of Arts in Economics from Eastern Michigan University.
