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

This is a live online class using ZOOM. 

Microsoft Excel Intermediate  During this session, you will learn how to navigate multiple worksheets, save your workbook, create formulas, use functions, change the layout of your worksheet, and how to create practical worksheets. 1040 Income Tax – Maintain tax information that is very useful when preparing your annual tax return. The design of this course includes 2-3 hours of work with the software between sessions to gain maximum benefit from the sessions.

Some examples of using Microsoft Excel as a Practical Tool:

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. 

Please take a few minutes to complete the survey included in your automated receipt so the instructor can tailor the course to meet your needs. 

You will want to have Microsoft Excel on your computer for this workshop and many people find it helpful to have two monitors though it is certainly not necessary to benefit from the sessions.  There are two ways to accomplish this: 1) attach an external screen to your computer (contact our program if you need technical assistance with that); 2) use two computers (one for Excel and the other for the ZOOM meeting. 

Val is a lifelong business educator and academic advisor focused on helping enrich and enhance students' educational and life purposes. He is experienced in college management and, as an adult educator, having taught at the Mid-State College and Kennebec Valley Community College. His teaching experience covers over 45 years in the areas of computer applications, accounting, and Quickbooks training workshops.

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

Excel Power Tools

with Val Landry, Mt. Desert Island Adult & Community Education

May
1

May 1st to 15th, 2025

This is an online class using ZOOM. 

Power Query allows you to import and shape data.  It has an easy to use interface, powerful tools to import and clean data.  

Power Pivot allows data modeling and calculations.  It easily handles millions of rows of data and has modeling tools for efficient data storage and analysis. 

Power BI (Business Intelligence) is a complete business intelligence tool.  It features incredible visual options, has simple built-in interactive options, fantastic graphs and allows easy sharing of data. The design of this course includes 2-3 hours of work with the software between sessions to gain maximum benefit from the sessions.

Please take a few minutes to complete the survey included in your automated receipt so the instructor can tailor the course to meet your needs. 

You will want to have Microsoft Excel on your computer for this workshop and many people find it helpful to have two monitors though it is certainly not necessary to benefit from the sessions.  There are two ways to accomplish this: 1) attach an external screen to your computer (contact our program if you need technical assistance with that); 2) using two computers (one for Excel and the other for the ZOOM meeting. 

Val is a lifelong business educator and academic advisor focused on helping enrich and enhance students' educational and life purposes. He is experienced in college management and, as an adult educator, having taught at the Mid-State College and Kennebec Valley Community College. His teaching experience covers over 45 years in the areas of computer applications, accounting, and Quickbooks training workshops.

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

Microsoft Excel Advanced

with Val Landry, Mt. Desert Island Adult & Community Education

Apr
3

April 3rd to 17th, 2025

This is a live online class 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 and paste special, sort data, and learn the power of filters. Some examples of using Microsoft Excel as practical tools including the amortization table, 20 top functions companies want their employees to know, and pivot tables. The design of this course includes 2-3 hours of work with the software between sessions to gain maximum benefit from the sessions.    

Please take a few minutes to complete the survey included in your automated receipt so the instructor can tailor the course to meet your needs. 

You will want to have Microsoft Excel on your computer for this workshop and many people find it helpful to have two monitors though it is certainly not necessary to benefit from the sessions.  There are two ways to accomplish this: 1) attach an external screen to your computer (contact our program if you need technical assistance with that); 2) use two computers (one for Excel and the other for the ZOOM meeting.  

Val is a lifelong business educator and academic advisor focused on helping enrich and enhance students' educational and life purposes. He is experienced in college management and, as an adult educator, having taught at the Mid-State College and Kennebec Valley Community College. His teaching experience covers over 45 years in the areas of computer applications, accounting, and Quickbooks training workshops.

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

Adulting 102: Money Grows

with FAME Finance Authority ME, Mt. Desert Island Adult & Community Education

Mar
19

March 19th, 2025

Price not available More Info

This is a live, online class.

So, you’re on a budget, managing a bank account, and wondering about the next steps in your financial journey. In Adulting 102, we will look at the differences between saving and investing, and if you are ready to invest, how to get started. Other topics will include protecting your assets (insurance), advanced budgeting, and understanding the role economics plays in our financial life.  Join Steve Kautz, Financial Education Programs Specialist from the Finance Authority of Maine for this 1-hour virtual workshop as you take the next steps into adulting.   

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

During these three sessions, you will learn basic accounting principles and how to apply them to setting up QuickBooks online for a small business or organization.   The design of the course is that you'll attend the class and also do 2-3 hours of work between sessions which greatly enhances your learning. For this workshop, you have the option to receive a yearlong subscription to QB online.  Upon registration, the survey provided will provide information about this opportunity.  This is a live online class using ZOOM.

Please take a few minutes to complete the survey included in your automated receipt so the instructor can tailor the course to meet your needs. 

You will want to have Microsoft Excel on your computer for this workshop and many people find it helpful to have two monitors though it is certainly not necessary to benefit from the sessions.  There are two ways to accomplish this: 1) attach an external screen to your computer (contact our program if you need technical assistance with that); 2) use two computers (one for Excel and the other for the ZOOM meeting.  

Val is a lifelong business educator and academic advisor focused on helping enrich and enhance students' educational and life purposes. He is experienced in college management and, as an adult educator, having taught at the Mid-State College and Kennebec Valley Community College. His teaching experience covers over 45 years in the areas of computer applications, accounting, and Quickbooks training workshops.

Image uploaded by Mid-Coast School of Technology Adult Education

This Intuit-approved course is an in person, instructor-led advanced course using Windows OS and is suitable for experienced QuickBooks Online users. Prerequisite: QuickBooks Online Basics/Intermediate course or instructor’s permission. This course provides the MOS certification pathway (no expiration) for interested students, and students may elect to take the official exam, if interested. Call the Adult Ed office for separate purchase details of the required printed textbook/eBook which accompanies this course (same materials from QuickBooks Online Basics & Intermediate course.) Please note: In class, students will use MCST provided laptops, but all students will need Windows OS operating computers at home in order to do homework assignments.