Excel 2010 – Level I

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.

195 CMPA1049-RWC: W, 9am-4pm, one day, 4/4, $135 + $23 materials fee + $10 capital fee, Riverwalk
406 CMPA1049-RWG: M, 6-9pm, 2 wks, 4/23-4/30, $135 + $23 materials fee + $10 capital fee, Riverwalk
197 CMPA1049-RWD: Th, 9am-4pm, one day, 5/17, $135 + $23 materials fee + $10 capital fee, Riverwalk
255 CMPA1049-RWE: M, 9am-4pm, one day, 6/25, $135 + $23 materials fee + $10 capital fee, Riverwalk
535 CMPA1049-RWH: M, 6-9pm, 2 wks, 7/9-7/16, $135 + $23 materials fee + $10 capital fee, Riverwalk

Excel 2010 – Level 2

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.

257 CMPA1050-RWB: Tu, 9am-4pm, one day, 3/20, $135 + $23 materials fee + $10 capital fee, Riverwalk
258 CMPA1050-RWC: W, 9am-4pm, one day, 4/25, $135 + $23 materials fee + $10 capital fee, Riverwalk
408 CMPA1050-RWF: M, 6-9pm, 2 wks, 5/14-5/23, $135 + $23 materials fee + $10 capital fee, Riverwalk
259 CMPA1050-RWD: Th, 9am-4pm, one day, 6/7, $135 + $23 materials fee + $10 capital fee, Riverwalk
536 CMPA1050-RWH: M, 6-9pm, 2 wks, 7/23-7/30, $135 + $23 materials fee + $10 capital fee, Riverwalk
527 CMPA1050-RWG: Tu, 9am-4pm, one day, 7/24, $135 + $23 materials fee + $10 capital fee, Riverwalk

Excel 2010 – Level 3

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

261 CMPA1051-RWB: Tu, 9am-4pm, one day, 4/10, $135 + $23 materials fee + $10 capital fee, Riverwalk
409 CMPA1051-RWD: M, 6-9pm, 2 wks, 6/4-6/11, $135 + $23 materials fee + $10 capital fee, Riverwalk
262 CMPA1051-RWC: Th, 9am-4pm, one day, 6/14, $135 + $23 materials fee + $10 capital fee, Riverwalk

  Excel 2010 – 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 tracing, data tables and Pivot Table techniques.  Participants are invited to suggest topics and to bring spreadsheets to analyze in class.

264 CMPA1127-RWB: Th, 9am-4pm, one day, 6/21, $135 + $10 capital fee, Riverwalk