Spreadsheets and Databases
Wyo In-Service June 29, 2006
www.minich.com/education/presentations/spreadsheetsanddatabases.php

Learn more about how to make spreadsheets and databases work for your purposes. Topics such as managing and organizing data, choosing the application to fit the need, and how to navigate these formats will be included. Bring your laptop and your questions/needs! (Please note: Access is available only to PC users.)

J Kozlowski, L Balatgek, C Orzechowski

8-10 session
10-10:15 break
10:15-12:15 session
12:15-12:45 lunch
12:45-2:45 session

Excel -

• Beginner MS Excel - Learn how to use Microsoft Excel, the world's most popular spreadsheet application, to organize all kinds of work-related or personal data. Excel is very useful for keeping track of things such as your budget. It can also be used to organizing and alphabetize lists of information. You can easily graph bar charts, pie charts, and other kinds of graphs with a few clicks of the mouse.
• Intermediate MS Excel - Learn how to use Microsoft Excel, the world's most popular spreadsheet application, to organize all kinds of work-related or personal data. Excel is very useful for keeping track of things such as your budget. It can also be used to organize and alphabetize lists of information. You can easily graph bar charts, pie charts, and other kinds of graphs with a few clicks of the mouse. Learn how to create and use formulas and cell references to efficiently perform calculations. This workshop is suitable as a refresher for anyone with some experience with Excel. It is also geared for anyone who has not used Excel but is a good computer user in general.

Access

• MS Access - creating tables in Design View, entering data in Datasheet View, creating a simple report with the Report Wizard, updating data & viewing updated report, creating a simple query in Design View, running a simple query, creating a query with a calculated field, using a form to input data