2 Online Sessions - 3 hours each

Thursdays - September 15 and September 22, 2022 from 9am - 12pm

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.

2 Online Sessions - 3 hours each

Wednesdays, October 12 and October 19, 2022 from 9am to 12pm

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 17, 2022 from 3pm - 5pm

This workshop is designed for anyone who uses Google Workspace / Gmail for professional, educational or personal purposes.  Participants will have hands-on experience managing and cleaning up Google Drive and Gmail  focusing on organizational tools with Drive folders, subfolders, naming, sharing & color coding and moving/archiving tips.  If you are new to Google and want to learn more about Gmail and Drive,  this is a great opportunity as well.

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).  

November 2 and November 3, 2022 from 3pm - 6pm

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).