Your browser is not optimized for viewing this website.

More information »

Mt. Desert Island Adult & Community Education



Val Landry's classes

in Digital Literacy

Quickbooks Desktop Version - Session 1

$59

with Val Landry

Calendar Oct 6, 2022 at 8:30 am, runs for 3 weeks

This is live online using ZOOM. Desktop Verion.

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, reports, and create/edit lists. 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.

Windows Basics - Drives, Folders, File Management, Search - Session 2

$29

with Val Landry

Calendar Oct 12, 2022 at 8:30 am, runs for 1 week

This is live online using ZOOM.

Learn how to manage all of your documents. Drives, Folders and Files will be covered. File Management – [Copying, Moving, Renaming, Deleting and Searching]. How to use a “Flash Drive”, Windows Explorer, Windows Desktop and Shortcuts. 

The Top 20 Microsoft Excel Functions

$29

with Val Landry

Calendar Oct 19, 2022 at 8:30 am, runs for 1 week

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

 

Microsoft Excel Basics

$59

with Val Landry

Calendar Oct 27, 2022 at 8:30 am, runs for 3 weeks

This is a live, online Zoom class.

During this workshop you will learn how to navigate a simple excel worksheet, enter data in a worksheet, use basic math functions, do basic formatting, understand how to replicate data, use built-in functions and work with columns and rows.

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

Bank Reconciliation – Ease that monthly chore of balancing your account with the bank

 Creating a Calendar – Create a useful monthly calendar for managing important household dates. 

 Check Register – Keep track of your checks, electronic transfers and deposits.

 Volunteer List – Create a schedule for a volunteers to sign up for an event. 

Microsoft Excel – Intermediate

$59

with Val Landry

Calendar Nov 17, 2022 at 8:30 am, runs for 3 weeks

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. 

Microsoft Excel - Advanced

$59

with Val Landry

Calendar Jan 12, 2023 at 8:30 am, runs for 3 weeks

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. 

Microsoft Excel Pivot Tables Basics

$39

with Val Landry

Calendar Feb 9, 2023 at 8:30 am, runs for 2 weeks

This is live online using ZOOM.

What can you do with Excel Pivot Tables? A better question is what can’t you do? The Pivot Table function is probably one of the more powerful and useful tools used in Excel. You will learn how to prepare your data for use in a pivot table, create your first pivot table, customize various structures of your table, design your table, create calculated fields and items. This is live online using ZOOM.

Quickbooks Online Version Session 2

$59

with Val Landry

Calendar Mar 2, 2023 at 8:30 am, runs for 3 weeks

 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.





Forgot password?
Staff Log In