MICROSOFT OFFICE SUITE TRAINING

MICROSOFT OFFICE SUITE

The skills needed for every job, 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 business environment. Your ability to thoroughly utilize Microsoft Word, Excel, PowerPoint, Outlook and the newer productivity and communication applications will open doors and improve your ability to compete in the workforce.

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)


INTRODUCTION TO MICROSOFT OFFICE AND 365

Prerequisite: Basic Windows knowledge and computer skills.

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. Knowledge of MS applications, used almost universally in the workplace, are often minimum requirements. Learn how to create calendar entries and meeting invitations, a simple text document, a basic spreadsheet and a simple slide presentation. 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. MOS-117

Instructor: Patricia Callahan

28731. 1 session: 6 hours, CEU 0.6

Time: 9 a.m.-4 p.m., Tues, Jan 21

Location: Henderson Hall, HH 114

Cost: $129

WORD

MICROSOFT WORD ESSENTIALS

This program is for individuals who have a desire to become proficient in understanding and applying the features of Microsoft Word.

In today’s office environment, Microsoft Word is used to create most all documents. Whatever your job title, a mastery of Microsoft Word is essential. In this course, learn to create and manage professional quality documents with ease, while streamlining your work process and improving efficiency.  

Word Essentials begins with the basics of creating and working with documents, expands to templates, lists, tables and borders, continues with special formatting, tools such as spell check, readability statistics and references and culminates with powerful tools like mail merge, tables of contents, indexes and much more.  Topics covered align with the core Word Microsoft 2016 Office Specialist (MOS) certification exam.  The knowledge gained in this program will prepare individuals to be successful in obtaining their certification.

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 Test 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 Test Center is located in the Learning Resource Center. MOS-118

Instructor: Laraine Gilberti, BA

28732. 8 sessions: 24 hours, CEU 2.4

Time: 9 a.m.-12 p.m., Tues and Thurs, Jan 28-Feb 20

Location: Henderson Hall, HH 114

Cost: $399

EXCEL

EXCEL ESSENTIALS

This course is for individuals who have a desire to become proficient in understanding and applying the features of Microsoft Excel.

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.

Topics covered in Excel Essentials align with the core Excel Microsoft 2016 Office Specialist (MOS) certification exam.  The knowledge gained in this program will prepare individuals to be successful in obtaining their certification.

Excel Essentials will teach you the essential Excel skills to make yourself invaluable to any organization.  You will 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.

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 Test 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 Test Center is located in the Learning Resource Center. MOS-120

Two sections are offered:

Instructor: Rreze Zejnullahi-Berisha, MA

28733. 8 sessions: 24 hours, CEU 2.4

Time: 9 a.m.-12 p.m., Mon and Wed, March 9-April 6 (No class March 23)

Location: Henderson Hall, HH 114

Cost: $399

or

Instructor: Lisa Kenneweg, BS

28734. 7 sessions: 24 hours, CEU 2.4

Time: 9 a.m.-12:30 p.m., Sat, March 28-May 30 (No class April 11, 25, May 23)

Location: Emeriti Hall, EH 211

Cost: $399

BACK TO TOP

EXCEL EXPERT LEVEL CERTIFIED

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 to 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 Test 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 Test Center is located in the Learning Resource Center. MOS-308.

Instructor: Rreze Zejnullahi-Berisha, MA

28735. 4 sessions: 20 hours, CEU 2.0

Time: 9 a.m.-3 p.m., Sat, April 25-May 16

Location: Henderson Hall, HH 113

Cost: $399

SPECIAL TOPICS IN EXCEL

PIVOT TABLES FOR DATA ANALYTICS – AN INTRODUCTION

This course will introduce individuals to using pivot tables, a took that allows you to summarize and analyze large quantities of data quickly and easily. Based on the various calculation features (sum, average, count and more) that the pivot table provides, you will be able to take raw data and make it easy to understand and analyze. Learn how to create pivot charts from the pivot table for a dynamic graphic representation. WDT-136

Instructor: Rreze Zejnullahi-Berisha, MA

28100. 1 session: 6 hours, CEU 0.6

Time: 9 a.m.-4 p.m., Fri, Jan 24

Location: Henderson Hall, HH 114

Cost: $199

PIVOT TABLES FOR DATA ANALYTICS – ADVANCED USERS

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. You already have experience working with Excel and creating basic pivot tables to summarize data, but Excel is capable of doing much more. Being able to harness the power of advanced pivot table features and create pivot charts will help you to gain a competitive edge. You will not only be able to summarize data to analyze, but also 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. WDT-137

