Chapter 1

Learning the Secrets of the Excel:Mac Interface

1In this chapter, you'll learn the ins and outs of the Excel:Mac interface and the many secrets it holds.

We'll start by looking at the four main ways to control Excel: the Ribbon, the toolbars, 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 the Scrapbook.

Toward the end of the chapter, I'll show you the smart ways to view ...

Get Learn Excel 2011 for Mac now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.