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)

MICROSOFT PROFESSIONAL TRACK EXCEL CLASSES

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

 

For cancellation policy, please visit our Enrichment Class page

Visualize and Present

Tuition: $65.00 Dover Residents: $60.00

Date: Friday, October 25, 2019

Time: 9:00 am - 12:00 pm

Prerequisite: Excel Intro or equivalent experience

Review of Excel tables, intro to pivot tables, intro to charts & slicers, intro to conditional formatting

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 @ http://www.alittleclass.net.  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.

Website: http://www.alittleclass.net

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

Available Spaces: 9

Quickbooks

Tuition: $90.00 Dover Residents: $85.00

Start Date: Saturday, November 2, 2019
End Date: Saturday, November 9, 2019

Time: 10:00 am - 12:00 pm

Learn how to set up QuickBooks from the beginning: Chart of Account, Customers (creating invoices, coding, paying invoices, printing checks), Vendors (entering invoices, coding, paying invoices, printing checks), Reconciling Accounts (checking, savings, credit cards), Reports (Profit & Loss, Sales by item list, A/R, A/P aging), plus basic bookkeeping skills.

McConnell Center, Room 301

Taught by:

Monica Bozeman

Monica has over 35 years working in administration and bookkeeping roll in various industries as well as a former business owner and real estate broker.  She currently is employed as an Office Administrator and their full-charge bookkeeper. Additionally she does freelance bookkeeping and provides QuickBooks tutoring services for the past three years.

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

Available Spaces: 7

Advanced Pivot Tables

Tuition: $65.00 Dover Residents: $60.00

Date: Friday, November 8, 2019

Time: 9:00 am - 12:00 pm

Prerequisite: Visualize & Present

Setting up your data source, various ways to summarize data, review of slicers, calculating within a pivot table, custom grouping, intro to dashboards

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 @ http://www.alittleclass.net.  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.

Website: http://www.alittleclass.net

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

Available Spaces: 9

Advanced Charts

Tuition: $65.00 Dover Residents: $60.00

Date: Friday, November 15, 2019

Time: 9:00 am - 12:00 pm

Prerequisite: Visualize & Present

Compare targets to actuals using a thermometer, performance chart, floating column, a good visual of min & max values, performance, benchmark, dynamic with scrollbar, track labor hours by projects.

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 @ http://www.alittleclass.net.  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.

Website: http://www.alittleclass.net

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

Available Spaces: 9

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 @ http://www.alittleclass.net.  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.

Website: http://www.alittleclass.net

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

Available Spaces: 9

No events available...