8
Computer Applications
MS Word for Business
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, reports, newsletters,
flyers and more by utilizing both basic and advanced techniques. (12 Hours) $169
06/07 - 06/28
6:00pm - 9:00pm
W
L
KILROY
TEC 762 80
13725
LC-201
07/12 - 08/02
6:00pm - 9:00pm
W
B
KILROY
TEC 762 30
13728
AR-102
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
05/23 - 07/18
6:00pm - 9:00pm
T
B
TROCHE
TEC 759 30
13745
AR-101
No class week of July 3
MS Excel Beg/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
05/31 - 06/14
6:00pm - 9:00pm
W
B
TROCHE
TEC 760 30
13744
AR-102
06/05 - 06/19
6:00pm - 9:00pm
M
L
TROCHE
TEC 760 80
13746
LC-201
07/19 - 07/26
1:30pm - 4:30pm
W/R
B
TROCHE
TEC 760 35
13748
AR-102
MS Excel Advanced
Learn the advanced capabilities of Excel. 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. Learn
shortcuts, tips and tricks for customizing specific command buttons. This is a hands-
on class. Please bring a flash. This hands-on class will be past-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) $149
07/12 - 07/26
6:00pm - 9:00pm
W
B
TROCHE
TEC 761 30
13747
AR-108
07/27 - 08/03
1:30pm - 4:30pm
W/R
B
TROCHE
TEC 761 35
13749
AR-101
Introduction to Google Analytics. 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. ONLINE COURSE. Classes begin
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
Microsoft SharePoint 2013 Certification
Training. 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. 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. 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. 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
Summer2017-48page.indd 8
24/03/2017 15:18