• Slides: 13

IS 171 Computing with Spreadsheets Introduction to Spreadsheets Week 1 Fred Ferwerda

Introduction o Course Overview and Policies o Where do spreadsheets fit? o The history of spreadsheets o Intro to Excel 2/20/2021 Fred Ferwerda 2

The Idea of a Spreadsheet o What is a spreadsheet? o What are its uses? o Have you ever used a spreadsheet? 2/20/2021 Fred Ferwerda 3

A Brief History of Spreadsheets o The accountant’s paper ledger o Dan Bricklin and Visi. Calc o Mitch Kapor and Lotus 1 -2 -3 o Bill Gates and Microsoft Excel 2/20/2021 Fred Ferwerda 4

The accountant’s paper ledger o o Big sheets of paper (spread out the sheets? ) Permits storing figures Fig. 1. 1, p. 2 of book 2/20/2021 Fred Ferwerda 5

Dan Bricklin (1951 -) and Visi. Calc o 1979 – Spreadsheet on Apple II o Visible calculator o Pushed sales of personal computers 2/20/2021 Fred Ferwerda 6

Mitch Kapor (1950 -) and Lotus 1 -2 -3 o 1982 – Spreadsheet on IBM PC o First to include Charts and Graphs o Very successful http: //www. nb-info. co. uk o 1985 – Bought out Visi. Calc 2/20/2021 Fred Ferwerda 7

Bill Gates and Microsoft Excel o 1985: originally written for Apple II o 1987: shipped with the introduction of the first Windows Oper. Sys. o Graphical interface 2/20/2021 Fred Ferwerda 8

Introduction to Excel o Spreadsheet: Excel calls it a Worksheet o A Workbook is a collection of worksheets o Grid of columns (labeled alphabetically) and rows (labeled numerically) o Each box is called a cell o Each cell is named by its cell reference (cell address) which is the column letter followed by the row number (e. g. , B 3) 2/20/2021 Fred Ferwerda 9

More on Excel o o Cells may contain: n Text (literals) n Numeric Data (numbers, percents, dates) n Formulas (=B 3+C 3) Electronic spreadsheet does the paper version one better: it performs the calculations 2/20/2021 Fred Ferwerda 10

Advantages o Labor Savings n n Increase all salaries for a company by 3%. Do this for 10, 000 or more employees! o Allows "what-if" analysis using scenarios o Allows graphing and charting o Allows use of complex functions (PMT, FV) o Allows data to be passed between worksheets 2/20/2021 Fred Ferwerda 11

Components of a Worksheet o Title Bar o Menu Bar o Toolbars n n n Standard toolbar Formatting toolbar View Toolbars menu option to display additional toolbars o Formula bar (active cell address and displayed value) o Worksheet area and scroll bars o Worksheet tabs 2/20/2021 Fred Ferwerda 12

Don’t let this happen to you! TM & © 2002 Grimmy, Inc. Mike Peters from http: //www. grimmy. com (9/5/02) 2/20/2021 Fred Ferwerda 13