Learning the Secrets of the Excel for Mac Interface
In this chapter, you’ll learn the ins and outs of the Excel for Mac interface and the many secrets it holds.
We’ll start by looking at the three main ways to control Excel: the Ribbon, the menus on the menu bar, and keyboard shortcuts. These give you great flexibility in the way you control Excel, especially when you set them up as you prefer.
From there, we’ll discuss how to navigate through worksheets and workbooks. We’ll then go through the various ways in which you can get data into your Excel workbooks—from importing existing data to entering it more quickly using AutoCorrect, AutoFill, and even the Replace feature.
Toward the end of the chapter, I’ll show you the smart ways ...