Brookfield Library News - Microsoft Excel Classes Beginning January 15, 2014

Schools and Libraries

December 23, 2013

From: Brookfield Library

Back by popular demand, we will be offering a series of introductory courses on Microsoft Excel 2010 beginning January 15, 2014.

Introduction to Microsoft Excel 2010

This course will be offered in 6 sessions, each with an afternoon and evening option.
 
You need not attend all sessions to participate. You should have some experience with computers and the Windows operating system before attending this class.
 
There is no charge for any of the classes in this series, but there is a one-time of fee of $10 to cover the cost of the course book (this book covers all 6 sessions). This fee may be paid at the Checkout Desk or via PayPal prior to the class, or on the day of the class.
 
Limit of 6 attendees per class. Register no later than 1 day prior to each class.
 
Registration begins Monday, December 30, at 8 a.m.

Session One

January 15 at 3:00 p.m. OR 6:30 p.m.

During session 1 of this hands-on 6-part series on Microsoft Excel you will learn the basics, such as:

- Learn about electronic spreadsheets
- Open Microsoft Excel
- Learn the parts of a spreadsheet
- Customize the Excel screen
- Save a spreadsheet
- Move around a spreadsheet
- Format cells and column width
- Create basic spreadsheets
 
Register for 3:00 p.m. class

Register for 6:30 p.m. class

Session Two

January 22 at 3:00 p.m. OR 6:30 p.m.

During session 2 of this hands-on 6-part series on Microsoft Excel, you will learn how to:

- Open an existing spreadsheet
- Select cells and enter data
- Format columns and rows
- Insert columns and rows
- Set margins and orientation
- Create a home inventory spreadsheet
-Print a spreadsheet
 
Register for 3:00 p.m. class

Register for 6:30 p.m. class

Session Three

January 27 at 3:00 p.m. OR 6:30 p.m.

During session 3 of this hands-on 6-part series on Microsoft Excel, you will:
 
- Create formulas
- Discuss aspects of good spreadsheet design
- Create budget spreadsheets
- Use icons the toolbars
- Use AutoFill Experiment with AutoFormat
-Learn about formula operators and errors
 
Register for 3:00 p.m. class

Register for 6:30 p.m. class

Session Four

January 29 at 3:00 p.m. OR 6:30 p.m.

During session 4 of this hands-on 6-part series on Microsoft Excel, you will:

- Create headers and footers
- Learn about chart types and elements
- Use chart tools to create a bar graph
- Use chart tools to create a pie chart
- Work with multiple tabs
- Print a chart
- Create a sales spreadsheet and chart
 
Register for 3:00 p.m. class

Register for 6:30 p.m. class

Session Five

February 3 at 3:00 p.m. OR 6:30 p.m.

During session 5 of this hands-on 6-part series on Microsoft Excel, you will:

- Create an annual budget spreadsheet
- Practice formatting cells, rows and columns
- Use AutoFill to create a series
- Freeze panes
- Use the Sum icon
- Create a comparison bar chart
- Create a credit card calculator
 
Register for 3:00 p.m. class

Register for 6:30 p.m. class

Session Six

February 5 at 3:00 p.m. OR 6:30 p.m.

During session 6 of this hands-on 6-part series on Microsoft Excel, you will:

- Create a medical expenses spreadsheet
- Create formulas
- Learn about data validation
- Duplicate a spreadsheet
- Experiment with spreadsheet templates on Microsoft Office Online
- Create a shortcut to an Excel file
- Learn about Keyboard Shortcuts
 
Register for 3:00 p.m. class

Register for 6:30 p.m. class