MCCC MCCC MCCC MCCC
News at MCCC
MCCC
MCCC
MCCC
MyMercer
MCCC
menu bg FUTURE STUDENTS CURRENT STUDENTS ABOUT MCCC ACADEMICS STUDENT SERVICES AND FINANCIAL AID NONCREDIT COURSES AND CONTINUING EDUCATION BUSINESS AND PROFESSIONAL TRAINING/DEVELOPMENT YOUTH PROGRAMS & COMMUNITY menu bg
MCCC arrow Non-Credit Courses and
    Certificate Programs

line
arrow Non-Credit Online Courses
line
arrow Professional Development
line
arrow Career Training Institute
    @ Trenton Campus
arrow State-Funded Training
line
arrow Class Registration
line
arrow Policies, Student Information
line
arrow Forms
line
arrow News & Events
MCCC
Center for Continuing Studies Programs
arrow Business & Management
line
arrow Computers & Information
    Technology

line
arrow Construction and UCC
line
arrow NICET, Highway Engineering
    & Transportation
MCCC arrow ESL & Languages
line
arrow Teaching
line
arrow Health Professions
line
arrow Design
line
arrow Personal Interest
MCCC arrow Culinary
line
arrow Fitness & Recreation
line
arrow Emergency Training
line
arrow Swim
line
arrow James Kerney Campus
MCCC
spacer
arrow CISCO           arrow Cyber Security           arrow Microsoft Office           arrow Certification Prep           arrow PLCs & Mobile Apps
spacer
spacer spacer

Certification Prep

Microsoft Excel 2010 Certification Preparation

Nearly every office environment uses Microsoft Excel and hires individuals who have shown valid proficiency in it. This course is designed to provide the practical knowledge and skills to prepare for the MCAS certification in Excel. You will be using Microsoft-approved independent course materials that cover Introduction, Intermediate and Advanced required levels to pass the exam. Independent “real world” exercises, and additional reinforcement outside of class, are expected for exam preparation.

 

Learn to:

• Navigate through the new Ribbon interface, its Backstage view and the Watch Window

• Use formulas and functions to perform calculations including Lookups

• Link and protect cells, worksheets and workbooks

• Represent data graphically using Charts, Sparklines, the Table app, SmartArt and enhanced conditional formatting

• Record and run Macros, edit Macros using the Visual Basic Application (VBA) Editor

• Import and export data from Excel to other Office platform programs

• Add validation criteria and use forms for data entry

• Create and analyze PivotTables and Pivot Charts with the Slicer technique

• Perform what-if analysis using: Goal Seek, Solver and Scenarios

• Share workbooks

2.7 CEU. Cost: $630 (tuition $249, administrative fee $49, lab fees $332)

Fee includes books and exercise disk. Students to pursue exam on own, if desired.

NCMOS-CS011-01 

November 14 - December 14* 

9 sessions / Mondays & Wednesdays /  6-9pm 

*No class November 23

Instructor: Fabio Iucolino

Microsoft Word 2010 Certification Preparation

Microsoft Word is the most widely used word processing program in businesses today and employers are looking for people who have either a validated proficiency or expert level of certification. This course is designed to provide the practical knowledge and skills needed to prepare for the Microsoft Certified Application Specialist (MCAS) proficient certification in Word. You will be using Microsoft Office Specialist-approved independent courseware which covers Introduction, Intermediate and Advanced required levels to pass the exam. Independent “real world” exercises and additional reinforcement outside of class are expected for exam preparation.

The course begins with a brief recap of Microsoft Word 2010. You will also learn to:

• Navigate through the new Ribbon interface and its Backstage view

• Work with Headers and Footers, Endnotes, Footnotes, Indexes

• Create Hyperlinks, Columns, Building Blocks, Frames, and Watermarks while incorporating the new Table app

• Develop Styles, Forms, envelopes and labels, Master and Subdocuments

• Manage and work with Document Templates

• Use Excel data in Word Tables and perform calculations

• Incorporate diagrams using SmartArt, create Chart graphics, and incorporate new Artistic Effects

• Automate Macros

• Import and export data from Word to other Office platform programs

• Create, track and modify changes using Workgroup collaboration

• Learn Extensible Markup Language (XML)

• Incorporate Mail Merge with Word, Excel, Access, or Outlook data sources

2.7 CEU. Cost: $630 (tuition $249, administrative fee $49, lab fees $332)

Fee includes books and exercise disk. Students to pursue exam on own, if desired.

NCMOS-CS010-01

January 18 - February 15  

9 sessions / Mondays & Wednesdays / 6:30-9:30pm

Instructor: Barbara Daisak


CONTACT US:

Registration Desk: 609-570-3311

Questions: E-mail us.

 

Please note our refund policy:
You will receive 100% refund if cancellation is made 10 or more days before the beginning of a class. 
We cannot refund if cancellation is made less than 10 days before the class start date.


Top of page



spacer
spacer
bottom
spacer
spacer