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

Excel Courses

  • Introduction to Excel 2016
  • Intermediate Excel 2016
  • Advanced Excel 2016
  • Advanced Topics Excel 2016

Materials Fee

Please note that some instructors prefer to use a textbook in the course (which is why there is a materials fee associated with some courses and not others), while other instructors provide their own handouts and materials to students. If a materials fee is noted in the course selection as part of the cost, students will receive the required textbook in class.

Introduction to Excel 2016

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)

May 29, Wednesday, 9:00 am to 4:00 pm, one day
Dates/Time: Wednesday, 9:00 am to 4:00 pm, 1 day, 5/29
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 228 Course Number: CMPA1049 Section: OWD
September 4, Wednesday, 9:00 am to 4:00 pm, one day
Dates/Time: Wednesday, 9:00 am to 4:00 pm, 1 day, 9/4
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 515 Course Number: CMPA1049 Section: OWE
September 4 to September 11, Wednesdays, 6:00 pm to 9:00 pm, 2 weeks
Dates/Time: Wednesdays, 6:00 pm to 9:00 pm, 2 weeks, 9/4 to 9/11
Location: Haverhill
Cost: $139 + $10 capital fee
CRN:516 Course Number: CMPA1049 Section: OWF
October 29, Tuesday, 9:00 am to 4:00 pm, one day
Dates/Time: Tuesday, 9:00 am to 4:00 pm, 1 day, 10/29
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 517 Course Number: CMPA1049 Section: OWG

 

Back to top

Intermediate Excel 2016

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 11, Wednesday, 9:00 am to 4:00 pm, one day
Dates/Time: Wednesday, 9:00 am to 4:00 pm, one day, 9/11
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 518 Course Number: CMPA1050 Section: OWE
September 18 to September 25, Wednesday, 6:00 pm to 9:00 pm, 2 weeks
Dates/Time: Wednesdays, 6:00 pm to 9:00 pm, 2 weeks, 9/18 to 9/25
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 519 Course Number: CMPA1050 Section: OWF
November 5, Tuesday, 9:00 am to 4:00 pm, one day
Dates/Time: Tuesday, 9:00 am to 4:00 pm, one day, 11/5
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 520 Course Number: CMPA1050 Section: OWG

Back to top

Advanced Excel 2016

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 20, Friday, 9:00 am to 4:00 pm, one day

Dates/Time: Friday, 9:00 am to 4:00 pm, one day, 9/20
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 521 Course Number: CMPA1051 Section: OWE

October 3 to October 10, Thursdays, 6:00 pm to 9:00 pm, two weeks

Dates/Time: Thursdays, 6:00 pm to 9:00 pm, two weeks, 10/3 to 10/10
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 522 Course Number: CMPA1051 Section: OWF

November 19, Tuesday, 9:00 am to 4:00 pm, one day

Dates/Time: Tuesday, 9:00 am to 4:00 pm, one day, 11/19
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 523 Course Number: CMPA1051 Section: OWG

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 Winter/Spring 2020

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

 

Back to top

 

Print viewPrint View
Get Map and Diretions on Google