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

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

Excel 102

with Tom Fragale

July 15th to 22nd, 2021

$249 More Info

2 Sessions - 3.5 hours each

July 15 & 22, THURSDAYS 8:30am - 12:00pm

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.