admin@kcseforecast.com

+2541026301456

Spreadsheets

Spreadsheets

Outline Introduction to spreadsheets Introduction to MS Excel Formatting  Creating  formula  Functions CAT I (Take away) Functions II Functions III Functions IV Cat II  Charts    Data Analysis

Topic 1: Spreadsheets

Definition

Spreadsheet: application package designed to store, organize and manipulate numerical data and charts.

  • Also called electronic ledger.
  • Examples: MS Excel, Lotus 1-2-3

Uses of Spreadsheets

Accounting 

  • Prepare budgets
  • Calculate profits

Statistical analysis

  • Calculating statistical values e.g. mean, median etc.

Data management 

  • Organizes data in tabular manner
  • Operations include sorting, filtering etc.

Tracking value of assets 

  • Calculating appreciation and depreciation.

Forecasting

  • Its automatic recalculation feature enables ‘what-if’ analysis

Topic 2: Introduction to MS Excel

  • A product of Microsoft Corporation.
  • Versions: Excel 97, 2000, XP, 2003, 2007, 2010, 2013.

Excel Terminology

  1. Cell – intersection of a row and a column.
  2. Cell Address - consists of column letter and row number.
  3. Range – a group of cells
  4. Active cell – highlighted by thick borders.
  • location for typing into a worksheet.

       5.Worksheet- MS Excel working area.

  • Consists of rows and columns
  • Contains 1,048,576 horizontal rows (numbered 1 through 1048576) and 16,384 vertical columns from column A to column XFD.

       6.Workbook – refers to an MS Excel spreadsheet file. 

  • By default, consists of 3 worksheets.

The Excel Cell Referencing System

  • Each cell has a unique address.
  • An address consists of column letter and row number.
  • There are two cell referencing styles, the: 
  1. A1 style - An address consists of column letter and row number e.g. B3, D2 etc.
  2. R1C1 style – both the row and the column are numbered e.g. R2C4 etc.

 

The Excel window