Computer and Career Classes

Our computer lab is open to the public and free of charge. Hours are Monday, Tuesday & Wednesday 3:00-5:00 pm and Thursday evenings 5:00-7:00 p.m. Room 301, McConnell Center, 61 Locust Street, Dover, NH. except on holidays and during school vacations. (Also closed Thursdays, Oct 10, Nov 7 & Dec 12)


  •  Small, Instructor-led Classes
  •  Individual Attention
  •  Hands on Instruction
  •  Supervised Practice


For cancellation policy, please visit our Enrichment Class page

Advanced Formulas

Tuition: $65.00 Dover Residents: $60.00

Date: Friday, November 22, 2019

Time: 9:00 am - 12:00 pm

Prerequisite: Excel Formulas

Data validation, VLOOKUP with data validation, formula for data validation with conditional formatting, more lookup functions (ie index, match), mixed absolute references, advanced SUMIF, intro to array formulas, more as time allows!

McConnell Center Computer Lab, Room 301


Taught by:

Nancy Bernier Little

Nancy has been an instructor for the Dover Adult Learning Center since 2002, delivering both classroom and individual Microsoft Office training.  She is endorsed by her students as professional, patient and knowledgeable. In addition to teaching at our facility, she also conducts on-site Microsoft Office trainings for local businesses. For more information on class content, please visit Nancy’s webpage @  If you are a current Microsoft Office user and wish to book some time for a consult on your particular needs, please complete the Contact Us form provided on Nancy's website.


McConnell Center
61 Locust St, Floor 2
Dover, NH
03820 Map and Directions

Available Spaces: 9

No events available...