June 14, 2022 from 3pm - 5pm

Leverage the Power of Google Tools for Productivity & Collaboration - all versions of Google compatible.

July 5 - July 21; 1pm - 3pm

Tuesday and Thursday for a total of 6 classes

Google Workspace is an extensive collection of productivity tools. Learning the power and connection of Google tools for organization, collaboration and sharing will amp up your personal productivity or that of your business or non profit.

Presented in a series of sessions, this comprehensive series is for new and current Google users who want to build their foundational skills. Advanced tips and tricks will be included to individualize the challenge for all user levels. Each session will cover a different app and the fundamental concepts of security, sharing and streamlining workflow.  

The goal for this course is to understand  and gain hands on experience with Gmail, Drive, Calendar, Docs, Sheets and Slides and how these individual apps can be connected to enhance organization, collaboration and sharing in a cloud environment. Related Google services such as Chrome, Photos, Meet, Keep, Tasks, Groups  will be addressed, Participants will have the option of successfully completing follow up activities to earn  the NHTI Google Pro Microcredential.

About the Instructor

Deb Boisvert is an educator/computer professional with over 35 years of experience. She is a Google Level 1 and 2 Educator and a Google Certified Trainer.  She has worked extensively in private and public schools K-16 and with NonProfits. 

July 11 and July 13, 2022 from 1pm - 4pm

The Google Educator L1 Bootcamp consists of instructor led hands on, activities that directly supplement Google’s online training and what you need for a successful examination to become a Google L1 Certified Educator. It will solidify your foundation skills for all of the G Suite Apps. 

• Ideal participant has basic proficiency using G Suite.  
• Bootcamp focus is to fill in the gaps and help participants ‘level up so can continue to expand productivity and pedagogy.

Applications covered include:

• Chrome
• Drive
• Docs
• Sheets
• Slides
• Forms
• Sites
• Mail
• Calendar
• Groups
• Meet
• YouTube
• Sites 

Facilitator:  Deb Boisvert Google Certified Trainer

Course will be accessible via your assigned training account.  You will receive your access information one week prior.  (If you get a 404 error, open link an incognito window and log into your training account to access).  

2 Online Sessions - 3.5 hours each

July 22 and July 29,2022, 1:00 pm - 4:30 pm

Introduction to Topic:

Professionals working with data and numbers need working knowledge of spreadsheet applications.  If your organization uses Microsoft Excel a hands-on course that teaches how to set up and work with fully formatted worksheets is a must. 

Excel 101 Topics: 

Topic 1:  Introduction to Excel – the basics

Delegates will get a working understanding of the Excel interface to learn the essentials of creating and setting up workbooks, worksheets and working with data.  Topics covered include:

• Terminology – Workbook, worksheets, cells, ribbon
• Tour of Excel screen
• Moving around the Excel interface
• Entering Data
• Select ALL
• Changing Column Widths
• Speed Fill / Auto Fill
• Fill down and fill across
• Inserting rows and columns
• Performing basic calculations
• Creating hyperlinks to the web, files, cells, 

Topic 2:  Working with Numbers  

In this session, delegates will practice working with formulas to unleash the power of how Excel spreadsheets.  Topics covered include:

• More Basic calculations
• Speed fill with a formula
• Auto Sum
• Auto Average
• MIN
• MAX
• Basic Formulas
• Speed fill with a formula
• Relative Formulas
• Absolute formulas

Topic 3:  Formatting Sheets    

Representing data visually is an important element of working with Excel.  In this session participants will learn about options for formatting, sorting and filter and creating visual representations of data.  Topics include:

• Managing Sheets
• Using Comments
• Printing and page setup options
• Sorting basics
• Filtering basics
• Subtotals
• Charts
• Formatting the spreadsheet
• Conditional Formatting
• Formatting cells for number, calendar, currency, decimal

Topic 4 Managing Sheets   

A workbook can contain many sheets.  Leveraging the use of multiple sheets in a single workbook can increase productivity and overall impact of spreadsheets.    Topics include:

• Adding Sheets
• Deleting Sheets
• Changing a Sheets name
• Changing a Sheets color
• Moving Sheets
• Copying Sheets
• Navigating Sheets
• Linking Formulas from 1 sheet to another

About the Instructor

Tom Fragale is a computer professional with over 30 years of experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across a variety of industries, including manufacturing, banking, pharmaceutical, education, retail, etc.

July 25 and July 27, 2022 from 1pm - 4pm

Distinguish yourself as a super user with immersed integration & beyond the core

If you're an educator who is a super user and enthusiast of Google tools in the classroom, this certification proves your expertise.  The training will host a series of online activities to build your skills with core and extended tools such as 

• Blogger
• Google Search
• Scholar
• YouTube Editing
• Advanced Docs, Sheets, Slides, Forms, Classroom & Sites

Take your core knowledge to the next level by learning new ways to use the tools to innovate, engage, create, & collaborate!  

Facilitated by Google Certified Trainer, Deb Boisvert

_______________________________________________________

Course will be accessible via your assigned training account.  You will receive your access information one week prior.   (If you get a 404 error, open link an incognito window and log into your training account to access).  

2 Online Sessions - 3.5 hours each

August 5 and August 12, 2022, 1:00 pm - 4:30 pm

Excel 102 - The Productivity Bootcamp  

Description:    

Microsoft Excel has become the main program to handle large amounts of data, charts, financial models, math formulas, reports, and just about everything else pertaining to business.  But using it can still be a mystery.

This training will show you everything you need to know about using Excel and getting more productive and efficient with it.  The topics include:

• Sorts
• Filters
• Advanced Filters
• Subtotals
• Formatted Tables
• The Total Row in Formatted Tables
• Using Slicers in Formatted Tables
• The Sumif, Countif, and Averageif Formulas
• The Vlookup Formulas
• If Formulas
• Date Formulas
• Subtotals
• Charts
• Pivot Tables
• Dashboards in Pivot Tables
• Power Pivot and PowerQuery
• Automating tasks with Macros

 About the Instructor

Tom Fragale is a computer professional with over 30 years of experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across a variety of industries, including manufacturing, banking, pharmaceutical, education, retail, etc.

October 27, 2022 from 3pm - 5pm

October 19 and 20, 2022 from 3pm - 6pm

The Google Educator L1 Bootcamp consists of instructor led hands on, activities that directly supplement Google’s online training and what you need for a successful examination to become a Google L1 Certified Educator. It will solidify your foundation skills for all of the G Suite Apps. 

• Ideal participant has basic proficiency using G Suite.  
• Bootcamp focus is to fill in the gaps and help participants ‘level up so can continue to expand productivity and pedagogy.

Applications covered include:

• Chrome
• Drive
• Docs
• Sheets
• Slides
• Forms
• Sites
• Mail
• Calendar
• Groups
• Meet
• YouTube
• Sites 

Facilitator:  Deb Boisvert Google Certified Trainer

Course will be accessible via your assigned training account.  You will receive your access information one week prior.  (If you get a 404 error, open link an incognito window and log into your training account to access).