Numerical Modeling with Spreadsheets: Microsoft Excel

Abernethy Ken, Furman University

This resource is no longer officially part of our collection This resource has been removed from our collection, likely because the original resource is no longer available. If you have further information about the link (e.g. a new location where the information can be found) please let us know.

You may be able to find previous versions at the Internet Archive.

This page provides the user with seven lessons explaining the use of spreadsheets for numerical modeling. Modern spreadsheets provide a rich environment for numerical calculation and the exploration of numerical models. Adding to the power of the environment, spreadsheets provide a great many built-in functions to perform commonly used computations in the financial, statistical, and other problem domains. Once calculations are performed, spreadsheets offer the opportunity to explore graphical interpretations of the results through a number of built-in chart and graph types. These pictorial interpretations often provide insights into the meaning of a calculation that would otherwise be difficult to perceive or that may even go unnoticed. The particular spreadsheet the user will learn about in these seven lessons is Microsoft Excel. Lessons include an overview of the Excel environment, using formulas for Excel calculations, using Excel's built-in functions, problem parameters and absolute addressing, charts and graphs in Excel, making decisions in Excel, and an Excel project.

This description of a site outside SERC has not been vetted by SERC staff and may be incomplete or incorrect. If you have information we can use to flesh out or correct this record let us know.

Part of the Starting Point collection. The Starting Point collection includes resources addressing the needs of faculty and graduate students designing, developing, and delivering entry-level undergraduate courses in geoscience.

Starting Point