Spreadsheets

This chapter will cover the use of spreadsheets, a way of arranging the data into rows and columns that can be edited using specific functions and formulas for analysis. After the data has been entered, and the necessary functions and formulas have been performed, the data can be displayed graphically.

Examples of Modern Spreadsheet Programs

• Microsoft Excel (required for this course)
• Libre Office Calc
• Google Sheets
• Apple Numbers
• Gnumeric

Learning Outcomes

• Be confident, capable, and competent in your use of Microsoft Excel in everyday and business applications
• Distill logical operations from word problems
• Evaluate the results of various logical operations
• Explain the difference and be able to utilize both formulas and functions
• Demonstrate capability of determining the output of conditional logic functions

This is a blank Microsoft Excel 2013 spreadsheet with menu bars:

Extra Resources

If you would like to learn more about Excel, NC State offers a free account with lynda.com, which hosts a variety of tutorial videos. Once you have set up your Lynda account, you can walk through Excel Training such as this one linked and earn a certificate.