Excel 2003 - Level 1
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 keyboardinng and computer experience.
1023 CMPA1049-MC: M, 5:30-8:30pm, 2 wks, 10/19-10/26, $120 + $19 materials fee, Methuen
1024 CMPA1049-MD: M, 5:30-8:30pm, 2 wks, 12/7-12/14, $120 + $19 materials fee, Methuen
Excel 2007 - Level 1
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 keyboardinng and computer experience.
557 CMPA1049-NAG: W, 9am-4pm, one day, 6/17, $102 + $19 materials fee + $10 capital fee, North Andover
561 CMPA1049-NAH: Tu, 9am-4pm, one day, 7/14, $102 + $19 materials fee + $10 capital fee, North Andover
582 CMPA1049-NAI: M, 6-9pm, 2 wks, 6/22-6/29, $102 + $19 materials fee + $10 capital fee, North Andover
982 CMPA1049-NAD: Tu, 9am-4pm, one day, 9/22, $120 + $19 materials fee + $10 capital fee, North Andover
989 CMPA1049-NAP: W, 9am-4pm, one day, 10/21, $120 + $19 materials fee + $10 capital fee, North Andover
990 CMPA1049-NAQ: Th, 9am-4pm, one day, 11/19, $120 + $19 materials fee + $10 capital fee, North Andover
991 CMPA1049-NAR: Tu, 9am-4pm, one day, 12/22, $120 + $19 materials fee + $10 capital fee, North Andover
1019 CMPA1049-NAS: Th, 6-9pm, 2 wks, 9/24-10/1, $120 + $19 materials fee + $10 capital fee, North Andover
1020 CMPA1049-NAT: M, 6-9pm, 2 wks, 11/2-11/9, $120 + $19 materials fee + $10 capital fee, North Andover
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.
1031 CMPA1050-MAA: M, 5:30-8:30pm, 2 wks, 11/9-11/16, $120 + $19 materials fee, Methuen
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.
568 CMPA1050-NAF: W, 9am-4pm, one day, 7/22, $102 + $19 materials fee + $10 capital fee, North Andover
583 CMPA1050-NAG: M, 6-9pm, 2 wks,7/27-8/3, $102 + $19 materials fee + $10 capital fee, North Andover
993 CMPA1050-NAK: Tu, 9am-4pm, one day, 10/6, $120 + $19 materials fee + $10 capital fee, North Andover
994 CMPA1050-NAL: W, 9am-4pm, one day, 11/4, $120 + $19 materials fee + $10 capital fee, North Andover
995 CMPA1050-NAM: Th, 9am-4pm, one day, 12/3, $120 + $19 materials fee + $10 capital fee, North Andover
1022 CMPA1050-NAN: M, 6-9pm, 2 wks,11/23-11/30, $120 + $19 materials fee + $10 capital fee, North Andover
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
569 CMPA1051-NAD: Tu, 9am-4pm, one day, 7/28, $102 + $19 materials fee + $10 capital fee, North Andover
997 CMPA1051-NAH: Tu, 9am-4pm, one day, 10/13, $120 + $19 materials fee + $10 capital fee, North Andover
1001 CMPA1051-NAI: W, 9am-4pm, one day, 12/16, $120 + $19 materials fee + $10 capital fee, North Andover