Introduction to Spreadsheets
Introduction
A spreadsheet is a specialized electronic document that allows for data to be placed in rows and columns. They were modeled after financial accounting paper books, but quickly became a popular way to manage numeric data, dates, and even text. Information is organized into cells, which is a field for data placed where a specific row and column meet. Better yet, spreadsheets can calculate data using formulas; these can pull data from other documents or other cells in the same spreadsheet. That way, people can enter data in one cell and have the computer calculate all sorts of complicated math automatically. Text and numbers can be made easier to see, too: Spreadsheets can turn your data into graphs and charts, and they can be used to display text information, too, with the ability to change fonts and cell sizes.
Watch
- Google Sheets: Getting Started with Spreadsheets: https://goo.gl/5EZfVG Links to an external site. (YT 2:55)
- Excel 2016: Getting Started with Excel: https://goo.gl/5ru3C9 Links to an external site. (YT 4:20)
- An Introduction to Formulas in Numbers: https://goo.gl/wXCLNx Links to an external site. (YT 6:11)
Visit
- Wiki Kidz Search -- Spreadsheets: https://goo.gl/ej8mjJ Links to an external site.
- Mashable -- 9 Amazing Projects Made in Microsoft Excel: https://goo.gl/Fv2sWM Links to an external site.
- Zapier.com -- Google Sheets 101: The Beginner's Guide to Online Spreadsheets: https://goo.gl/sjEz78 Links to an external site.
Key Ideas
- Spreadsheets help you format and calculate with numbers, but also can be used to organize text data.
- Popular spreadsheet apps include Microsoft Excel, Google Sheets, and Apple Numbers.
- You can also use spreadsheet apps to create charts and graphs from your number data.
Apply
How about building a budget with a spreadsheet? See if you can follow these directions with either Excel or Google Sheets: https://goo.gl/vs1qWq Links to an external site.