Excel 101
with Tom Fragale
$249
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.
-
Jun 15 - 22nd, 2021
Tue for 2 weeks from 8:30 am - 12:00 pm
Online Class
For more info, call us at (603) 230-4022
