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