Home » Academics » Course & Program Information » Noncredit Courses & Programs » Computer Training » Microsoft Office » Excel

Excel

Excel Courses:

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.

Summer Course Information: Note: This course will be instructed using version 2013 of Excel

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 8/1

Location: Riverwalk

Cost: $139 + $10 capital fee

CRN: 172 Course Number:  CMPA1049 Section: RWC

Fall Course Information (Select One):

Course One Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 9/12

Location: Haverhill

Cost: $139 + $10 capital fee

CRN: 622 Course Number:  CMPA1049 Section: OWA

Course Two Information

Instructor: Kim Campion

Dates/Time: Wednesday, 6:00 p.m. – 9:00 p.m., 2 weeks, 9/27-10/4

Location: Haverhill

Cost: $139 + $38 materials fee + $10 capital fee

CRN: 623 Course Number: CMPA1049 Section: OWB

Course Three Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 10/24

Location: Haverhill

Cost: $139 + $10 capital fee

CRN: 624 Course Number: CMPA1049 Section: OWC

 

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.

Summer Course Information: Note: This course will be instructed using version 2013 of Excel

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 8/8

Location: Riverwalk

Cost: $139 + $10 capital fee

CRN: 175 Course Number: CMPA1050 Section: RWC

Fall Course Information (Select One):

Course One Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 9/19

Location: Haverhill

Cost: $139 + $10 capital fee

CRN: 625 Course Number:  CMPA1050 Section: OWA

Course Two Information

Instructor: Kim Campion

Dates/Time: Wednesday, 6:00 p.m. – 9:00 p.m., 2 weeks, 10/11-10/18

Location: Haverhill

Cost: $139 + $38 materials fee + $10 capital fee

CRN: 626 Course Number:  CMPA1050 Section: OWB

Course Three Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 10/31

Location: Haverhill

Cost: $139 + $10 capital fee

CRN: 627 Course Number: CMPA1050 Section: OWC

 

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.

Summer Course Information: Note: This course will be instructed using version 2013 of Excel

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 8/15

Location: Riverwalk

Cost: $139 + $10 capital fee

CRN: 178 Course Number: CMPA1051 Section: RWC

Fall Course Information (Select One):

Course One Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 9/26

Location: Haverhill

Cost: $139 + $10 capital fee

CRN: 628 Course Number: CMPA1051 Section: OWA

Course Two Information

Instructor: Kim Campion

Dates/Time: Wednesday, 6:00 p.m. – 9:00 p.m., 2 weeks, 11/1-11/8

Location: Haverhill

Cost: $139 + $38 materials fee + $10 capital fee

CRN: 629 Course Number:  CMPA1051 Section: OWB

Course Three Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 11/7

Location: Haverhill

Cost: $139 + $10 capital fee

CRN: 630 Course Number: CMPA1051 Section: OWC

 

Back to top


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.

Course Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 a.m. – 4:00 p.m., one day, 11/14

Location: Haverhill

Cost: $139 + $10 capital fee

CRN: 631 Course Number: CMPA1127 Section: OWA

Back to top