SS101- Spreadsheet Basics

1. What is a Spreadsheet?
2. Common Office Software Suites
3. Basic Tasks
4. Basic Tasks Rewound
5. Navigation
6. Editing a cell
7. Selecting multiple cells
8. Autofill
9. First Formula: Sum
10. Sorting
11. Selecting a column
12. Resizing a column
13. Example family budget
14. Family budget tasks
15. Phone Book/Employee Directory
16. References

Synopsis

Learn how to use spreadsheets to store and analyze information into columns and rows. Find out how to sort a list of names and numbers, use basic formulas and create a family budget.

Course notes

1. What is a Spreadsheet?
   • Computer software used for storing and analyzing data in columns and rows.
   • Originally created for business accounting
2. Common Office Software Suites
   • LibreOffice
   • Google Office
   • Microsoft Office
   • OpenOffice
   • Microsoft Office Online
3. Basic Tasks
   • Create
   • Edit
   • Save
   • Print
4. Basic Tasks Rewound
   • Open a document
     • Easiest: Double-click on the file.
     • Launch SS; Then click File > Open.
   • Print a document
     • Click File > Print.
     • or, press Ctrl+P.
   • Create a document
     • Click File > New.
5. Navigation
   • Cells
   • Column headers are lettered
   • Row headers are numbered
   • Current Cell name/address box is upper-left
   • Formula Bar is upper-center
6. Editing a cell
   • Use the arrow keys or click on the cell
   • Start typing
   • Press Enter to finish, or Tab to advance
7. Selecting multiple cells
   • Click and drag from start cell to end cell
8. Autofill
   • Used to continue a list such as Numbers, Days, Months, Dates
   • Hover over the lower right corner of the cell
   • The cursor will change to a ＋
   • Click and drag down or right
9. First Formula: Sum
   • Select a vertical group of numerical cells
   • Click the Auto-sum (sigma) Σ button
   • The total of all numbers appears below the group
   • The formula bar now shows "=SUM(A1:A15)"
10. Sorting
    • Select a vertical or rectangular group of cells
    • Click on the Sort ascending button
    • Or, click Data > Sort...
11. Selecting a column
    • Click the column header
    • Right-click to see advanced options
    • For example, format numbers as currency
    • Same procedure also works for rows
12. Resizing a column
    • Hover over the line between two column headers
    • The cursor will change to a ↔
    • Click and drag left or right
    • Double-click the separator line to auto-size
13. Example family budget
    • Enter sample table data:
      

      Income		Expenses
      Paycheck	2000	Savings	90
      Interest	100	Housing	684
      		Food	252
      		Auto	252
      		Clothing	90
      		Entertainment	72
      Total		Total

14. Family budget tasks
    • Add formulas for totals
    • Calculate income vs. expense difference as 'Net Income'
    • Optionally, create a pie chart
15. Phone Book/Employee Directory
    1. Freeze header rows
    2. Sort by field
16. References
    • Spreadsheet - Wikipedia, the free encyclopedia
    • How to use a spreadsheet to create a simple budget
    • Budget Calculator - Crown Money Map™
    • Steps to Making a Budget
    • Excel Exercises 1-7 from Saint Paul Community Literacy Curriculum