Computer and Career Classes

Our computer lab is open to the public and free of charge. Hours are Tuesday, Wednesday and Thursday 10 a.m. to noon and Tuesday evenings 5:30-7:30 p.m. Room 301, McConnell Center, 61 Locust Street, Dover, NH. except on holidays and during school vacations.

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

Excel Basics B

Tuition: $60.00 Dover Residents: $55.00

Date: Friday, May 3, 2019

Time: 9:00 am - 12:00 pm

Prerequisites: Ease with keyboard and mouse. Keying speed not required.

Introductory class on the following: managing different views and multiple sheets at once; formatting for printing; creating headers and footers; and printing with titles on every page.

 

McConnell Center Rm 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:
Computer Lab McConnell Center Rm 301
61 Locust Street
Dover, NH
03820 Map and Directions

Available Spaces: 10

QuickBook Basics for Beginners-May 2019

Tuition: $90.00 Dover Residents: $85.00

Start Date: Saturday, May 11, 2019
End Date: Saturday, May 18, 2019

Time: 10:00 am - 12:00 pm

Learn how to setup 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.

 

Saturdays@ McConnell Center

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:
Computer Lab McConnell Center Rm 301
61 Locust Street
Dover, NH
03820 Map and Directions

Available Spaces: 7

Digital Photo Organization and Printing

Tuition: $55.00 Dover Residents: $50.00

Start Date: Monday, May 13, 2019
End Date: Monday, June 3, 2019

Time: 12:30 pm - 2:30 pm

Digital cameras, smartphones, tablets...there are many ways to take digital photos, but what do you do with them all?  In this class you will learn how to use your computer to organize your digital photos and create photo projects.

Participants should be comfortable working on Windows computers and a web browser.  Bring to class:

1) Your digital photos: on your digital camera or smartphone with its USB transfer cable, on camera memory cards, on CD/DVDs, or on an external hard drive or flash drive.

2) A USB flash drive or external hard drive-this is where you will organize your own photos

3) A laptop computer (if you wish to use your own computer) or you can use one of our laptops

Mondays @  McConnell Center Rm 220

Taught by:

Tiffany Brand

Tiffany has lived in the seacoast of New Hampshire all of her life. She has over 15 years of experience in teaching technology, serving as a technology coordinator, trainer, and a computer teacher for several school districts. She enjoys bringing the fun, excitement, and usefulness of technology to her students and colleagues.

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

Available Spaces: 4

Excel Intermediate A

Tuition: $60.00 Dover Residents: $55.00

Date: Friday, May 17, 2019

Time: 9:00 am - 12:00 pm

Prerequisite: Basic Excel experience with navigation, formulas and functions such as SUM, AVERAGE.  Knowledge of relative vs absolute references.

Calculate data across worksheets, and assign range names for quick navigation and easy to read formulas; manage long lists with tables, intro to pivot tables.

McConnell Center Rm 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:
Computer Lab McConnell Center Rm 301
61 Locust Street
Dover, NH
03820 Map and Directions

Available Spaces: 9

Excel Intermediate B

Tuition: $60.00 Dover Residents: $55.00

Date: Friday, May 24, 2019

Time: 9:00 am - 12:00 pm

Prerequisite: Excel Intermediate A

Pivot table review; create charts and slicers; learn to use advanced formulas such as IF, VLOOKUP, HLOOKUP.

McConnell Center Rm 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:
Computer Lab McConnell Center Rm 301
61 Locust Street
Dover, NH
03820 Map and Directions

Available Spaces: 10

Excel Advanced A

Tuition: $60.00 Dover Residents: $55.00

Date: Friday, June 7, 2019

Time: 9:00 am - 12:00 pm

Prerequisite:Experience with the structure of common functions such as SUM, AVERAGE in Excel.

Apply conditional formatting; consolidate data from worksheets or workbooks; Streamline your workflow; trace your formulas; advanced formulas for managing text & extrapolating partial data from a cell.

McConnell Center Rm 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:
Computer Lab McConnell Center Rm 301
61 Locust Street
Dover, NH
03820 Map and Directions

Available Spaces: 10

Excel Advanced B

Tuition: $60.00 Dover Residents: $55.00

Date: Friday, June 14, 2019

Time: 9:00 am - 12:00 pm

Prerequisites:Experience with the structure of common functions such as SUM, AVERAGE in Excel

Provide drop-down lists to simplify data entry; intro to macros; keeping formulas safe; using Scenarios and What-If analysis.

McConnell Center Rm 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:
Computer Lab McConnell Center Rm 301
61 Locust Street
Dover, NH
03820 Map and Directions

Available Spaces: 10

No events available...