Presented by SeniorNet, a program of Family Service League

Class Times: Friday April 16, 23, 30 May 7, 14 at 1:00 - 2:30 PM

Lesson 1: Excel Spreadsheet Basics
Friday, April 16, 2021 [1 PM – 2:30 PM]
• Preliminary considerations - including what Excel is used for
• What is a spreadsheet? What is a workbook?
• Reviewing a blank spreadsheet – including basic function
• Columns, Rows and Cells
• Adding contents to a cell
• Computation and Formulas – simple arithmetic
• Creating a Spreadsheet
• Saving the spreadsheet

Lesson 2: Spreadsheet Formatting
Friday, April 23, 2021 [1 PM – 2:30 PM]
• Inserting rows and columns
• Adjusting column width and row height
• Selecting and renaming tabs in a workbook
• Changing cell font size, type and other features
• Formatting cells for dates, numbers, currency, percentages
• Entering formulas into cells: copy & paste, using formulas, autofill

Lesson 3: Formatting Cells, Formulas and Cell Addressing
Friday, April 30, 2021 [1 PM – 2:30 PM]
• Freezing columns and rows
• Formatting cells
• Entering formulas into cells including copy & paste
• Absolute and Relative cell addressing
• Printing an Excel workbook

Lesson 4: Using Excel as a Database/Filtering, Sorting & Creating Charts
Friday, May 7, 2021 [1 PM – 2:30 PM]
• Using the spreadsheet as a Database: Range, Filtering and Sorting Data
• Using common statistical functions
• Creating Charts

Lesson 5: Excel Advanced, Pivot Tables, VLOOKUP, Data Validation
Friday, May 14, 2021 [1 PM – 2:30 PM]
• IF Function
• Pivot Tables
• VLOOKUP function
• Data Validation for drop down boxes

NOTE: If the class is sold out and you would like to receive an email if/when the class is offered again please send an email to fslseniornet@fsl-li.org. Be sure to include the name of the class you are interested in.