Spreadsheets I

The first installment of Spreadsheets is a course that is built to teach the basics of Microsoft Excel including creating, managing, manipulating, and formatting spreadsheets and datasheets for practical uses in the library and business world. As datasheets in programs such as Excel are used often in administrative and acquisitions positions as well as by other members of staff for organizing and collecting information and even building basic databases, it is important to understand how they work and the functions that can be performed using them.

• Demonstrate an understanding of basic datasheet creation and manipulation including modifying tables and other aspects of a spreadsheet or database.

• Demonstrate an understanding of and be able to import and modify information from existing databases and spreadsheets.

• Demonstrate and understanding of and be able to create and manipulate formulas and functions resulting in calculations.

• Be able to create and analyze financial and non-financial charts and graphs created from data and other information found in the datasheet.