MICROSOFT OFFICE SUITE TRAINING

Our online classes are taught LIVE by an instructor. Students will need access to a computer and to the Internet. A desktop or laptop computer is preferred, but tablets and smartphones are also an option. CCM will provide access to any specialized software needed for the course.

Please note: A link to join a class will be sent by the instructor to registered students 1-2 days before a class is scheduled to begin.


ANNOUNCING OUR EXCEL ‘MINI-BITES’ CLASSES FOR SUMMER!  Top Excel Tools and Functions for Efficiency

Excel Summer Mini-Bites:  Two hours dedicated to focused topics in one of the most sought after skills–Excel!  Take all three Mini-Bites Excel topics for a dynamic combination to become the most efficient Excel User.

PREREQUISITE:  Experience working with Excel and Windows.

Click on + for descriptions, dates and registration:

Data Validation, Logical Functions, Conditional Formatting

This session is dedicated to learning 3 must-have skills:  Data Validation, Logical Functions and Conditional Formatting. These tools help you restrict data entry to certain cells; compare or test one data set to another; and format cells to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

Wed, Aug 4 from 9-11 a.m.

Register here

Lookup and Reference Functions: VLookup, HLookup, Index, Match

This session is dedicated to learning these skills:  VLookup, HLookup, Index and Match. VLookup and HLookup are methods of searching for data either vertically (V) or horizontally (H).  Index and match, often used together, helps you find values or items within a specified range.

Wed, Aug 11 from 9-11 a.m.

Register here

Pivot Tables

This session is dedicated to learning the key to Pivot Tables.  This easy to learn tool allows you to dazzle others and organize data by summarizing, sorting, reorganizing, grouping, counting and more.  You’ll learn to display and group your information in meaningful ways for further analysis and interpretation.

Aug 18 from 9-11 a.m.

Register here

All classes taught over Zoom.

Instructor: Emily O’Brien, AS

Cost: $99

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 Go 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, Nov 30-Dec 9, 6:30-8:30 p.m.

Remote-Live

4 sessions: 8 hrs, CEU 0.8

Course: 88873

Cost: $299

Register here

EXCEL ESSENTIALS

EXCEL ESSENTIALS (MOS-120E)

Excel is Microsoft’s product that creates spreadsheets, and then allows you to work with the data in the spreadsheets in a variety of simple to sophisticated ways. Learn to create, modify and format worksheets, modify cells, columns and rows and print and manage workbooks. Learn formulas, insert functions, use conditional formatting and templates, as well as create and modify charts, construct pivot tables and master many other of the amazing Excel tools. This course will teach you the essential Excel skills to make yourself invaluable to any organization. Start with the Essentials class and keep going until you are certified. Enhance your skills with our Special Topics in Excel to boost your resume even further. This course will prepare individuals to be successful in obtaining their Excel Microsoft 2016 Office Specialist (MOS) certification.

Textbooks are included in this course. Receive a 50% discounted exam voucher for the MOS Excel Specialist Core Exam at CCM’s state-of-the art Testing Center. The exam voucher, a $150 value, will be available to you for $75 and includes your test access code with 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.

INSTRUCTOR: Rreze Zejnullahi-Berisha, MA

Wed and Fri, Sept 22-Oct 8, 9 a.m.-1 p.m.

Remote-Live

6 sessions: 24 hrs, CEU 2.4

Course: 88733

Cost: $429

Register here for 88733

or

Sat, Oct 16-Nov 20, 9 a.m.-1 p.m.

Remote-Live

6 sessions: 24 hrs, CEU 2.4

Course: 88734

Cost: $429

Register here for 88734

EXCEL EXPERT LEVEL CERTIFIED

EXCEL EXPERT LEVEL CERTIFIED (MOS-308E)

PREREQUISITE: MOS Excel 77-727 certification or advanced knowledge of Excel.

Expert-level Excel users have an advanced understanding of the full Excel environment. Expert level professionals in the fields of finance, accounting, data analysis, commercial banking, other financial institutions and professionals in data driven fields will want to obtain this certification as a demonstration of your expertise. This course will refresh your knowledge of advanced Excel functions and prepare you for the Expert Level Excel Certification Exam 77-728. Expert level users can create, manage and distribute professional spreadsheets, customize the Excel environment to meet project needs and enhance productivity and create custom business templates and multiple-axis financial charts, amortization tables and inventory schedules.

Textbooks are included in this course. Receive a 50% discounted exam voucher for the MOS Excel Expert Exam at CCM’s state-of-the art Testing Center.  The exam voucher, a $150 value, will be available to you for $75 and includes your test access code with GMetrix self-study modules, GMetrix timed exam practice sessions, 1 practice exam, the Certification Exam and 1 exam retake. CCM’s state-of-the art Testing Center is located in the Learning Resource Center.

INSTRUCTOR: Rreze Zejnullahi-Berisha, MA

Wed and Fri, Oct 27-Nov 10, 9 a.m.-1 p.m.

Remote-Live

5 sessions: 20 hrs, CEU 2.0

Course: 88735

Cost: $399  

Register here

EXCEL FUNCTIONS

EXCEL FUNCTIONS: ENHANCE YOUR WORKSHEETS UTILIZING ADVANCED FUNCTIONS (WDT-177E)

PREREQUISITE: Understand and use intermediate Excel functions.

If you have competency with Excel and are ready to move on to the next level, explore Advanced Functions and how they can help you save time at work. Learn how to analyze data using advanced formula skills by focusing on functions from various categories within the function library. Acquire skills to create conditional formatting rules using formulas, perform complex calculations using Array formulas and use wildcard characters to help filter results.

INSTRUCTOR: Emily O’Brien, AS

Mon and Wed, Nov 15-17, 6:30-8:30 p.m.  

