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)

January 6 to January 13, Monday, 6:00 pm to 9:00 pm, 2 weeks
Dates/Time: Monday, 6:00 pm to 9:00 pm, 2 weeks, 1/6 to 1/13
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 200 Course Number: CMPA1049 Section: OWA
January 8, Wednesdays, 9:00 am to 4:00 pm, one day
Dates/Time: Wednesday, 9:00 am to 4:00 pm, one day, 1/8
Location: Haverhill
Cost: $139 + $10 capital fee
CRN:201 Course Number: CMPA1049 Section: OWB
May 20, Wednesday, 9:00 am to 4:00 pm, one day
Dates/Time: Wednesday, 9:00 am to 4:00 pm, 1 day, 5/20
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 218 Course Number: CMPA1049 Section: OWC
July 7, Tuesday, 9:00 am to 4:00 pm, one day
Dates/Time: Tuesday, 9:00 am to 4:00 pm, 1 day, 7/7
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 221 Course Number: CMPA1049 Section: OWD

 

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)

January 15, Wednesday, 9:00 am to 4:00 pm, one day
Dates/Time: Wednesday, 9:00 am to 4:00 pm, one day, 1/15
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 203 Course Number: CMPA1050 Section: OWB
January 27 to February 3, Monday, 6:00 pm to 9:00 pm, 2 weeks
Dates/Time: Mondays, 6:00 pm to 9:00 pm, 2 weeks, 1/27 to 2/3
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 202 Course Number: CMPA1050 Section: OWA
May 27, Wednesday, 9:00 am to 4:00 pm, one day
Dates/Time: Wednesday, 9:00 am to 4:00 pm, one day, 5/27
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 219 Course Number: CMPA1050 Section: OWC
July 14, Tuesday, 9:00 am to 4:00 pm, one day
Dates/Time: Tuesday, 9:00 am to 4:00 pm, one day, 7/14
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 222 Course Number: CMPA1050 Section: OWD

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)

January 22, Wednesday, 9:00 am to 4:00 pm, one day

Dates/Time: Wednesday, 9:00 am to 4:00 pm, one day, 1/22
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 211 Course Number: CMPA1051 Section: OWB

February 10 to February 24, Monday, 6:00 pm to 9:00 pm, two weeks (no class 2/17)

Dates/Time: Monday, 6:00 pm to 9:00 pm, two weeks, 2/10 to 2/24 (no class 2/17)
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 210 Course Number: CMPA1051 Section: OWA

June 3, Wednesday, 9:00 am to 4:00 pm, one day

Dates/Time: Wednesday, 9:00 am to 4:00 pm, one day, 6/3
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 220 Course Number: CMPA1051 Section: OWC

July 21, Tuesday, 9:00 am to 4:00 pm, one day

Dates/Time: Tuesday, 9:00 am to 4:00 pm, one day, 7/21
Location: Haverhill
Cost: $139 + $10 capital fee
CRN: 223 Course Number: CMPA1051 Section: OWD

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