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 how 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 MacPart 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 by Jessica Parsons is licensed under a CC BY (Attribution) license
- Business charts on Pexels is licensed under a Pexels License license