Microsoft Excel Advanced (Dec)

with Val Landry

Dec
5

December 5th to 19th, 2024

$89 More Info
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. 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.

Excel Power Tools (Jan)

with Val Landry

Jan
9

January 9th to 23rd, 2025

$89 More Info
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. 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.

Microsoft Excel Intermediate (Oct)

with Val Landry

Oct
31

October 31st to November 14th, 2024

$89 More Info
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. 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.
Original source: https://s3.amazonaws.com/coursestorm/live/media/74afd0b4378311ee83720a43100e1467

CompTIA A+ with Exam Voucher

with Pro Train

Nov
19

November 19th, 2024 to January 28th, 2025

$2,985 More Info
The CompTIA Network+ training measures the necessary competencies for an IT professional with approximately nine months experience in network support or administration. Students will learn the knowledge and skills needed to install, manage and troubleshoot a variety of networks on any platform.
Online registration unavailable
Original source: https://s3.amazonaws.com/coursestorm/live/media/bfde6663378411ee83720a43100e1467

CompTIA Security+ With Exam Voucher

with Pro Train

Oct
21

October 21st to November 25th, 2024

$1,379 More Info
This course can benefit you in two ways. If you intend to pass the CompTIA Security+ (Exam SY0-701) certification examination, this course can be a significant part of your preparation. But certification is not the only key to professional success in the field of computer security. Today's job market demands individuals with demonstrable skills, and the information and activities in this course can help you build your cybersecurity skill set so that you can confidently perform your duties in any entry-level security role. Recommended Prerequisites: High School Graduate or GED holder. Operating knowledge of Windows or equivalent operating system.
Online registration unavailable
Doing basic internet searches on Safari is fairly straightforward. However, within Safari there are many options most of us never explore. Join us for five lessons that will unlock the secrets of Safari: options contained in the top menu, choices provided on the opening screen, tips for more efficient searching, possibilities hidden within the share feature, and a demo of why you want to click on the AA button. After completing the five lessons you will truly know the ins and out of Safari.