page 14

• MS Excel or Microsoft Excel

  Ø  Spreadsheet software

  Ø  Tracks data, creates charts, performs calculations

  Ø  Stores information in columns, rows

  Ø  Up to 256 columns, 65,536 rows per worksheet
• MS Excel  Projects:

  -          Budgeting displays

  -          Checkbook registers

  -          Enrollment records

  -          Inventories

  -          Coded surveys

  -          Field and laboratory research data

  -          Financial and accounting
• Major uses of Excel

  Ø  Widely used in financially-related activities

  Ø  Creates new spreadsheets for custom formulas, quarterly forecasts, annual reports

  Ø  Organizes and tracks information like sales leads, project status reports, contact lists, invoicing

  Ø  Useful for scientific, statistical analysis with large data sets

  Ø  Performs variance analysis, chi-square testing, charts complex data
• How Excel Works

  Ø  Excel document called Workbook

  Ø  Workbook has at least one Worksheet

  Ø  Worksheet is grid for storing, calculating data

  Ø  Many worksheets in a workbook, each with unique name

  Ø  Worksheets laid out in columns (vertical), rows (horizontal)

  Ø  Intersection of row, column is a cell for entering information, date, number, formula

  Ø  Each cell formatted individually with border, background color, font color/size/type
• Cell: Individual data box with corresponding Column, Row heading
• Cell Reference: Name of cell, column heading before row heading (e.g., A1 for first cell)
• Reference - A1 (Column A, Row 1)
• Formula and Function Management

  Ø  Formulas enable calculations in a worksheet.

  Ø  Excel recalculates values automatically based on changes in cell data.

  Ø  To enter a formula, start with = sign followed by the calculation.

  Ø  For example, =A1+B1 adds the values in cells A1 and B1.

  Ø  Functions are predefined formulas performing specific operations.

  Ø  Functions accept arguments and return results.

  Ø  Results can be calculations, text, references, logical values, or arrays.

  o   Examples include determining loan payments or calculating investment returns.