Chapter    1

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 ...

Get Learn Excel 2016 for OS X, Second Edition 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.