Remote-Live

2 sessions: 4 hrs, CEU 0.4

Course: 88102

Cost: $159

Register here

MICROSOFT TEAMS

MICROSOFT TEAMS – COLLABORATIVE COMMUNICATION IN THE WORKPLACE (WDT-142E)

Prerequisite: Solid comfort level using a computer and assorted software programs. This course will be using a live instructor-led video conferencing tool (WebEx), The course consists of two live virtual sessions, short exercises and an at-home practice assignment in between sessions. The requirements for your participation are: a home computer/laptop, Internet access, audio and video/camera on your computer, and ideally have the Microsoft web browser ‘Edge’ on your computer prior to class (it might already be loaded on your computer even if you aren’t using it).

Microsoft Teams is the robust upgrade replacement for Skype for Business. 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 tie-in with Microsoft OneDrive. 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

Tues and Thurs, October 11-13, 1-4 p.m.

Remote-Live

2 sessions: 6 hrs, CEU 0.6

Course: 88143

Cost: $199

Register here

MS PROJECT 2016 (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 18-Feb 3, 6:30-9 p.m.

On campus: EH 209

6 sessions: 15 hours, CEU 1.5

Course: 28413

Cost: $329

Register here

OFFICE AND 365

INTRODUCTION TO MICROSOFT OFFICE AND 365 (MOS-117E)

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

Mon and Wed, Sept 20-22, 6-9 p.m.

Remote-Live

2 sessions: 6 hrs, CEU 0.6

Course: 88731

Cost: $129

Register here

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.

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

TBD

OUTLOOK

OUTLOOK – INTRODUCTION

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

INSTRUCTOR: Patricia Callahan, MBA

Mon and Wed, Nov 8–10, 6-9 p.m.

Remote-Live

2 sessions, 6 hrs, CEU 0.6

Course: 88106

Cost: $199

Register here

PIVOT TABLES - INTRO

PIVOT TABLES FOR DATA ANALYTICS – AN INTRODUCTION (WDT-159E)

PREREQUISITE: Experience working with Excel.

How can you work with large amounts of spreadsheet data to isolate and display all of the information you need? This course will introduce individuals to using pivot tables, a tool that allows you to summarize and analyze large quantities of data quickly and easily. Based on the calculation features that the pivot table provides, learn to make raw data easy to understand and analyze. Learn how to create pivot charts from the pivot table for a dynamic graphic representation.

INSTRUCTOR: Emily O’Brien, AS

Tues and Thurs, Oct 19-21, 6:30-8:30 p.m.

Remote-Live

2 sessions, 4 hrs, CEU 0.4

Course: 88100

Cost: $159

Register here

PIVOT TABLES - ADVANCED

PIVOT TABLES FOR DATA ANALYTICS – ADVANCED USERS (WDT-176E)

PREREQUISITE: Experience working with Excel and basic Pivot Tables. 

Advances in technology have made it possible to store ever-increasing amounts of data. The need to analyze that data and gain actionable insight is greater than ever. Harness the power of advanced pivot table features and create pivot charts that will help you to gain a competitive edge. Learn to summarize data to analyze and organize the data in a way that can be meaningfully presented to others. Data-driven business decisions will now be made with a stronger understanding of the underlying data.

INSTRUCTOR: Emily O’Brien, AS

Wed and Fri, Nov 3-5, 6:30-8:30 p.m.

Remote-Live

2 sessions, 4 hrs, CEU 0.4

Course: 88101

Cost: $159

Register here

POWERPOINT - INTRODUCTION

POWERPOINT – INTRODUCTION (WDT-135E)

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

Wed and Fri, Oct 13–15, 6:30-8:30 p.m.

Remote-Live

2 sessions, 4 hrs, CEU 0.4

Course: 88107

Cost: $159

Register here

POWERPOINT - ADVANCED

POWERPOINT ADVANCED DESIGN SKILLS TO CREATE A CUTTING-EDGE PRESENTATION (WDT-141E)

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: Rreze Zejnullahi-Berisha, MA

Tues and Thurs, Dec 14–16, 6-9 p.m.

Remote-Live

2 sessions, 6 hrs, CEU 0.6

Course: 88108

Cost: $199

Register here

WORD

WORD ESSENTIALS (MOS-118E)

Microsoft Word is so much more than just typing into documents. Learn to create and manage professional quality Word documents with ease, while streamlining your work process and improving efficiency. Learn about documents, templates, lists, tables, borders, formatting, spell check, readability, mail merge, tables of contents, indexes and much more. Topics covered align with the core Word Microsoft 2016 Office Specialist (MOS) certification exam.

Textbooks are included in this course. Receive a 50% discounted exam voucher for the MOS Word Specialist Core Exam at CCM’s state-of-the art Testing Center. The exam voucher, a $150 value, will be available to you for $75 and includes your test access code with 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.

INSTRUCTOR:  Patricia Callahan, MBA

Mon and Wed, Sept 29-Nov 1, 6:30-9 p.m.

Remote-Live

10 sessions: 24 hrs, CEU 2.4

Course: 88732

Cost: $429

Register here

VISUAL BASIC APPLICATIONS IN EXCEL (CPC-624E)

VISUAL BASIC APPLICATIONS IN EXCEL (VBA)

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

Fri, Oct 22, 9:30 a.m.-3:30 p.m.

On campus: EH 209

1 session: 6 hrs, CEU 0.6

Course: 88874

Cost: $299

Register here

With our courses, you can explore options to earn a Microsoft Office Specialist certification (MOS), and advance technology knowledge and skills in focused areas.

MICROSOFT OFFICE SPECIALIST (MOS) CERTIFICATION BENEFITS

  • Reflect proven technical skills with an industry valued credential
  • Gain 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)

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