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

Last Modified: 11/15/18