Microsoft Office Suite

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.

INSTRUCTOR: Rreze Zejnullahi-Berisha, MA

Tues and Thurs, March 7-16, 6:30-8:30 p.m.

Remote-Live

4 sessions: 8 hrs, CEU 0.8 

Course: 28874

Cost: $299

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

PREREQUISITE:  Must have knowledge of Excel for Beginners or equivalent.

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.

EXCEL ADVANCED

PREREQUISITE:  Must have knowledge of Excel Intermediate or equivalent.

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.

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

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.

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.

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.

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.

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.

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, June 3-July 15, 9 a.m.-1 p.m. (No class July 1)

Remote-Live    

6 sessions: 24 hrs, CEU 2.4

Course: 28732

Cost: $499

REGISTER HERE

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, June 6-27, 2023, 6:30-9 p.m. (No class June 20)

On campus: HH 114

6 sessions: 15 hours, CEU 1.5

Course: 28414

Cost: $379

REGISTER HERE

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.

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 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.

EXCEL: PIVOT TABLES & 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.

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.

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.

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 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.

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.

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.

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.

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.

VISUAL BASIC APPLICATIONS IN EXCEL (CPC-624E)

PREREQUISITE:  Must have knowledge of Excel Intermediate or equivalent.

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: Lorie Pezzuti, BA

Tues and Thurs, Feb 21-28, 6:30-8:30 p.m.

Remote-Live

3 sessions: 6 hrs, CEU 0.6

Course: 28873

Cost: $299