Chapter 9
Crunching Numbers
IN THIS CHAPTER
Creating powerful formulas with your bare hands
Beefing up your formulas with functions
Sorting and filtering your sheet data
Creating data eye candy with charts
Creating a nice, neat summary of your data with a pivot table
Although you can use Sheets as a simple database for storing text and numbers, that’s not what the program is designed to do. At its heart, Sheets is a powerful and sophisticated calculator that can take the raw data on a sheet and summarize it, analyze it, visualize it, and manipulate it in many different ways. In short, Sheets is all about crunching numbers, and that prowess is what this chapter is all about. In the pages that follow, I help you explore such number-crunching features as formulas, functions, sorting and filtering data, visualizing data with charts, analyzing data with pivot tables, and much more. There's a lot of ground to cover, so you had better get started… .
Building Formulas
The secret behind ...
Get G Suite For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
