Spreadsheets

spreadsheet

  • Goals
    • Learn to create and manipulate a spreadsheet
  • Resources
  • Terms
    • cell
    • cell format (number, text, value, function, calculation, date, currency)
    • row
    • column
    • label
    • macro
    • replicate
    • template
    • worksheet
    • “what if” questions
    • range
    • absolute
    • relative reference
  • Concepts
    • Basic Calculations
    • Formatting Worksheets
    • Manipulating Data
    • Advanced Calculations
    • Making Data Visible
  • Projects
    • Basic Calculations
      • Add
      • Subtract
      • Multiply
      • Divide
      • Calculate averages
      • Find the maximum value
    • Formatting Worksheets
      • Format text
      • Format cells
      • Adjust columns and rows
      • Print worksheets
    • Manipulating Data
      • Move, copy, and paste
      • Add/delete columns
      • Add/delete rows
      • Employ multiple worksheets
      • Employ AutoFill
      • Insert/delete worksheets
    • Advanced Calculations
      • Create formulas across worksheets
      • Employ absolute references
      • Employ the function wizard
    • Making Data Visible
      • Add notes
      • Freeze panes
      • Create charts

Leave a Reply

Your email address will not be published. Required fields are marked *