COVID-19 AnnouncementsStay 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/3/34/Microsoft_Office_Excel_%282019%E2%80%93present%29.svg/1101px-Microsoft_Office_Excel_%282019%E2%80%93present%29.svg.png

Excel 102 (21871)

with Tom Fragale

April 13th to 20th, 2022

$249 More Info

2 Online Sessions - 3.5 hours each

April 13th and April 20th 2022, 1:00 pm - 4:30 pm

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

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

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 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

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
Original source: https://upload.wikimedia.org/wikipedia/commons/thumb/3/34/Microsoft_Office_Excel_%282019%E2%80%93present%29.svg/1101px-Microsoft_Office_Excel_%282019%E2%80%93present%29.svg.png

Excel 101 (21870)

with Tom Fragale

March 16th to 23rd, 2022

$249 More Info

2 Online Sessions - 3.5 hours each

March 16th and March 23rd 2022, 1:00 pm - 4:30 pm

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.