Office 2021 for Macs For Dummies

Chapter 14

Crunching Numbers (and Data) with Excel

IN THIS CHAPTER

Selecting a template

Entering, formatting, and editing data

Using copy-and-paste for formatting

Using AutoFill

Checking for errors in your calculations

Filtering and sorting data

Using Find and Replace to help with editing your spreadsheets

Excel’s power as a spreadsheet derives from the flexibility it provides you in entering, formatting, deriving, analyzing, and presenting your data. Producing a bare grid of unformatted, manually entered text and numeric cells would make even the most compulsive Bob Cratchit exhausted, bored, and cross-eyed. Excel’s powerful formula creation tools help you quickly and easily calculate results from your data, and Excel’s formatting capabilities let you almost effortlessly draw attention ...