Excel 101 – NHTI
COVID-19 Announcements for NHTI Students, Staff, Faculty, and Community

# Excel 101

with Tom Fragale

\$249

2 Sessions - 3.5 hours each

Tuesdays, October 7 & 14, 2021, 8:30am - 12:00pm

Check or PO payment using this form or email nhtibtc@ccsnh.edu

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
• Printing and page setup options
• Sorting basics
• Filtering basics
• Subtotals
• Charts
• 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:

• Deleting Sheets
• Changing a Sheets name
• Changing a Sheets color
• Moving Sheets
• Copying Sheets
• Navigating Sheets
• Linking Formulas from 1 sheet to another