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.

This course is designed for those who want to develop an online course using Zoom, a video conferencing platform. This guide consists of step-by-step videos that explain and demonstrate how to use Zoom as well as appropriate instructional tips to build an engaging online course in any subject. You will learn everything you need to know about Zoom—tools, settings, security, instructional strategies, building community, Zoom tips for instructors and students, and much more.

Most of us take hundreds of photos that languish on our iPhone/iPad or in the cloud. Knowing how to edit images and organize your photos on your iPhone and iPad is essential. Other areas of study include using the tabs in the Photos app —“For You" tab (ready-made slide shows), creating, using, and sharing albums, and the very useful search function.

Did you know…your iPhone tracks your movements? The keyboard has hidden keys? You can write and draw on your photographs? You can calculate in your search window? Our iPhones/iPads have many time-saving features that allow you to be creative, efficient, and have fun. These "hidden gems” will show you how to learn advanced features of your iPhone and iPad.

The vast majority of iPhone users rarely access all of the available iPhone features. In this course, learn to use your iPhone to the best possible advantage. Some critical features covered include Apple ID and password; structure of the iPhone (buttons and how they work); best apps to have and how to get them; how to text, phone, FaceTime, and email; how to use the Control Center; mastering Settings; updating operating systems; using key apps; and more. An additional session will include iOS 15 updates and the unique features of the newest iPhones (iPhone 12 & 13).

In this course you will learn everything you need to know to make your Mac computer (laptop or desktop) hum! Areas of focus include: Mac Operating System, features of the Mac, choosing the best browser, using Spotlight Search, learning how to use the Finder and App Store, understanding the keyboard, and learning the icons that define a Mac computer.

Using Zoom more than ever? Here is a great way to learn everything you need to know about the Zoom Video Conferencing platform. The course videos demonstrate examples of using Zoom on different devices—smartphones, tablets, and computers. Course content includes: Muting audio and video; using chat; screen sharing; recording; trouble- shooting; scheduling meetings; break-out rooms; and more. This course is appropriate for Zoom beginners as well as those who have used Zoom and want to learn more.

Learn to increase your capabilities to communicate, create, and connect by mastering your iPad’s features. This course covers navigating your iPad, its Camera and Photos apps, the options available in Settings, ways to communicate through writing and video, plus how to answer and make phone calls. Plus, you will learn about the apps that came already loaded on your iPad like the Calendar and Siri, your virtual assistant. It is important that you have updated to iOS 15; but don’t worry—if you don’t know how, we will show you the steps. Finally, you will also learn about accessibility features that are helpful for folks with finger mobility, sight, or hearing difficulties.