Computer Applications – 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

AutoCAD 2021 Certified User ONLINE

with Jennifer McMillan

$2595 More Info

ONDEMAND - Enroll anytime here.  Includes Software.

This 100% online AutoCAD 2021 training course will teach you how to create and edit a simple drawing, with a focus on the 2D tools within AutoCAD. Once you master the basic 2D skills, you will move on to explore more advanced efficiency tools, complex objects, using external reference and image files, collaboration tools, publishing, and enhancing productivity with simple customization. The course content is heavily focused on hands-on exercises which require that the software be installed. On course completion, you will meet the requirements needed to take the Autodesk AutoCAD Certified User exam.

This course offers enrollment with a voucher. The voucher is pre-paid access to sit for the certifying exam upon eligibility.

What you will learn

  • Use the AutoCAD software to create, edit, modify, and work with drawings.
  • Work and set up units and layers, create annotations (text, hatching, dimensions, multileaders, and tables) including annotation styles and setting up templates.
  • Create and insert reusable symbols using local/dynamic blocks with attributes and work with and modify external references in a drawing file.
  • Set up layouts (printing, manipulating, copying, creating viewports) and create, publish, and customize sheet sets.
  • Learn collaboration and automation tools and understand CAD management, system setup, and customizing the AutoCAD interface.

How you will benefit

  • AutoCAD is a mature software product.Companies who are recruiting would require knowledge of this product prior to hiring.
  • Taking this course provides the key skills to efficiently and effectively work with the 2D tools available in AutoCAD 2021.
  • At the completion of the course, passing the Autodesk Certified User exam provides potential employers with additional validation of skills
Online registration unavailable
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
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

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

Introduction to Photoshop CS6

with Sherry London

$115 More Info

Register here anytime - ONLINE & ONDEMAND. 

Photoshop is the world's most popular photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. Discover the fastest and most effective ways to use Photoshop from an expert and former columnist for Photoshop User magazine (who has twice been nominated for the Photoshop Hall of Fame).

The course provides detailed, step-by-step instructions for using Photoshop that you'll have no trouble following—even if you've never used a computer graphics program before! By the time you finish this fun, hands-on, project-oriented course, you'll be well on your way to expressing yourself with the most exciting graphics program ever developed!

 

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

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.