a proud member of theMaine Adult Education Association
Maine Adult Education Association Logo

Mt. Desert Island Adult & Community Education

Maine Adult Education Program

Computers and Technology

in Business & Skills Training

Course

Original source: https://pixabay.com/get/g4abbfbe830e55f30ca3e47ee4f08699ed68a1d7d27c9e2100ede29dbc6ab9042c04cd436d6225c4a10c62ffc70c593f8a1fab5810c10b2d8b4db334e81eeaef1_1280.jpg

Microsoft Excel – Advanced

with Val Landry

Jan
12

January 12th to 26th, 2023

$59 More Info

This is live online using ZOOM.

During this session you will learn how to hide data, split and freeze a window, create ranges, understand the name manager, learn additional functions, copy & paste special, sort data, and learn the power of filters. Examples of using Microsoft Excel as a Practical Tool-Intermediate  Listing 

Amortization Table – Quickly determine monthly payment due on any loan, showing principal payment, interest, and total accumulated interest. Provides users with the ability to shop for the best interest rate and see savings instantly.

Jeopardy Game – Create this game for use in your classroom as a teaching tool or at home to entertain family and friends. You will be amazed at what you can create in Excel. 

Original source: https://pixabay.com/get/gfd4abc1bd2bf9f0a57fbcfbe98f157800986715f80fd8b3d5fc488da33ee6cabedc6023520a392ed18ce938ef97872a393e172a80da7147024371ddfb2f7dc71_1280.jpg

Quickbooks Online Version Session 2

with Val Landry

Mar
2

March 2nd to 16th, 2023

$59 More Info

 This is live online using ZOOM. ONLINE VERSION.

During the 3 sessions you will learn how to create a new company, set up preferences, explore and customize the dashboard, record transactions, customize lists, create recurring transactions, prepare estimates, and reports.  For this workshop you can sign up for a year of QB online at no cost by using a school email account.  This will be arranged by the program.

Original source: https://pixabay.com/get/gbf99d8032dc5beb420284dd2cf1d3832fdd466082a410c666234315ec691ad3b5d59f1487781c748a46a7b563c46ed9371e7a67ae9277792b3a25e6fb9bbab9e_1280.jpg

The Top 20 Microsoft Excel Functions

with Val Landry

Oct
19

October 19th, 2022

$29 More Info

This is a live, online class using Zoom.

These 20 excel functions are what companies want their employees to know! During this session you will learn how to apply conditions to your data, find and filter information, extract text from cells, combine text, create lookup tables, learn how to use a special copy and paste tool, quickly format your data, and create useful reports for everyday use.

 

IF, IFS

SUMIFS

COUNTIF

FILTER

CONCATENATE

LEFT/RIGHT/MID

VLOOKUP

IFERROR

REPLACE/SUBSTITUTE

INDEX/MATCH

RANK

PIVOT TABLES

SUBTOTALS

ABS

TEXT

COPY/PASTE SPECIAL

FLASH FILL

CONDITIONAL FORMATTING

FORMAT PAINTER

RANGES

 

Original source: https://pixabay.com/get/gc6c652b422b9257c58e72043c0bc14e87bab5957842692e7c873c26d26bbc83abbdd99969b8ecdefc762f15cdc8a31a93dc9842722ae56613d520346a1074594_1280.jpg

Learning About Devices

with NDEC Staff

Oct
13

October 13th, 2022

Free More Info

This is an in-person class.  If you prefer to register for the online version of this class, please contact us and we will be happy to assist you with registering for the online version of this class.

Learn about different digital devices in this informative webinar. This webinar is part of the new NDEC Aging Well with Technology Curriculum – Getting What You Need Online, designed with those 55+ in mind.

Original source: https://pixabay.com/get/g522870a193aa872d2f3e3e1b844ecb0d93f3ee883cd2f7826f0cf6d724cfaa9815891149b1a32e41e62c70cda469056dc5dbd10d9702f7f5a32eaf689cba7301_1280.jpg

Microsoft Excel – Intermediate

with Val Landry

Nov
17

November 17th to December 8th, 2022

$59 More Info

This is live online using ZOOM.

During this session you will learn how to navigate multiple worksheets, saving your workbook, creating formulas, using functions, changing the layout of your worksheet, and how to create practical worksheets. (No Class 11/24)

 Examples of using Microsoft Excel as a Practical Tool-Intermediate  Listing 

1040 Income Tax – Maintain tax information that is very useful when preparing your annual tax return. 

Grocery Shopping List – Quickly create a weekly grocery shopping list. What a time saver! 

Contractor Estimate Calculator - Great tool for any contractor who has to provide estimates for customers. 

Household Budget – Create a monthly budget of your household expenditures.