Computer and Technology Education at Saratoga Springs Public Library, Saratoga Springs, NY
Discover a variety of technology classes and other related resources offered year-round at the Saratoga Springs Public Library in Saratoga Springs, NY.
This 49-page document gives step-by-step instructions on how to create a simple spreadsheet, and, subsequently, build on the knowledge gained to create charts, Pivot tables, formulas, and more.
Understand absolute values when using this spreadsheet. Troubleshoot the errors and correct them. See how absolute referencing can be used with the more-popular relative referencing tools.
This exercise, from Professor Furman's website, explores not only absolute referencing, but use of the STDEV and AVERAGE functions as well as the IF function.
This spreadsheet displays an imaginary amount of money taken in by a store for selling a certain amount of inventory. Formulas are used to compute the amount taken in as well as the totals taken in thus far. A graph can be created comparing inventory on hand with sold inventory so the "store" can see where it stands at any given time.