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.

Ready for a career change but don’t know where to start? This one-hour workshop will point you in the right direction. Our professional staff will cover what to consider when making a career choice and the resources available to help you succeed. Students must have an audio- and video-enabled laptop, desktop, or tablet with reliable internet to participate in class. We do not recommend using a smartphone. For more information, visit newventuresmaine.org

Take your EXCEL skills to the next level. We will learn about tables, charts, data analysis, sorting, formulas and functions as well as pivot tables. 

This course is held on three consecutive Wednesdays, please attend all three.

This class is free for Maine residents, the non-resident fee is $50

Please Register at the link below! You will be redirected to the National Digital Equity Center website.

https://digitalequitycenter.org/classes/class/intermediate-ms-excel/?instance_id=5528

There are many different facets to the student loan program that can be powerful in helping you achieve your financial goals but also can be confusing. If you are struggling with your payments, did you know there are several income-based repayment plans as well as deferment or forbearance? Did you know you could get .25% off your interest rate if you sign up for auto-debit on your federal loans? Do you know you can work towards loan forgiveness now if you work for a non-profit, government or tribal agency? Whether you have recently graduated from college or have been repaying your students loans for a long time, join us to learn how to best manage your student loan repayment. Join Nikki Vachon, College Access Counselor from the Finance Authority of Maine as she shares pro-tips and answers questions. #FAME #nov2024

Many people have vision issues. A variety of iPhone/iPad settings allow you to use your device more easily when vision challenges arise. In this online, self-paced course you will learn where to find vision accessibility options and how to use them. The vision accessibility features are identical on the iPhone and iPad except in a couple of noted instances.

Are you ready to continue your journey into the world of grants? You will learn how to create a fundraising plan for all types of grantmakers. In addition, you will explore websites for finding and reviewing corporate, foundation, and government grant funding opportunities and grant application guidelines.

You will go through every aspect of strategic funding research, preparing a fundraising plan, writing an award-winning plan of operation, and creating a project budget without red flags. Then you will journey into the world of grants available for your projects. The excitement will build when you discover just how many funding opportunities are available.

You will see grants for arts and humanities, education, medical, science and agriculture, human services, and corporate foundation grants. You will also explore new grant-writing trends and what to do when you're notified of a grant award or a grant rejection. Don't worry, there's a plan to implement for future grant seeking success if you don't get your project funded.

By the end of the course, you will be prepared to continue tracking future grant-writing and funding trends, bounce back successfully from rejection notices, and manage all of your grant awards proficiently. In addition, you will gain confidence in all areas of grant seeking, grant writing, and grants management (post-award reporting requirements).

For more information please click the link.

To register or for more details visit:

https://www.ed2go.com/kae/online-courses/accounting-basics/

Accounting Fundamentals

In this course, you'll learn the basics of double-entry bookkeeping, as well as how to analyze and record financial transactions. You'll get hands-on experience with handling accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities. We'll cover all the bases, from writing checks to preparing an income statement and closing out accounts at the end of each fiscal period.

Accounting Fundamentals II

This course will build on the knowledge you gained in Accounting Fundamentals, to provide you with a solid understanding of corporate accounting practices. You'll explore such topics as special journals, uncollectible accounts receivable, plant assets, depreciation, notes and interest, accrued revenue and expenses, dividends, retained earnings, and various financial reports for corporations.

Discover how time management, accounting, business law, organizational behavior, and management affect administrative assistant responsibilities and activities. Learn the basics of accounting, including the general ledger and key accounting terms, and see how financial statements and controls help keep your organization moving in a positive direction. Understand the fundamentals of business law, contracts, and the principal-agency relationship; discover ethics and organizational politics; and understand the basics of human resources management.

Also, discover key management functions such as planning, control, motivation, and organization, discover how to increase creativity. Plus, find out how marketing differs from sales and learn the basics of operations management. This course may help you prepare for the internationally-recognized Certified Administrative Professional® (CAP®) exam offered by the International Association of Administrative Professionals® (IAAP®).

Note: This course is not affiliated with, nor has it been endorsed by, the International Association of Administrative Professionals® (IAAP®).

For more information please click on the link.