Excel Lessons for Second Year!

Spreadsheet-is a computer equivalent of a column pad paper.
consists of a grid made from columns and rows.
derived from the accounting file where business activities and transactions are kept track using large columnar pads called a “spreadsheet”

Spreadsheet Application Software-used to store data electronically
a better alternative to manually computing mathematical calculations and can be more accurate and time saving.

History of Excel
1978 VisiCalc (Visible Calculator)
- the 1st electronic calculator
- Daniel Bricklin (Father of electronic spreadsheet) and
Bob Frankston (co-creator) with
Daniel Flysra (founding associate editor of BYTE Magazine)

1979 Flystra joined Brikclin and Frankston in developing the VisiCalc.
- “ Personal Software”, a firm of Flystra began marketing VisiCalc
(later renamed VisiCorp)

- almost $1 Million copies of VisiCalc were sold

1980 Kapor (Product manager of VisiCalc) designed VisiPlot/
VisiTrend which he sold for $ 1 M

1982 Lotus 1-2-3 made it easier to use spreadsheets and it added
integrated charting, plotting and database capabilities.
Microsoft Excel was originally written for the 512 K Apple Macintosh in 1984-1985.

Excel was one of the first spreadsheets to use a graphical interface pull down menus and a point and click capability using a mouse.
Microsoft launched the Windows operating system in 1987.


What is spreadsheet?
Rows and columns of data.
Derived from the accounting file where business activities and transactions are kept track using large columnar pads.
Electronic Spreadsheet
- stores data electronically.
ADVANTAGE: It can automatically recalculate when changes are made to the data.

Ms-Excel
1.) Written and distributed by Microsoft for Windows and Apple Macintosh Operating System (OS).
2.) Is an electronic spreadsheet which allows users to manipulate numerical data with formulas and built-in functions
3.) One of the “most popular” micro-computer applications to date.
4.) The first spreadsheet program that allowed the user to define the appearance of spreadsheets(fonts, character attributers and cell appearance)
Advanteges of Excel
1.) Encoding, editing, and deleting data are easy.
2.) You can encode text, numbers, and formulas
3.) Numbers can be easily computed and analyzed.
4.) You can create graphs and charts on a given data.
5.) It can perform mathematical and statistical computations such as adding, averaging, conversion of numbers to trigonometric functions, logical comparisons, and financial calculations.
6.) It can also be used as a diary, calendar, and scheduler