Introduction
The spreadsheet’s purpose is to bring order to numerical data. With a spreadsheet app like Google Sheets or Microsoft Excel, you can take raw data that is very hard for humans to parse and create readable, engaging, and useful tables, charts, and graphs. These graphs can be imported into any other document such as a slideshow presentation or a text document.
The spreadsheet is the software that earned the computer its keep. The promise of being able to speed up the processing of tabular data is what convinced many corporations in the early days of computing to spend incredible sums of money on computers that, by today’s standards, were very rudimentary. The modern spreadsheet application is kind of like a programming language in itself. Even with a basic understanding of tables, tabular data, and spreadsheet software you can make data entry and processing a far easier task and even impress potential employers.
In This Chapter
Table of contents
- What is a spreadsheet?
- Tutorial 1.1 - Basic Formatting and Data Entry
- Tutorial 1.2 - Basic Formulas and Formatting
- Tutorial 2 - Formatting, Sorting, and Filtering
- Tutorial 3 - References: Absolute and Relative
- Tutorial 4 - Functions and Basic Charts
- Tutorial 5 - Excel Review
- Tutorial 6 - Tables Pivot Tables
- Tutorial 7 - Advanced Pivot Table Options
- Project 1 - Formulas Practice
- Tutorial 8 - Macros and Visual Basic
- Project 2 - Charting the Weather
- Project - Pencils and Pivot Tables
- Project 4 - Advanced Weather Charting
- Project - Charts and Rockets
- Project - Monthly Budget
- Project - The Environment