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

Introduction to Quickbooks Desktop PC

with Tom Fragale

September 29th, 2021

$149 More Info

One of the challenges that a business owner/manager experiences on a regular basis is the process of running the business. They may have a great understanding of the products and services that the business offers, but they usually do not have a strong grasp of the day to day operations of that business. As a result, bills get paid late, customers are not billed on a timely basis or not at all, receivables are not collected. In other words, important things start falling through the cracks. QuickBooks is a great piece of software that helps get your business organized, and it is especially designed for people without an accounting background. This webinar will get you started and help you get some great results with QuickBooks.

QuickBooks can help you run your business better. You will get a better grasp of your payables, your receivables, your customers, and your day to day operations when you start to use QuickBooks the right way. This webinar will help you set up QuickBooks properly to better organize your company or organization’s finances.

Topics:• Setting up your company file• Managing Chart of Accounts• Setting up Bank Accounts• Adding Customers• Adding Products• Adding Vendors• Creating Estimates/Invoices• How to easily convert an estimate to an invoice• Creating Purchase Orders• Receiving Inventory• Paying Bills• Getting a quick snapshot of your company• Utilizing the many reports that come with QuickBooks• Creating Custom Reports

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
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
Image uploaded by NHTI's Business Training Center

Google Pro Microcredential

with Deb Boisvert

October 7th to November 18th, 2021

$279 More Info

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

Thursdays, Oct 7, 14, 21, 28, Nov 4 & 18.  3pm - 5pm

Register with Credit Card here.

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.

 

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 nhtibtc@ccsnh.edu

 

Image uploaded by NHTI's Business Training Center

Excel 102

with Tom Fragale

October 21st to 28th, 2021

$249 More Info

October 21 & 28, 2021 THURSDAYS 8:30am - 12:00pm  

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.

 

Image uploaded by NHTI's Business Training Center

Available ONLINE, ONDEMAND - Select your start date!  Register here.

If all you think Acrobat does is create PDF files, you're in for a big surprise! In this course, you will discover how to bring together a wide range of content from dozens of programs that you can reuse and customize in Acrobat X Pro.

Throughout this course, you will work with many features, such as backgrounds, bookmarks, and modified page sizes to help unify your documents. You'll discover how to add more to your documents as you learn about bookmarks and links for navigation. You'll even master some JavaScript! You'll also see how Acrobat X can help streamline the entire collaboration process and simplify how you conduct, control, and manage a document review cycle. In each lesson, you'll work with an important Acrobat X Pro feature or process using source files provided with the course. You'll soon see why Adobe Acrobat X has become the best-selling Adobe software of all time!

Online registration unavailable
Image uploaded by NHTI's Business Training Center

Excel 101

with Tom Fragale

October 7th to 14th, 2021

$249 More Info

2 Sessions - 3.5 hours each

Thursdays, October 7 & 14, 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.

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

Tuesdays, 10am - 12pm

September 14th - October 19, 2021

Using Data to Make Powerful Decisions

Advances in computing power have led to a massive explosion in the amount of data available for analysis.  But many businesses don’t take advantage of the opportunities for analyzing their data, and miss out on opportunities to improve their bottom line.  

This series covers an introduction to analytics and  common analytics tools and methods, providing  today’s professionals with an understanding of what it means to lead with data while actively working with visual datasets to develop best practices to tell a story or make an impact.   The program wraps up with the importance of understanding people analytics and forecasting in order to create effective action plans.  

Data Analytics for Leaders MicroCredential Certificate

By completing all sessions and intersession activities delegates will be awarded the Data Analytics for Leaders Microcredential Certificate. 

Workshop Descriptions

Session 1:  Introduction to Data Analytics for Leaders  

We can’t escape the presence of data in the media these days.  Advances in computing power have led to a massive explosion in the amount of data available for analysis.  But many businesses don’t take advantage of the opportunities for analyzing their data, and miss out on opportunities to improve their bottom line.   This first session will introduce leaders to what analytics is, and to common tools and methods used to perform analytics and convey results.  We’ll review examples in Descriptive, Predictive and Prescriptive analytics with an emphasis on concrete examples from business. 

Session 2: Data Literacy for Leaders 

Description:  As a leader responsible for the success of your organization, you need to be able to understand and take full advantage of your data.   But where do you start?  And how do you know which data you can trust? We’ll build on the concepts from Session 1 to address these questions, and chart a path forward to strategic use for yourself and for your team.

Session 3:  Storytelling Through Data Visualization / Communicate for Impact      

Description:  Numbers don’t tell the whole story.  They require context, they require an understanding of your business, and they require critical thinking.  In this session we’ll review best practices for presenting data through visual methods including graphs, infographics, and dashboards.  We’ll weigh the pros and cons of each, and discuss the merits of different types of charts, graphs and visuals to deliver your message.  

Session 4:   People Analytics   

Description:  Researchers are finding more and more evidence that leveraging human capital improves a company’s performance - its stock price, its customer satisfaction, its employee retention, and 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 resource. We’ll discuss examples of how data and analytics can help leaders understand the value of an engaged employee, recognize factors that lead to employee turnover, predict the future productivity of job applicants, and proactively uncover sources of top-caliber talent. 

Session 5:  Forecasting Basics & Pitfalls  

Description:  One especially helpful use of analytics for business is forecasting.  We’ll review several types of forecasting that are regularly employed by businesses, time-series (trend lines, moving averages)  and associative (correlation, regression).   No method is perfect, however, and we’ll discuss the advantages of each as well as the drawbacks.  We’ll also look at some of the common pitfalls that both analysts and decision-makers make, and suggest ways to mitigate for that.

Session 6:  Putting It All Together:  KPIs, Building an Action Plan, and Google Analytics  

Description:  Our final session will consolidate what we’ve covered into a plan for action going forward.  We’ll walk through how to determine what metrics and analyses are the important ones for you to focus on in your business, depending on what your goals are.  Using Google Analytics as an example, we’ll identify the metrics that you’ll want to be keeping your eyes on within your organization, what questions they can (and can’t!) answer, and what analyses you’ll need to be receiving on a regular basis.  We’ll discuss building the internal structure that will deliver these metrics and analyses to you, from reporting programs to the skills needed by your team members.

______________________________________________

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.

Image uploaded by NHTI's Business Training Center

L1 Google Certified Educator Prep

with Deb Boisvert

October 6th to 20th, 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 

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)