South Washington County Community Education

Do you spend a lot of time searching for data in large spreadsheets? Would you like to perform database functions such as filtering, subtotaling, and sorting directly in your Excel spreadsheet? Want to enter your data into a form rather than directly into rows and columns? Learn database design and data entry techniques as well as procedures to sort, filter, subtotal, and validate data. Discover how to: oUnderstand the "rules" of designing a database, oCreate a form for data input, *Easily find records in the database, oSort data alphabetically or numerically, oFilter data to display a subset of the data, oSubtotal data in a list. Prerequisite: Basic Excel capabilities including formatting. (Suggested course: Excel 2007 Getting Started.) Resource guide included in fee.