Instructor: Rreze Zejnullahi-Berisha, MS

28101. 2 sessions: 6 hours, CEU 0.6

Time: 6-9 p.m., Mon and Wed, Feb 17-19

Location: Henderson Hall, HH 114

Cost: $199

VISUAL BASIC APPLICATIONS IN EXCEL (VBA)

Prerequisite: Proficient Intermediate knowledge of MS Excel.

You will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts out with learning how to record macros and the basics of VB programming. The course will teach you to read, write and debug VB code. You will also learn how to pass lists and floating variables through VB. The course will teach you 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. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. CPC-624

Instructor: Kelly Fitzpatrick, MA

28872. 1 session: 6 hours, CEU 0.6

Time: 9:30 a.m.-4:30 p.m., Fri, Feb 28

Location: Cohen Hall, CH 156

Cost: $299

EXCEL FUNCTIONS: ENHANCE YOUR WORKSHEETS UTILIZING ADVANCED FUNCTIONS

Prerequisite: Understand and use Intermediate Excel functions.

Discover how advanced functions can help save you time at work. Learn how to analyze data using advanced formula skills by focusing on functions from various categories within the function library. You will acquire skills to create conditional formatting rules using formulas, perform complex calculations using Array formulas and use wildcard characters to help filter results. WDT-138

Instructor: Rreze Zejnullahi-Berisha, MA

28102. 1 session: 6 hours, CEU 0.6

Time: 9 a.m.-4 p.m., Fri, March 20

Location: Henderson Hall, HH 113

Cost: $199


OUTLOOK

OUTLOOK – INTRODUCTION

PREREQUISITE: Basic understanding of Microsoft Windows.

Email is one of the most widely used methods of communication, whether for business or personal use. In this course, you will 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.  MOS-116.

Instructor: Emily O’Brien, AS

28103. 2 sessions: 6 hours, CEU 0.6

Time: 9 a.m.-12 p.m., Tues and Thurs, Jan 28-30

Location: Henderson Hall, HH 113

Cost: $199

BACK TO TOP

POWERPOINT


POWERPOINT – INTRODUCTION

Prerequisite: Basic understanding of Microsoft Windows.

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

Instructor: Emily O’Brien, AS

28104. 2 sessions: 6 hours, CEU 0.6

Time: 9 a.m.-12 p.m., Tues and Thurs, March 3-5

Location: Henderson Hall, HH 114

Cost: $199

BACK TO TOP

POWERPOINT ADVANCED – DESIGN SKILLS TO CREATE A CUTTING-EDGE PRESENTATION

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 a 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. WDT-141

Instructor: Rreze Zejnullahi-Berisha

28105. 2 sessions: 6 hours, CEU 0.6

Time: 6-9 p.m., Mon and Wed, April 20-22

Location: Cohen Hall, CH 156

Cost: $199

TEAMS

MICROSOFT TEAMS – COLLABORATIVE COMMUNICATION IN THE WORKPLACE

Prerequisite: Personal computer skills.

Microsoft Teams is the robust upgrade replacement for Skype for Business and is included in Microsoft Office 365. Teams is the pivotal communications app within 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 send instant messages, initiate audio and video conferencing, share and present files in an online meeting, set up scheduled meetings, create strong meeting agendas, switch seamlessly between two active meetings, create impromptu gatherings, share your screen, record and manage meetings using Microsoft Stream, as well as add other program apps and web resources to any of your Teams.  WDT-142

Instructor: Alyce Garver, BA

28106. 1 session: 6 hours, CEU 0.6

Time: 9 a.m.-4 p.m., Thurs, March 5

Location: Emeriti Hall, EH 211

Cost: $199

BACK TO TOP

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 a notebook, formatting text, handwriting text, drawing shapes, advanced picture tasks, customizing pages, using page templates, working with sections and section groups, syncing a notebook, managing notebook properties, managing OneNote files and backing up OneNote files. The course also covers editing tools, tags, Quick Notes and Docked Notes. Sharing, collaborating with teams, saving and printing notebooks is also discussed. The course wraps up with a look at how to customize the interface. WDT-152

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

28116. 1 session: 4 hours, CEU 0.4

Time: 1 p.m.-5 p.m.. Tues, March 31

Location: Henderson Hall, HH 114

Cost: $119

BACK TO TOP

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

*Textbook required; go to https://bookstore.ccm.edu/college and search for your course number.

Questions about Computer Training?  wfd@ccm.edu or 973-328-5187