Business – NHTI
COVID-19 Announcements for NHTI Students, Staff, Faculty, and CommunityStay Connected
Image uploaded by NHTI's Business Training Center

REGISTER HERE  ONDEMAND - Self-Paced, start anytime or Instructor Led, pick your start date!

Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees who have the ability to send emails, create spreadsheets, manage databases, understand memory and network limitations, and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not.

This course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. This course will focus on practical application for software most common to the workplace. By the time you finish, you will have learned why employers consider technological literacy so critical to the success of any organization.

Lesson 1 - Overview: The Workplace Technology Solution

Lesson 2 - Outlook: Email and Scheduling

Lesson 3 - Word: Creating and Formatting Documents

Lesson 4 - Word: More Advanced Formatting

Lesson 5 - Excel: Spreadsheet Basics

Lesson 6 - Excel: Formatting, Charts, and Printing

Lesson 7 - Access: Database Basics

Lesson 8 - PowerPoint: Creating and Editing a Presentation

Lesson 9 - Integrating Microsoft Office Programs

Lesson 10 - Using the Internet

Lesson 11 - Transferring and Protecting Data

Lesson 12 - Putting Your Skills to Work

Online registration unavailable
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

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. 

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

Accounting with Quickbooks

with Ed2Go Online

$395 More Info

ONDEMAND - Instructor Led, pick your start date!  Register here.

Accounting Fundamentals covers all the bases, from writing checks to preparing an income statement and closing out accounts at the end of each fiscal period. Whether you're a sole proprietor looking to manage your business finances or you simply want to gain an understanding of accounting basics for career advancement or for personal use, this course will give you a solid foundation in financial matters.

Accounting Fundamentals II will provide you with a solid understanding of corporate accounting practices. You will learn key topics including as special journals, uncollectible accounts receivable, notes and interest, accrued revenue and expenses, dividends, retained earnings and more.

This QuickBooks Online will teach you how to manage your business financials with QuickBooks Online. You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; track payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting.

Learn to manage the financial aspects of your small business quickly and efficiently using QuickBooks Online. With this online version, you get all the advantages of computing in the cloud, so that your accounting files will be available to you virtually anytime, anywhere. This course is going to dive a bit deeper into some of the more intermediate-level features of the QuickBooks Online (QBO) program—from tracking product and service items and managing inventory to customizing sales forms.

Please complete the courses in the bundle two months apart to avoid overlapping. Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

 

Online registration unavailable
Original source: https://upload.wikimedia.org/wikipedia/commons/thumb/f/fd/Analytics_graphs_on_a_MacBook_screen.jpg/1280px-Analytics_graphs_on_a_MacBook_screen.jpg

Data Analytics for HR – MicroCredential Certificate

with Julie Alig

October 26th to November 30th, 2021

$725 More Info

HR Essentials!  Using Data to Make Powerful Decisions

Researchers are finding more and more evidence that leveraging human capital improves a company’s performance – its revenue, customer satisfaction, employee retention, and ability to attract new employees, among others.   As a leader responsible for the success of your organization, you need to be able to leverage data to take full advantage of this valuable resource.  This 6-week microcredential course will equip you with the skills and knowledge you need to begin doing just that.  In non-technical language, this introduction to the emerging field of “People Analytics” will review the basics of the theory, practice and terminology of people-centered analytics in organizations today.

Presented in six (6) two (2) hour sessions, you’ll learn what metrics are the most important to focus on for your organization, and importantly, which analytics are the most appropriate to use when answering the questions facing you and your colleagues.  We’ll address the challenge of data silos and of “messy data,” and review the lifecycle of an analytics project from conception to delivery of results.  Use cases will be drawn from areas including talent acquisition, employee retention, workforce planning, employee engagement, and compensation.  Finally, ethical considerations surrounding the use of employee data will be addressed. 

You’ll come away from this course with the ability to improve your decision-making by optimizing the use of data, analytical methods, and especially your human capital.

Data Analytics for HR Professionals MicroCredential 

Participants must complete all sessions in order to be awarded a certificate of successful completion. Participants are surveyed anonymously in advance of the training so as to give instructors a better sense of the participant’s background and expectations. Participants are also surveyed at the end of the program to determine the program's impact and to allow for feedback in order to continuously improve the program. 

Who Should Attend

This microcredential course is primarily designed for the Director level and above; for functional area leaders; general management; and C-suite executives who want to learn how to drive business results by incorporating human resources data and analysis into decision-making.

Participants should possess strong management and communication skills, as well as a basic working knowledge of Microsoft Excel.  No previous knowledge of or experience with statistics or analytics is required, though statistical tools and methods will be mentioned as appropriate in discussions of HR topics.

Workshop Descriptions

Session 1:  Analytics, and What It Can Contribute to HR; Descriptive, Predictive, etc.

Session 2:  Talent Acquisition

Session 3:  Retention and Turnover

Session 4:  Employee Engagement

Session 5:  Diversity and Inclusion; HR Metrics

Session 6:  Data to Action:  Persuasive Storytelling and Ethical Considerations

_____________________________________________

About Julie Alig, Ph.D.

Julie Alig is a data geek who’s passionate about telling stories and works with organizations, businesses, non-profits, colleges and universities, and other groups to uncover the stories in their data, using statistics and visualizations. Armed with this knowledge, they make strong, strategic decisions to move forward.  She earned her Doctorate in Political Science from the University of Chicago, and was awarded a Fulbright Scholarship to conduct her dissertation field research in Stuttgart, Germany.  She graduated cum laude from Columbia College in New York City with a Bachelor’s in History and French Literature.  She lives in Manchester with her husband and two children.

Original source: https://upload.wikimedia.org/wikipedia/commons/thumb/2/2f/Closeup_of_Excel_Spreadsheet_template_to_track_printouts_%2829911005444%29.jpg/1280px-Closeup_of_Excel_Spreadsheet_template_to_track_printouts_%2829911005444%29.jpg

Learn to Love Sheets

with Allison Mollica

May 7th, 2021

Free More Info

FREE!  Register here!

There are so many features built into Google Sheets that it can become overwhelming to know which are most beneficial.  In this session you will have 'HANDS ON' practice to learn many of the most common and handy sheets features!  Including:

  • Select ALL
  • Freeze, Sort & Filer
  • Conditional Formatting
  • Split Column (i.e. full name into separate colums)
  • Checkbox
  • Wraptext
  • AutoSum
  • AutoAverage
  • Create Chart
  • Explore Tool
  • Share & Comment
  • Data Validation
Online registration unavailable
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.