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

Excel

Excel Courses:


Introduction to Excel 2013

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.

Course One Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 am – 4:00 pm, one day, 1/20

Location: Riverwalk

Cost: $139 + $10 capital fee

CRN: 241 Course Number:  CMPA1049 Section: RWA

Course Two Information

Instructor: Kim Campion

Dates/Time: Wednesday, 1:00 am – 4:00 pm, 1/28 and 2/4 (Please note: Due to the blizzard, this class is now taking place on Wednesday, 2/4, from 9:00 am – 4:00 pm. Contact Christine DeRosa directly at 978-659-1225 to enroll in this section.)

Location: Riverwalk

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

CRN: 242 Course Number:  CMPA1049 Section: RWB

Course Three Information

Instructor: Joanne Lauzon

Dates/Time: Tuesday, 6:00 – 9:00 pm, 2 wks, 3/10-3/17

Location: Riverwalk

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

CRN: 243 Course Number:  CMPA1049 Section: RWC

Back to top


Intermediate Excel 2013

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.

Course One Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 am – 4:00 pm, one day, 1/27 (Please note: Due to the blizzard and the snowstorm, this class is now taking place on Friday, 2/6. Contact Christine DeRosa directly at 978-659-1225 to enroll in this section.)

Location: Riverwalk

Cost: $139 + $10 capital fee

CRN: 244 Course Number:  CMPA1050 Section: RWA

Course Two Information

Instructor: Kim Campion

Dates/Time: Wednesday, 9:00 am to 4:00 pm, 1 day, 3/4 (Please Note: This class was originally scheduled to take place over a two-week period from 3/4-3/11,  however, it will now be a one-day class on 3/4.)

Location: Riverwalk

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

CRN: 245 Course Number:  CMPA1050 Section: RWB

Course Three Information

Instructor: Joanne Lauzon

Dates/Time: Tuesday, 6:00 – 9:00 pm, 2 wks, 4/21-4/28

Location: Riverwalk

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

CRN: 246 Course Number:  CMPA1050 Section: RWC

Back to top


Advanced Excel 2013

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, has taught credit and non-credit courses at UNH, Granite State College, Northern Essex Community College, New Hampshire Community Technical College, and Newbury College.

Course One Information

Instructor: Jay Partlan

Dates/Time: Tuesday, 9:00 am – 4:00 pm, one day, 2/17

Location: Riverwalk

Cost: $139 + $10 capital fee

CRN: 420 Course Number: CMPA1051 Section: RWC

Course Two Information

Instructor: Kim Campion

Dates/Time: Tuesday, 9:00 am – 4:00  pm, one day, 4/7

Location: Riverwalk

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

CRN: 248 Course Number: CMPA1051 Section: RWB

Back to top


Excel 2013: 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 am – 4:00 pm, one day, 2/24

Location: Riverwalk

Cost: $139 + $10 capital fee

CRN: 421 Course Number: CMPA1127 Section: RWB

Back to top