Databases & Spreadsheets

Workshops → Databases & Spreadsheets

The smallest of the LST workshop series contains two of the most powerful software programs in our workshop quiver. Microsoft Access and Excel are the standards of data management and analysis in higher education and business alike. In these introductory workshops, you can learn how to build databases as well as organize, track and chart data. With Microsoft Access and Excel you can keep your information straight.

Microsoft Access

Microsoft Access is a powerful database management tool, widely used both in higher education and in business. Access makes it possible for even amateur programmers to create functional databases. In this beginning workshop, you will learn how to build a simple database, manage data, and create queries.
View online curriculum (Updated for Access 2007/Vista)

Microsoft Excel

Microsoft Excel is a helpful and powerful program for data analysis and documentation. In this introductory workshop, you will learn how to input data, apply relevant formulas, and visually represent your results with graphics and charts. Other topics covered include using the chart wizard, formatting cells and columns, and sorting data.
View online curriculum (Updated for Excel 2007/Vista)