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… .
The secret behind ...