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 any in-class work.
NEW! PowerPoint for Professional
PowerPoint for Professionals will cover creating PowerPoint files, modifying, inserting objects, advanced tools, slide masters, and enhancing charts. Learn how PowerPoint can enhance your presentation skills and help you effectively communicate your ideas. (9 Hours) $149
03/01 - 03/15 9:00am - 12:00pm F L KILROY
TEC 777 80 19556 LC 201
04/24 - 05/08 6:00pm - 9:00pm W B TROCHE
TEC 777 30 19557 NA 103
Business Computer Applications 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, and presentation,
and calendar software packages. These tools are commonly used in most work environments
today. (24 hours) $299
01/22 - 03/12 5:00pm - 8:00pm T
B KELLEY
TEC 748 30 18161 AR 102
03/28 - 05/16 6:00pm - 9:00pm R
L KILROY
TEC 748 80 18162 LC 201
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, and the Internet. (12 hours) $169
02/01 - 02/22 9:00am - 12:00pm F
B KILROY
TEC 602 30 12252 NA
102
04/22 - 05/13 5:00pm - 8:00pm M
B KELLEY
TEC 602 31 19555 AR
107
_____________________________________________________________________________________________
MS Excel Certificate
From beginning to advanced functions of MS Excel, 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
02/26 - 04/23 6:00pm - 9:00pm T
B TROCHE
TEC 759 30 18737 AR
101
No class March 19
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
02/20 - 03/06 6:00pm - 9:00pm W
B TROCHE
TEC 760 30 18738
AR 102
MS Excel Advanced
Topics will include using built-in functions such as V-LOOKUP, SUMIF, COUNTIF, INDEX,
MATCH and IF; combining multiple built-in functions; Searching data tables; creating
basic macros; building pivot tables to analyze data, conditional formatting for charts
and graphs. Please bring a flash drive to class. This hands-on class will be fast-paced
and will build on intermediate skills. Pre-Req: relative vs. absolute cell reference,
conditional formatting, filtering and sorting and basic functions like CONCATENATE,
PROPER and COUNTIFS. (9 hours) $129
03/27 - 04/10 6:00pm - 9:00pm
W B TROCHE
TEC 761 30 18739
AR 102
MS Excel Advanced Part II with VBA
Take your MS Excel Advanced skills to the next level! This class will cover creating
macros using the Macro recorder, as well as editing and programming macros with the
VBA editor. Learn to automate processes such as creating a logo or importing a data
file. Topics covered: Use the VBA editor to examine and edit code; Create Quick Access
Toolbar Buttons to run macros; Customize the Ribbon to add groups and commands to
run macros and make features that are not on the Ribbon accessible; Use the Editor
to create and name your own customized Functions. Prerequisite: Proficient with creating
and using formulas, using standard Functions, utilizing relative and absolute cell
references in formulas and functions. No programming experience necessary. (12 Hours)
$169
03/06 - 04/03 6:00pm - 9:00pm W
B PARTLAN
TEC 778 30 19565
AR 108
No class March 20
______________________________________________________________________________________________
Intro to SQL
This class will introduce students to basic relational database concepts using Structured
Query Language (SQL) to create, modify, and access database information. You will
learn to write queries to retrieve, order, filter and aggregate data from a single
table, as well as queries on multiple tables. SQL statements and clauses taught in
this course include: CREATE, DROP, INSERT, UPDATE, DELETE, SELECT, DISTINCT, WHERE,
ORDER BY, GROUP BY, HAVING, and JOIN. This course is appropriate for those you want
to learn relational databases and/or whose jobs require them to work with relational
databases. Students will perform hands-on practice exercises using SQL. This is an
intro class and is not a certification exam prep. Textbook requirement TBA approx.
$40. $360.
Choose from 2 sections:
03/22 - 04/05 9:00am - 3:30pm F
B BLEICHMAN
TEC 773 35 19527
03/26 - 04/23 4:00pm - 7:30pm T
B BLEICHMAN
TEC 773 30 19526 AR 107
________________________________________________________________________________________________
Comp TIA A + Exam Prep
CompTIA A+ Certification is the foundation of your IT career.
In the CompTIA A+ complete class students will gain the knowledge needed to sit for
the CompTIA A+ certification exam, which is the preferred industry qualifying credentials
for technical support and IT operations roles. This complete course focuses on both
901 and 902 exams and is much more than just a PC repair class. After successful completion
of this class candidates are better prepared to troubleshoot problem solve and understand
a wide variety of issues ranging from networking, operating systems mobile devices
and security.
This 7 week course is designed for individuals who have basic computer user skills
and who are interested in obtaining a job as an entry-level IT technician. This course
is also designed for students who are seeking the CompTIA A+ certification and who
want to prepare for the CompTIA A+ 220-901 Certification Exam and the CompTIA 220-902
Certification Exam. Prerequisites: Basic computer user skills, be able to complete
tasks in a Microsoft Windows environment, be able to search for, browse, and access
information on the Internet, and have basic knowledge of computing concepts. (60 Hours)
$899
03/04 - 05/08 5:30pm - 9:30pm M/W
B BOWEN JR
TEC 706 30 19553
NA 102
No Class March 18 & 20, April 15
__________________________________________________________________________________________________
UPDATED Cybersecurity for Managers
Data security breaches and cybercrime are increasing at an alarming rate, and in addition
to threatening a business’s critical information, they threaten our very way of life
in a digital world. This introductory course is designed to give the non-security
focused IT administrator or Manager an introduction to the concepts and terminology
that comprise cybersecurity today so they can ensure their organization is prepared
to protect its critical information assets. (12 Hours) $199
04/02 - 04/23 6:00pm - 9:00pm
T B BOWEN JR
TEC 766 30 19554
AR 102
ONLINE COURSES
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 EMAIL
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