In today’s business world, just about every job requires some computer skills. Microsoft Office, also known as Office 365, is the software that most computers use. The Microsoft Office suite applications covered in this productivity bootcamp are Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. This 3-hour webinar will give you tips on all 3 products.

Topic 1:  Microsoft Word

When using tools like Microsoft Word, it is easy to ‘waste time’ doing things the ‘long way’  if you have not received proper instruction to reveal the tips and tricks for efficiency.    Topics with Word include:

• Selecting Text
• Pasting with Formatting
• Bullet Lists
• Number Lists
• MultiLevel List
• Tables
• Columns
• Page Setup
• Links to Documents or Web Pages

Topic 2:  Microsoft Powerpoint

• Adding Slides
• Adding Text
• Managing text boxes
• Slide Layouts
• PowerPoint Views
• Adding Background and Themes
• Adding Pictures
• Adding screenshots
• Managing pictures

Topic 3:  Microsoft Outlook Best Practices

• Sorting and Filtering Emails
• Flagging Emails for follow up
• Using Folders
• Creating Rules
• Using the Categories
• Conditional Formatting
• Send Later
• OOO Reply
• Turn on BCC 
• Reply or Reply to All
• Creating Contact Groups
• Signatures

_________________________________________________________

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.

He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.

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

Includes:

1.  Strategies to clean up GMail and keep it it under control

2.  Strategies to clean up, organize and manage DRIVE.

BONUS:  

3.  The steps to clean up, close out and archive Google Classrooms.  

Even if you don't use Google Classroom, what you learn to manage Drive & GMail will get your workspace 'in control' and help you keep it that way. 

Registration options:

• Credit card, just select the 'Register' button above.  
• Check payment using this form or email nhtibtc@ccsnh.edu 

2 Sessions - 3.5 hours each

Tuesdays, June 15 & June 22, 2021, 8:30am - 12:00pm

Check or PO payment using this form or email nhtibtc@ccsnh.edu   

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.

June 17, 9:00 - 10:30am ONLINE

Microsoft Teams is a collaboration app that helps your team or organization have conversations and stay organized all in one place.   With Teams you can host meetings, conduct chats, make calls, share files and more.  Learn how to leverage the basics of Teams with this introductory webinar.

Topics:  

Teams basics include an overview of the teams interface as well as creating, editing and using the core components.  Topic included in this introductory class include: 

• - Tour of Screen
• - Creating a team
• - Creating a channel
• - Editing a team
• - Inviting people to team/ channel
• - Start a meeting
• - Make audio and video calls
• - Sharing your screen
• - @mention someone
• - Add an emoji, mem, GIF
• - Sharing files
• - Collaborating on files
• - Wiki
• - Adding tabs
• - Feed
• - Work with files
• - Search
• - Apps

________________________________________________

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.

He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.

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

1.  Strategies to clean up GMail and keep it it under control

2.  Strategies to clean up, organize and manage DRIVE.

BONUS:  

3.  The steps to clean up, close out and archive Google Classrooms.  

Even if you don't use Google Classroom, what you learn to manage Drive & GMail will get your workspace 'in control' and help you keep it that way. 

_______________________________

Registration options:

• Credit card, just select the 'Register' button above.  
• Check payment using this form or email nhtibtc@ccsnh.edu  

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

Tuesdays & Thursdays, July 13 - July 29  9:00am - 11:00am

Check or PO payment using this form or email nhtibtc@ccsnh.edu     

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.

Outline:

Topic 1:  FUN Da Mentals - Google Environment and Google Drive

Dive into the Google world.   What is G Suite and what does it include - for personal and professional use

• Chrome browser Working with multiple accounts 
• Introduction to sharing, collaborating and 
• Organizing your drive to fit your needs. 
• Issues of security

Topic 2: Making  Gmail Work for You  

Set up your email to focus your time and attention

• Sort and prioritize your mail
• Customize your view your email so it works for you
• Add signatures, away messages
• Manage multiple email accounts
• Organizing Labels, Folders, Stars and more

Topic 3:  Learning to Love Sheets

From Collecting to analyzing data

• Setting up and organizing a sheet
• Manipulating data - sorting, filtering, freezing rows and columns
• AutoSum & Auto Average, suggested formulas and other basic formulas I(Concatenation, 
• Creating charts and graphs
• Collecting data with Forms

Topic 4 Taking Control of Your Time - Calendar, Meet, Keep and Task

Calendar for keeping on top of your life and coordinating with others. 

• Adding reminders and notifications
• Integrating your email
• Managing multiple calendars
• Integrate Calendar, Meet, *Keep and Task
• *Setting up appointment slots

Topic 5 Docs for Sharing and  Collaboration

More than word processing. 

• Sharing and Collaboration through our the Google world
• Giving Feedback
• Interactive documents
• History - Who did what when? (All app)
• * Integrating the world of Microsoft
• Copies templates, signature

Topic 6 Slides - the Grand Master of Layout and Publishing

The ultimate layout and publishing tool

• Slides for presentation from start to presentation
• Combining slides from multiple presentations
• * Using 3rd party resources to smooth the way.
• Ebook, booklets and templates

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. 

 NOTE:  Individuals / Groups that want to register via PO - please email amollica@ccsnh.edu

July 15 & 22, THURSDAYS 8:30am - 12:00pm

Check or PO payment using this form or email nhtibtc@ccsnh.edu    

Excel 102 - The Productivity Bootcamp  

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.

In today's world, the individual user may be given access to a large database, and they somehow have to make sense of this huge amount of data. This used to be the responsibility of an IT team, but these days the IT teams do not have the resources to write the reports needed by each person. Many databases use the SQL language to retrieve the proper data from the large database. This course shows you how to start writing your own SQL queries.

Topics Include:

• Select statements
• Giving the output field a different name
• Using Where statements to get the exact records you are looking for
• Using Order By statements to sort the data
• Creating Subtotals with the Group By statement
• Introduction to joining tables together

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.

He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.