Ridgefield
Continuing Education Computer and Technology Training |
|||||
Excel
and Access 2021 / 365 |
|||||
Class Location: Computer
classes and tutorials will be taught by the instructor at the Continuing Education Center, located in
the Town Hall Annex or at one of the schools. Some classes may be taught live, online via Zoom.
Excel
Excel 365, 2021 and 2019 are available on our
PC's. If you have 365 (or 2021, 2019 or 2016) on a laptop, please bring it. Instructor projects using 365/2021.
Tutorials Available. Please
call (203) 431-2812 or email ridgefieldcontinuingeducation@gmail.com for
information and to schedule.
Word and Excel Basics - Level 1
Prerequisite: Basic computer skills and knowledge of the keyboard. For people who need to fill basic computer skills gaps’ and learn how to get started using Word and Excel. Learn to create and edit simple letters and spreadsheets using Word and Excel. Includes copy, cut, paste, open, save vs saveas, print, margins and beginning formulas.
We will also cover basic file management, find files, create folders and desktop shortcuts. Instructor Peggy Bruno, a certified teacher, has developed computer courses and trained several thousand adults in computer applications for over 25 years. She previously worked in corporate marketing and information services. She has also taught Microsoft Office at the community college level. She holds a BA and MA from the University of Pennsylvania and an MBA from the University of Michigan.
2 hours $ 40 (Ridgefield Sr./Disab. $ 36)
Tue., 7/8 from 3 to 5 p.m. at the Annex.
Excel for Windows 2021 / 365 - Fast Paced Intro - Level 2
Prerequisite: Word and Excel Basics - Level 1 above or equivalent. For people who have used Excel in the past and need to fill in basic gaps. Learn to create, update, and format worksheets and charts. Quickly reviews cut, copy, paste, move, drag and fill, and delete. Includes special print options, save, open file, fonts, decimal, $ and % formatting, borders, shading, shortcut menus, right clicking, format painter, freezing titles.
Instructor
Peggy Bruno, a certified teacher, has developed computer courses and trained
several thousand adults in computer applications for over 25 years. She previously
worked in corporate marketing and information services. She has also taught
Microsoft Office at the community college level. She holds a BA and MA from
the University of Pennsylvania
and an MBA from the University of Michigan.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Thur., 3/20 from 3 to 5 p.m. at the Annex.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Tue., 7/29 from 3 to 5 p.m. at the Annex.
Excel for Windows 2021 / 365 - Intermediate - Level 3
Prerequisite: Introduction to Excel (above) or equivalent experience. Exercises
focus on practice with formulas; calculations; linking sheets and workbooks;
relative, absolute, and mixed cell references. Instructor Peggy Bruno, a certified teacher, has developed computer courses and trained
several thousand adults in computer applications for over 25 years. She
previously worked in corporate marketing and information services. She
has also taught Microsoft Office at the community college level. She holds
a BA and MA from the University of Pennsylvania and an MBA from the University
of Michigan.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Thur., 3/27 from 3 to 5 p.m. at the Annex.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Wed., 7/30 from 3 to 5 p.m. at the Annex.
Excel for Windows 2021 / 365 - Intermediate - Level 4
Prerequisite: Introduction to Excel (above) or equivalent experience. Covers NPV, FV, and PMT functions,
goal seeking, and additional chart types. Also covers cell protection,
customizing tool bars, templates, and smart tags. Instructor Peggy Bruno, a certified teacher, has developed computer courses and trained
several thousand adults in computer applications for over 25 years. She
previously worked in corporate marketing and information services. She
has also taught Microsoft Office at the community college level. She holds
a BA and MA from the University of Pennsylvania and an MBA from the University
of Michigan.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Thur., 4/24 from 3 to 5 p.m. at the Annex.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Thur., 7/31 from 3 to 5 p.m. at the Annex.
Excel for Windows 2021 / 365 -
Advanced - Level 5
Prerequisite: Intro to Excel, part 2 or equivalent experience. Exercises
cover Excel pivot tables and charts, database and table
management features (sort, filters, subtotals), plus bringing data from Microsoft
Access into Excel. Instructor
Peggy Bruno, a certified teacher, has developed computer courses
and trained several thousand adults in computer applications
for over 25 years. She previously worked in corporate marketing
and information services. She has also taught Microsoft Office
at the community college level. She holds a BA and MA from the
University of Pennsylvania and an MBA from the University of
Michigan.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Tue., 3/18 from 1:30 to 3:30 p.m. at the Annex.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Thur., 5/1 from 3 to 5 p.m. at the Annex.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Tue., 8/5 from 3 to 5 p.m. at the Annex.
Excel for Windows 2021 / 365 -
Advanced - Level 6
Prerequisite: Intermediate Excel, part 1 or equivalent experience. Exercises
cover Flash Fill.
Also includes V Lookup, if statements, CountIf, SumIf, and
scenarios. Instructor
Peggy Bruno, a certified teacher, has developed computer courses
and trained several thousand adults in computer applications
for over 25 years. She previously worked in corporate marketing
and information services. She has also taught Microsoft Office
at the community college level. She holds a BA and MA from the
University of Pennsylvania and an MBA from the University of
Michigan.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Tue., 4/1 from 1:30 to 3:30 p.m. at the Annex.
2 hours $ 40 (Ridgefield
Sr./Disab. $ 36) (+ $ mtls.)
Wed., 8/6 from 3 to 5 p.m. at the Annex.
Access
Access 365, 2021 and 2019 are available on our
PC's. If you have 365 (or 2021, 2019 or 2016) on a laptop, please bring it. Instructor projects using 365/2021.
Access for Windows - 1 on 1 Course
Prerequisite: Basic computer skills. Experience with Excel helpful.
Beginners learn to develop and manage a relational database. Step by
step exercises teach you to modify an existing database; plan and design
a new database; create and modify tables; sort and filter records; link
tables; create and edit basic queries; multi-level sorts in queries;
and create quick reports, forms, and labels. Instructor
Peggy Bruno, a certified teacher, has developed computer courses and
trained several thousand adults in computer applications for over 25
years. She previously worked in corporate marketing and information services.
She has also taught Microsoft Office at the community college level.
She holds a BA and MA from the University of Pennsylvania and an MBA
from the University of Michigan. Call
(203) 431-2812 or email ridgefieldcontinuingeducation@gmail.com to
schedule.
Tutorials
Want to know how to get an attachment on your specific email? Still not sure
how to organize your files at home? Not sure exactly how to get that picture
from the Internet into your own files or document? If these are some of your
questions, you can sit down one on one with a Continuing Education instructor
and get your questions answered. Please email ridgefieldcontinuingeducation@gmail.com for
more information and or to schedule your tutorial through Ridgefield Continuing
Education.