This site is best viewed in Firefox, Chrome, Safari, or EdgeX

Please email Sandy Zappala with questions at szappala@necc.mass.edu

 Introduction to Excel 2016- LIVE REMOTE, NEW!

Learn spreadsheet basics and design, including creating, editing, formatting, and printing. Use formulas and functions containing cell references to automate calculations. We also cover Excel charting features. Students should have keyboarding and computer experience.

Instructor

Jay Partlan, experienced computer instructor

Course Information (Select One)

September 8, Tuesday, 9:00 am to 4:00 pm, 1 day
Dates/Time: Tuesday, 9:00 am to 4:00 pm, 1 day, 9/8
Location: Online
Cost: $139
CRN: 488 Course Number: CMPA1049 Section: OWF
September 8 to September 15, Tuesdays, 6:00 pm to 9:00 pm, 2 weeks
Dates/Time: Tuesdays, 6:00 pm to 9:00 pm, 2 weeks, 9/8 to 9/15
Location: Online
Cost: $139
CRN:487 Course Number: CMPA1049 Section: OWE

 

Back to top

 Intermediate Excel 2016- LIVE REMOTE, NEW!

Learn techniques for large spreadsheets such as freezing headings. We examine the solver tool, IF function, references between worksheets and workbooks, sorting data, cell and range formatting, creating, editing and customizing charts, absolute and relative cell references, using named ranges, and creating a template.

Instructor

Jay Partlan, experienced computer instructor

Course Information (Select One)

September 15, Tuesday, 9:00 am to 4:00 pm, 1 day
Dates/Time: Tuesday, 9:00 am to 4:00 pm, 1 day, 9/15
Location: Online
Cost: $139
CRN: 490 Course Number: CMPA1050 Section: OWF
September 22 to September 29, Tuesdays, 6:00 pm to 9:00 pm, 2 weeks
Dates/Time: Tuesdays, 6:00 pm to 9:00 pm, 2 weeks, 9/22 to 9/29
Location: Online
Cost: $139
CRN: 489 Course Number: CMPA1050 Section: OWE

Back to top

Advanced Excel 2016- LIVE REMOTE, NEW!

Learn to use lookup functions, pivot tables, and macros. Utilize advanced formatting and analysis tools, use Visual Basic editing to modify a macro, and create user defined functions.

Instructor

Jay Partlan, experienced computer instructor

Course Information (Select One)

September 29, Tuesday, 9:00 am to 4:00 pm, one day

Dates/Time: Tuesday, 9:00 am to 4:00 pm, one day, 9/29
Location: Online
Cost: $139
CRN: 498 Course Number: CMPA1051 Section: OWF

October 6 to October 13, Tuesdays, 6:00 pm to 9:00 pm, two weeks

Dates/Time: Tuesdays, 6:00 pm to 9:00 pm, two weeks, 10/6 to 10/13
Location: Online
Cost: $139
CRN: 497 Course Number: CMPA1051 Section: OWE

Excel 2016- Advanced Topics *

This class will cover some advanced Excel topics, including text concatenation methods, data analysis tools, conditional formatting, 3-D references, formula auditing/error tracking, data tables, and pivot table techniques. Participants are invited to suggest topics and to bring spreadsheets to analyze in class.

Instructor

Jay Partlan, experienced computer instructor

Course Information

May be offered in the future

Dates/Time:
Location:
Cost:
CRN:  Course Number:  Section:

 

Back to top

 

Print viewPrint View
Get Map and Diretions on Google