Spreadsheets for Life & Business

Spreadsheets for Life & Business

1. Understand the uses of spreadsheets

   • For making Lists
   • Accounting
   • Time sheets
   • Flatfile database
   • Creating charts

2. Understand the use of formulas

   • SUM
     • SUMIF
   • AVERAGE
   • COUNT
   • IF
   • NOW
   • TODAY
   • COUNT

3. Spreadsheet layouts

   • Page orientation
   • Page margins

4. Formatting

   • Text wrap
   • Merge cells
   • Cell format
     • Number
     • Currency

5. Sorting a table

   • Alphabetically
   • Numerically

6. Spreadsheet models

   • Making predictions