View of entrance from Bitting Alley (Handicapped Accessable)
View of Front Door from Main Street

Upper Perkiomen Valley Library

My Account LoginSearch the Catalog

April 24, 2014

10:00 AM - Library Opens

6:00PM - Used Book Sale

8:00 PM - Library Closes

See Full Calendar

Adult Activities >

Microsoft Excel

Spreadsheets make it easier to view lists and numbers in an organized manner. Data can be sorted, filtered, and combined to suit your needs. Learn how to use spreadsheets to organize and manage all kinds of data.

This multi-part class covers the basics of creating a spreadsheet using Microsoft Excel 2007.

Part 1 - We will review the different parts of the Microsoft Excel Window and how they are used. Students will create a basic Excel worksheet representing a household budget for a single month. Topics include what is a spreadsheet, creating and saving a MS Excel Workbook, entering data, formatting cells and data, as well as performing simple calcualtions.

Part 2 - We will expand on our budget project by adding colums to report on our actual expenses and comparing them to our budget. Topics will include learning how to insert columns and rows, sorting data, and conditional formatting. Additional calculations will be performed and the autofill handle will be introduced.

Part 3- our MS Excel workbook will expand to contain a worksheet for multiple months with a summary sheet providing information for the entire year. We will also insert a graph to visually display our expenses and savings. Topics include copying, deleting, and renaming worksheets as well as basic graphic skill. Time permitting, we will discuss other applications for Excel workbook.

Bonus Topics - several topics are included in the lesson plan and will be reviewed if time permits. These include: Calculations using Time, Conditional Formulas, and Pivot Tables

Students should have a basic knowledge of Windows and good mousing skills.

Registration Required
Fee: $15.00

Classes are limited to 9 participants
Sign up in the library to reserve your seat

Activity Resources:

Microsoft Excel - Lesson Plan

Open in browser

Download

Microsoft Excel - Quick Reference

Open in browser

Download

Microsoft Excel - Window and Ribbon Components

Open in browser

Download

Microsoft Excel - Monthly Income.xlsx (for in class exercise)

Open in browser

Download

Microsoft Excel - Time Calculation Example

Open in browser

Download

©2014 Upper Perkiomen Valley Library   •   350 Main Street   •   Red Hill, PA 18076   •   215-679-2020   •  

  Web Design - Web Creations By Z - Palm PA