Learn It
A spreadsheet is a file with cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, text, formulas, references and functions. We will even learn ho
w to embed charts and graphs into a spreadsheet. Spreadsheets are used to visualize data in a meaningful way that can be used to make complex decisions. Spreadsheets can take raw data, and tell a story with it.
Common Spreadsheet Software:
| Software Name | Type | Key Features |
|---|---|---|
| Microsoft Excel | Commercial | Runs on Windows and Mac
Part of Office 365 Recent features include robust formulas and functions, charts, graphs, and sparklines Arguably the most popular spreadsheet software |
| Google Sheets | Online | Included as part of a free, web-based software office suite offered by Google within its Google Drive service
Allows users to create, view and edit files online while collaborating with other users in real-time Available as a web application supported on Google Chrome, Mozilla Firefox, Internet Explorer, Microsoft Edge, and Apple Safari web browsers Compatible with Google Drive |
| Apple Numbers | Online | Part of the iWork productivity suite and runs on the MacOS, iPadOS, and iOS operating systems
Users feel that it is an easy-to-use application that allows them to quickly create spreadsheets on their Apple devices |
Going forward, we will focus primarily on Microsoft Excel.
Media Attributions
- Learn It Icon © Jessica Parsons is licensed under a CC BY (Attribution) license
- Business charts © Pixabay is licensed under a CC0 (Creative Commons Zero) license
Also known as worksheet, where data is entered for organization, analysis, and storage in tabular form in rows and columns of a grid and can be manipulated and used in calculations
The intersection of a row and column in a table
A horizontal group of cells in a spreadsheet, indicated with numbers
A vertical group of cells in a spreadsheet, indicated by letters
