Filter by Subcategory
Computer Applications
Excel 101 (12835)
with Tom Fragale

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.
Excel 102 (12836)
with Tom Fragale

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.
Google Drive and Gmail Clean Up (13655)
with Deb Boisvert

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.
L1 Google Certified Educator Bootcamp (12838)
with Deb Boisvert

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
- 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).
L2 Google Certified Educator Bootcamp (12839)
with Deb Boisvert

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