Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. 

You'll see how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analysis. You'll discover ways to work with databases and advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources, become adept at importing external data using Excel's built-in Power Query tool, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.

 

All Gale Courses are free with your Canton Public Library card, and the next set of classes will begin on Wednesday, May 16th​. Learn on your own schedule, and receive a certificate of completion when you've finished. Our goal is to provide lifelong educational opportunities for you to gain new skills or improve existing ones. New sessions are offered every month. Take advantage of these instructor-led courses on our databases page!

 

Are your parents in their golden years? Learning how to help parents or other loved ones through their transition can prepare us for our own. This compassionate and comprehensive class will give you the tools, techniques, and insights for this passage. Growing older is a part of life. Some aspects are joyful, some bittersweet, some frustrating, some frightening. You will learn what to expect, what to watch for, how to deal with physical and emotional challenges, and where to find resources to help.

All Gale Courses are free with your Canton Public Library card, and the next set of classes will begin on Wednesday, May 16th. Learn on your own schedule, and receive a certificate of completion when you've finished. Our goal is to provide lifelong educational opportunities for you to gain new skills or improve existing ones. New sessions are offered every month. Take advantage of these instructor-led courses on our databases page!

 

 

QuickBooks is designed for the small to midsized business owner who needs a fully functional accounting system that is also easy to use.  When you enroll in this course, you will learn how this well-designed accounting software can make it a snap to set up a chart of accounts, reconcile your checking account, create and print invoices, receipts, and statements, track your payables, inventory, and receivables, create estimates, and generate reports.

All Gale Courses are free with your Canton Public Library card, and the next set of classes will begin on Wednesday, May 16. Learn on your own schedule, and receive a certificate of completion when you've finished. Our goal is to provide lifelong educational opportunities for you to gain new skills or improve existing ones. New sessions are offered every month. Take advantage of these instructor-led courses on our databases page!

 

Looking to read a new genre? According to Merriam-Webster , magical realism is "a literary genre or style associated especially with Latin America that incorporates fantastic or mythical elements into otherwise realistic fiction." Check out this book list for some suggested titles with these themes!

Garden spells by Sarah Addison Allen
Also available in: audiobook
Also available in: audiobook | large print

It may be hard to believe, but spring will be here soon! To help you get in the spirit, check out some of our fiction and non-fiction books on the subject!

Presents craft projects for spring, including cotton ball sheep, a daffodil made from an egg carton, and popsicle stick flowers.

Animals in spring by Martha E. H. Rustad

Describes some of the activities of animals during the spring, including bears waking up, birds returning from the south, ducklings hatching, and honeybees leaving the hive.

Are you a creative person with an eye for design? If so, this course will show you how to transform plain living spaces into beautiful and functional rooms.  

Interior design takes training as well as talent, and these lessons will give you the know-how you need to design a room from floor to ceiling. You'll delve into color theory, industry trends, spatial arrangements, floor plans, traditional and modern interior design ideas, and other basics. In addition, you'll explore a range of careers in interior design and get insider tips for entering this exciting field. 

All Gale Courses are free with your Canton Public Library card, and the next set of classes will begin on Wednesday, April 11th. Learn on your own schedule, and receive a certificate of completion when you've finished. Our goal is to provide lifelong educational opportunities for you to gain new skills or improve existing ones. New sessions are offered every month. Take advantage of these instructor-led courses on our databases page!

 

Homeschooling can be a bit of a mystery if you're new to the topic. In this course, we'll start at the beginning, delving into the history of homeschooling and examining its status today in all 50 states. You'll see how to find the laws and regulations that govern your community--and you might be surprised to learn that homeschooling is legal and growing all around you. As you discover what you need to know to homeschool your children, you'll also become familiar with the terminology the homeschool community uses.

To ensure you're well prepared to meet your children's needs, we'll discuss learning styles and how they affect homeschooling. You'll learn how to take your children out of school and make their transition to homeschooling both fun and effective. We'll talk about children that need extra attention, both special needs and gifted, and a variety of types of homeschooling so you can choose the one that best fits your family's lifestyle.

 

All Gale Courses are free with your Canton Public Library card, and the next set of classes will begin on Wednesday, April 11th. Learn on your own schedule, and receive a certificate of completion when you've finished. Our goal is to provide lifelong educational opportunities for you to gain new skills or improve existing ones. New sessions are offered every month. Take advantage of these instructor-led courses on our databases page!

Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. QuickBooks is designed especially for the small- to midsized-business owner who needs a fully functional accounting system that's also easy to use.

In 12 lessons, you'll gain hands-on experience as you master the tools you need set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports.

All Gale Courses are free with your Canton Public Library card, and the next set of classes will begin on Wednesday, April 11th. Learn on your own schedule, and receive a certificate of completion when you've finished. Our goal is to provide lifelong educational opportunities for you to gain new skills or improve existing ones. New sessions are offered every month. Take advantage of these instructor-led courses on our databases page!

If you weren't able to make it to our STEAM program about the moon, don't worry! Here are some books (fiction and non-fcition) that talk about the Earth's moon! 

Die-cut pages show the phases of the moon as it shines on animals all over the world, from sea turtles laying eggs on the beach to frogs in the jungle and mice in the fields.

Long Night Moon by Cynthia Rylant

Text and illustrations depict the varied seasonal full moons that change and assume personalities of their own throughout the year..

The key to effective writing and speaking is English grammar.  Whether you are just now learning the basics of grammar or if you need a refresher, this course will help you develop the foundational skills you need.  In this course, you’ll explore the eight parts of speech, punctuation and mechanics, foundational sentence construction, and we’ll even get into the details of phrases, clauses, problem words, common grammar mistakes, and much more! An instructor will guide you every step of the way as you learn grammar through hands-on, practical exercises.  You’ll also learn through short videos, examples, and even fun games.  Take your writing and speaking to the next level of excellence!

All Gale Courses are free with your Canton Public Library card, and the next set of classes will begin on Wednesday, March 14. Learn on your own schedule, and receive a certificate of completion when you've finished. Our goal is to provide lifelong educational opportunities for you to gain new skills or improve existing ones. New sessions are offered every month. Take advantage of these instructor-led courses on our databases page!

Pages