Office 2021 for Macs For Dummies

Chapter 16

Advanced Spreadsheeting

IN THIS CHAPTER

Making Excel your own

Using conditional formatting

Giving cell ranges memorable names

Adding multiple sheets to a workbook

Including hyperlinks

Collaborating with others and turning on revision tracking

Excel is the industry standard spreadsheet application — the one to which every other spreadsheet is compared — for a reason. Thus far, all challengers have come up short. Microsoft introduced Excel (on the Mac, first) back in 1985, replacing its Multiplan spreadsheet. One of Excel’s biggest features in the early days was that it was the first to let the user alter a sheet’s appearance by supporting multiple fonts, character attributes, and shading. Microsoft continued adding features, allowing users to control more of Excel’s functionality, including extensive automation capabilities.

In this chapter, you find out how to customize ...