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 Tables 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 classes to gain maximum benefits from the sessions.

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); or 2) using two computers (one for Excel and the other for the ZOOM meeting).  This is a live, online class using ZOOM; makeup class, if needed, 01/30/25.

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 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.

During this workshop, you will learn how to navigate a simple Excel worksheet, enter data into a worksheet, use basic math functions, do basic formatting, replicate data, use built-in functions and work with columns and rows.  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.  This is a live, online class using ZOOM.

The design of this course includes 2-3 hours of work with the software between classes to gain maximum benefit from the sessions.

No class 02/20/25.

You will receive a link to a brief pre-assessment with your email receipt.  This will assist the instructor in meeting your goals for the class. 

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); or 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 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.

Learn how to hide data, split and freeze a window, create ranges, understand the name manager, learn additional functions, copy and paste, sort data, and learn the power of filters. Some examples of using Microsoft Excel as a practical tool include the amortization table, 20 top functions companies want their employees to know, and pivot tables. This is a live online class using ZOOM. 

The design of this course includes 2-3 hours of work with the software between classes to gain maximum benefit from the sessions.

Makeup class, if needed, 04/24/25.

You will receive a link to a brief pre-assessment with your email receipt.  This will assist the instructor in meeting your goals for  the class. 

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); or 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 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.

These new Excel tools allow you to bring your work with Excel to a whole other level, from importing and sharing, importing and cleaning data, and modeling and calculating a large amount a data creating efficiencies, and so much more. 

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 Tables 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 class.

This is a live, online class using ZOOM; makeup class, if needed, 05/22/25.

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); or 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 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.