Business & Skills Training

Image uploaded by Piscataquis Valley Adult Education Cooperative

Microsoft Excel Advanced (Dec)

with Val Landry

Dec

5

December 5th to 19th, 2024

$89 More Info

Microsoft Excel Advanced 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. 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.

Excel Power Tools (Jan)

with Val Landry

Jan

9

January 9th to 23rd, 2025

$89 More Info

Microsoft Excel Power Tools 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. This is an 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) using two computers (one for Excel and the other for the ZOOM meeting.

Quickbooks: Basic Accounting Principles and QB Online (Feb)

with Val Landry

Feb

4

February 4th to 18th, 2025

$89 More Info

Basic Accounting Principles and Quickbooks Online 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.