Summer 2021 – NHTI
COVID-19 Announcements for NHTI Students, Staff, Faculty, and CommunityStay Connected
Original source: https://upload.wikimedia.org/wikipedia/commons/thumb/c/c9/Microsoft_Office_Teams_%282018%E2%80%93present%29.svg/1101px-Microsoft_Office_Teams_%282018%E2%80%93present%29.svg.png

How to Use Microsoft Teams

with Tom Fragale

June 17th, 2021

$99 More Info

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.

 

Image uploaded by NHTI's Business Training Center

Microsoft Office Productivity Bootcamp

with Tom Fragale

June 8th, 2021

$149 More Info

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.

 

Image uploaded by NHTI's Business Training Center

L1 Google Certified Educator Prep

with Deb Boisvert

August 5th, 2021

$149 More Info

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 Boisver, Google Certified Trainer

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

Optional Graduate Credit Add On

We have partnered with EdTechnologySpecialists to offer graduate credit from Colorado State University.  Graduate credit is optional.  If students want graduate credit from CSU, they will enroll and complete the online graduate credit component with instructor Allison Mollica.  Students will create a capstone project that demonstrates proficiency of various Google tools, including but not limited to Drive, Docs, Sheets, Forms, Youtube, Sites, Classroom, Slides, Meet, and others. The project will demonstrate how these tools will ignite learning and communication with students or parents, or both.

Register for the 1-credit graduate component here (optional)

Image uploaded by NHTI's Business Training Center

Excel 101

with Tom Fragale

June 15th to 22nd, 2021

$249 More Info

2 Sessions - 3.5 hours each

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

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.

Image uploaded by NHTI's Business Training Center

Microsoft Power BI Basics

with Tom Fragale

July 27th, 2021

$199 More Info

Tuesday, July 27, 2021 - 8:30am - 12:00pm

Microsoft Power BI is a collection of software services, apps and connectors that work together to turn your unrelated sources of data into coherent, visually immersive and interactive insights.  Learn how to import from Excel, Access, Text or Sql Server to manipulate data and create charts or reports.  Topics Include

  • What is Power BI?
  • The Power BI Parts - Desktop, Service & Mobile
  • Power BI concepts - datasets, reports & dashboards
  • Capacities - the resources for hosting and delivering Power BI content
  • Workspaces - Personal/Collaborative
  • Datasets and how they interact with workspaces
  • Shared Databases
  • Reports - creating and importing to dashboards
  • Dashboards - how to create and share
  • Data modeling & visualization basics
  • Transform, Filter & Clearing Data

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.

 

Image uploaded by NHTI's Business Training Center

Communicating Mindfully

with Dan Huston

July 8th to August 26th, 2021

$430 More Info

Over the last two decades, mindfulness has enjoyed an exponential rise in nearly every facet of society. From healthcare to education, the military to professional sports teams, training in mindfulness is improving people’s physical and psychological health, as well as their performance and life satisfaction. Many business leaders recognize the benefits mindfulness can bring to the workforce, including increased productivity and reduced healthcare costs.

This 8-part series introduces participants to the basics of Communicating Mindfully, a time-tested, internationally respected curriculum that infuses the study of mindfulness with the study of communication and emotional intelligence. Studies have shown participant improvement in all of these areas, suggesting this powerful combination increases a broad array of skills that benefit participants both personally and professionally.  Participants will deepen their understanding and practice of mindful communication through an in-depth look at the ways self-talk, self-concept, and assertive behavior impact communication.

The course is designed around the fact that each moment of our lives is unique and unpredictable. CM  provides participants with the skills they need to accurately assess internal and external factors involved in any given communication experience and make effective choices about how to communicate productively based on that awareness. Through the study of communication theory and mindfulness, participants learn to identify and modify unproductive communication habits, thus increasing their ability to manage stressful situations and improve relationships with others.

Required Text (not included):  Communicating Mindfully, Dan Huston

Communicating Mindfully for the Workplace Schedule

Meeting 1: Getting Started: Beginner’s Mind

Meeting 2: Conversation & Listening Skills: Paying Attention

Meeting 3: Becoming Better Listeners: More Than Meets the Ear

Meeting 4: Nonverbal Behavior & Physical Sensations

Meeting 5: Self-Talk: Getting to Know Ourselves

Meeting 6: Self-Concept: Who Do You Think You Are?

Meeting 7: Assertive Behavior: Tell It Like It Is

Meeting 8: An End and a New Beginning

Image uploaded by NHTI's Business Training Center

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. 

Image uploaded by NHTI's Business Training Center

Google Pro Microcredential

with Deb Boisvert

July 13th to 29th, 2021

$179 More Info

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

6 Session - 2 hours (1.5 instruction .5 guided application)

Tuesdays & Thursdays, July 13 - July 29

9:00am - 11:00am

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

 

Image uploaded by NHTI's Business Training Center

Introduction to SQL

with Tom Fragale

July 20th, 2021

$199 More Info

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.

Image uploaded by NHTI's Business Training Center

Excel 102

with Tom Fragale

July 15th to 22nd, 2021

$249 More Info

2 Sessions - 3.5 hours each

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

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.

 

Image uploaded by NHTI's Business Training Center

L2 Google Certified Educator Prep

with Deb Boisvert

August 12th, 2021

$149 More Info

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

_______________________________________________________

Optional Graduate Credit Add On

We have partnered with EdTechnologySpecialists to offer graduate credit from Colorado State University.  Graduate credit is optional.  If students want graduate credit from CSU, they will enroll and complete the online graduate credit component with instructor Allison Mollica.  Students will create a capstone project that demonstrates proficiency of various Google tools, including but not limited to Drive, Docs, Sheets, Forms, Youtube, Sites, Classroom, Slides, Meet, and others. The project will demonstrate how these tools will ignite learning and communication with students or parents, or both.

Register for the 1-credit graduate component here (optional)