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

Excel 101 (13620)

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.

Image uploaded by NHTI's Business Training Center

Mastering Public Speaking

with Curt Simmons

$115 More Info

Register here anytime.  ONDEMAND & ONLINE.  Self paced or instructor-led, you choose!  

 

You can become an effective public speaker! In this course, you will discover how to talk confidently and persuasively to both large audiences and small groups. You will also learn how to plan and deliver your presentations skillfully and how to manage one of the most common public speaking barriers—fear.

You'll learn the secrets to presenting a speech, how to handle questions and manage conflict in meetings, and even how to shine in a job interview. You will get tips for training your voice and learn how to use both verbal and nonverbal communication effectively. By the time you finish this course, you'll have an entire set of skills you can use on the job, in social settings, and in any other situation where you need to communicate with ease and authority!

 

 

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

Accounting Fundamentals

with Charlene Messier

$115 More Info

ONDEMAND - Self-Paced, start anytime or Instructor Led, pick your start date!  Register here.

In this comprehensive course, you will learn the basics of double-entry bookkeeping, as well as how to analyze and record financial transactions. You will get hands-on experience with handling accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities.

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.

Syllabus:

Lesson 1 - Account Classifications, Account Titles, T Accounts, and the Accounting Equation

Lesson 2 - General Ledger Accounts and the Balance Sheet

Lesson 3 - Journalizing Transactions and Posting to the General Ledger

Lesson 4 - Journalizing and Posting Cash and Charge Purchases and Payments on Account

Lesson 5 - Journalizing and Posting Cash and Charge Sales and Cash Received on Account

Lesson 6 - Payroll and Various Deductions

Lesson 7 - Banking Services and Reports

Lesson 8 - Posting Journal Totals to the General Ledger and Schedule of Accounts Payable and Schedule of Accounts Receivable

Lesson 9 - End-Of-Year Worksheet

Lesson 10 - End-Of-Year Financial Reports

Lesson 11 - Journalizing and Posting Adjusting Entries

Lesson 12 - Journalizing and Posting Closing Entries and Preparing a Post Closing Trial Balance

Online registration unavailable