Computer Training
NOTE: All on campus instructor-led computer training uses MS Office Suite 2016; MS
Windows.
Please bring a flash drive to all computer classes to save your work.
MS Excel –Beginning/Intermediate
This comprehensive course provides the in-depth, hands-on instruction needed to work
with Microsoft Excel. In this class students will learn the fundamentals of creating
workbooks, performing calculations, using built-in formulas, formatting the worksheet,
combining, sorting, and summarizing data, working with charts and printing. Participants
must be proficient with MS Windows / keyboarding. Please bring a flash drive to class.
(9 hours) $149. No class October 10
10/03 - 10/24 6:00pm - 9:00pm M B TROCHE
TEC 703 30 14802 AR-108
No class 10/10
Revised class: MS Excel Advanced
This course explores the advanced capabilities of Microsoft Excel. Topics will include
using built-in functions such as V-LOOKUP, SUMIF, COUNTIF, INDEX, MATCH and IF; combining
multiple built-in functions to perform specify tasks; exploring the multiple uses
of V-LOOK-UP and the difference between V-LOOKUP and INDEX & MATCH to search data
tables; creating basic macros to perform repetitive tasks; building pivot tables to
analyze data, applying conditional formatting to identify and highlight specific data
and further investigating charts and graphs. In addition to learning shortcuts, tips
and tricks will be shared for customizing and efficiently organizing specific command
button on toolbars and the ribbon. Each session will have hands-on examples. Please
bring a flash drive to class. This advanced class builds on intermediate Excel skills
and will progress at a fast-pace. Students should be knowledgeable about topics such
as relative vs. absolute cell reference, conditional formatting, filtering and sorting
and basic functions like CONCATENATE, PROPER and COUNTIF vs COUNTIFS. (9 hours) $129
10/31 - 11/14 6:00pm - 9:00pm M B TROCHE
TEC 704 30 14803 AR-108
11/03 - 11/17 6:00pm - 9:00pm R L TROCHE
TEC 704 80 16603 LC-202
MS Excel Certificate
From beginning to advanced functions of MS Excel 2013, prepare yourself for the workforce
demands as you become proficient with Microsoft Excel. Whether you have used MS Excel
before and just want to learn more about Excel or are completely new to the program,
this course is designed to teach you the features of MS Excel to have you using it
like a pro from beginning to advanced functions. The business and personal uses of
the Microsoft Excel program are endless. This program will give you a powerful set
of skills to help you with career advancement. Upon successful completion you will
be able to: create and format a worksheet; create formulas; manipulate and calculate
data with advanced formulas, create and modify tables, present data with charts, analyze
data using PivotTables, customize data, work with multiple workbooks, import and export
data. Pre-Req: Students must be proficient in a MS Windows environment with keyboarding
skills. Please bring a flash drive to class. (24 hours) $299
10/05 - 11/30 6p - 9p Wed B TROCHE
TEC 724-30 14383 AR-108
No class 11/23
Practical Computers - An Intro to PC's and Windows
Practical Computers - An Intro to PC's and Windows This course is an introduction
to the computer and computer applications via lecture and hands-on activities. We
start with an overview of computer hardware, software, and networks that includes
the use of Microsoft Windows for running programs, the creation of folders, and file
management. We continue with a focus on Microsoft Word, Microsoft Excel, Microsoft
PowerPoint, Email, and the Internet. (12 hours) $169
09/15 - 10/13 6:00pm - 9:00pm R L KILROY
TEC 602 80 11393 LC 201
11/15 - 12/13 6:00pm - 9:00pm T B KELLEY
TEC 602 30 11390 AR 102
Business Computer Application Certificate
This certificate course will prepare you for a position in offices where proficiency
in software such as Microsoft Office suite is used. These positions include administrative
assistant, customer service or data entry. Students will become proficient in computer
skills such as file & folder management, system backup, device/printer setup, internet
basics, password management along with word processing, spreadsheet, presentation,
mail and calendar software packages. These tools are commonly used in most work environments
today. (24 hours) $349
09/20 - 11/08 6:00pm - 9:00pm T B KELLEY
TEC 748 30 16128 AR 102
10/20 - 12/15 6:00pm - 9:00pm R L KILROY
TEC 748 80 16129 LC 201
MS Word Certificate
Microsoft Word is a powerful and popular word processing program most professionals
use in the business world. This course will provide the necessary skills for creating
professional and eye-catching documents by utilizing both basic and advanced techniques.
This certificate provides students with a powerful set of abilities to help them with
career advancement.
Upon successful completion of this course, students will be able to create and format documents as small as business cards and as large as complete business policy manuals, marketing materials, and customized materials. During each class, students will be challenged to produce business documents, flyers, training handouts, resume and cover letters, multi-column newsletters, mailing labels, and envelopes. The student will also become proficient in mass mailings, multilevel lists, and charts, professional looking tables, creating web content and standardized forms.
The skills students will learn and apply in order to create the above documents include
designing and formatting documents, page layout features, use of mailing feature,
viewing documents side by side, print layout mode, and web layout mode. Please bring
a flash drive to class. (24 Hours) $349
9/13 - 11/1 6p - 9p T Bedford KILROY
TEC 751-30 16187 NA-102
PC Security Fundamentals
In this course you will learn how to use your computer and related devices in a secure
manner while safeguarding your privacy. Learn how to dramatically lessen your chances
of credit card fraud, hacking, identity theft, virus’s and related dangers. As well
as how and why your online activities are tracked and analyzed. You will become aware
of strategies for managing your Internet connection, web browsing, email, chatting,
social media, and file sharing. This course will cover how to download and upload
files safely with an emphasis on avoiding downloads containing possible viruses. Learn
how to create strong passwords in order to better protect your online activities.
This course will cover how to clear your browsing history, clear cookies and online
forms, Recycle Bin, Spam folder, and Trash folder as well as what happens to your
deleted files. Many of the topics that will be covered apply across the various platforms
but this course's primary focus will be the Windows platform. It will cover computers,
tablets, cell phones, and removable drives. (15 Hours) $249
09/15 - 10/13 6:00pm - 9:00pm R B KELLEY
TEC 755 30 16627 AR 102
Introduction to Google Analytics. Course # EDG 757
In this ONLINE course, you’ll learn to use Google Analytics to make the most of your
online web traffic. See how you can track not just the traffic to all of your online
content, but also determine which content is the most appealing, where your visitors
came from, what devices they used, how long they stayed, which links they clicked,
and where they went when they left. The ONLINE course guides you step by step, report
by report, through the major parts of the Google Analytics interface. From setting
up your Google Analytics account and getting the all-important code you’ll need to
add to your website’s pages to begin tracking your visitors, you’ll learn everything
you need to know to get everything you can from the data that Google Analytics provides.
You’ll even find out about Google AdWords and other tools to enhance your traffic as well as your Google Analytics reporting. ONLINE COURSE. Classes begin monthly. (24 hours.) $130 To enroll: Step 1: www.ed2go.com/mcc to complete the online registration for your selected course. Step 2: Call MCC enrollment at 1800-818-3434 to complete payment. Classes begin monthly. Not eligible for tuition waivers. For questions, e-mail career_training@middlesex.mass.edu
Microsoft SharePoint 2013 Certification Training. Course # GES 852
In this ONLINE course you will begin with an introduction to SharePoint versions,
layouts, and navigation and basics such as list and library views. Learn to manage
sites and page content, including wiki pages. Practice working within forms libraries,
creating InfoPath forms, and managing site columns and content types. Finally, experience
SharePoint integration with Office applications, manage SharePoint site permissions,
and participate in user communities.
During the second part of the program, learn the fundamentals of managing SharePoint
sites. Create custom workflows, learn to use content approval settings, and work with
Metadata. You will learn about business connectivity services, information management
policies, and the organization of content using settings and rules. With these new
skills, manage comprehensive sections on the Document ID Service, document sets, publish
to a server, and configure and consume site search results. Only PC, not MAC compatible.
Not eligible for waivers. To enroll or for pre-req info call 877-221-5151. ONLINE.
(82 hours). $795
The Administrative Professional with Microsoft Office 2013 Master. Course # GES 842
This program teaches the basic and necessary skills to work as an Administrative Professional,
including the proficiencies required to work with four major Microsoft Office programs:
Word, Excel, PowerPoint, and Outlook. The program also prepares you for the Microsoft
Certification Exams 77-418, 77-425, and 77-426 (Word), 77-420, 77-427, and 77-428
(Excel), 77-422 (PowerPoint), and 77-423 (Outlook).
You will learn essential skills including how to work in a modern professional office, how to maintain a professional image, personal and professional ethics, communication essentials, technology basics, records and financial management, event planning and travel, and how to achieve career advancement. Not Mac compatible. Questions or to enroll call (877) 221-5151. Not eligible for tuition waivers. ONLINE Course. (445 hours). $1,995
Intro to MS Access 2010. Course # EDG 911
Take control over your data! In these practical and project-oriented lessons, you’ll
learn to create and customize tables. You’ll build relationships between your tables
to eliminate redundancies and slash data entry time. And you’ll discover how to achieve
huge reductions in data entry errors by setting default values, creating validation
rules, and building input masks. ONLINE COURSE. Classes begin monthly. (24 hours).
$130. To enroll: Step 1: www.ed2go.com/mcc to complete the online registration for
your selected course. Step 2: Call MCC enrollment at 1800-818-3434 to complete payment.
Classes begin monthly. Not eligible for tuition waivers. For questions, 781-280-3663
or career_training@middlesex.mass.edu
MS Word 2013. Course # GES 839
This Microsoft Word 2013 (MOS) ONLINE course teaches you Word 2013 fundamentals, while
preparing you for the Microsoft Office Specialist (MOS) Certification Exam 77-418.
Some of the topics covered: basic navigation skills, such as working with the Ribbon
and File tab; creating documents and templates, formatting documents; using advanced
editing tools; working with document views, including viewing multiple windows. You
will also learn to work with comments and track changes, compare and combine documents,
use mail merge, and protect documents and restrict formatting and editing. To enroll
or questions, call 877-221-5151. Not eligible for tuition waivers. ONLINE. (70 hours)
$595
