Your browser is not optimized for viewing this website.

More information »

NHTI's Business Training Center

Filter by Subcategory



Business

Microsoft Office Productivity Bootcamp

$149

with Tom Fragale

Calendar Jun 8, 2021 at 8:30 am

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.

 

Clean Up Google Workspace - gMail, Drive & BONUS Classroom

$65

with Deb Boisvert

Calendar Jun 10, 2021 at 3 pm

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 

 

Excel 101

$249

with Tom Fragale

Calendar Jun 15, 2021 at 8:30 am, runs for 2 weeks

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.

How to Use Microsoft Teams

$99

with Tom Fragale

Calendar Jun 17, 2021 at 9 am

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.

 

Clean Up Google Workspace - gMail, Drive & BONUS Classroom

$65

with Deb Boisvert

Calendar Jun 22, 2021 at 1 pm

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  

Communicating Mindfully

$430

with Dan Huston

Calendar Jul 8, 2021 at 10 am

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

Google Pro Microcredential

$179

with Deb Boisvert

Calendar Jul 13, 2021 at 9 am

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

 

Will run

Excel 102

$249

with Tom Fragale

Calendar Jul 15, 2021 at 8:30 am, runs for 2 weeks

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.

 





Forgot password?
Staff Log In