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.

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.

This is a step-by-step guide to taking beautiful photos, appropriate for novice photographers and anyone who wants to significantly upgrade their photography skills. Students will learn to take photos, portraits, slo-motion, panos, and more. Also students will learn about camera settings for proper focus and exposure, High Dynamic Range, and picture composition.

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.