Microsoft Office 2011 for Mac: Visual QuickStart Guide

10. Spreadsheet Essentials

In This Chapter

Creating a New Workbook 176

The Excel Interface 178

Worksheet Navigation 181

Entering Data 182

Filling Cells with a Series 183

Editing Cell Data 184

Finding and Replacing Data 185

Adding Cell Comments 187

Naming Cell Ranges 188

Importing Data from a Text File 190

Working with Workbooks 192

Printing Worksheets and Workbooks 201

Excel is Office 2011’s spreadsheet application. By working in a grid of columns and rows called a worksheet, you can create lists, perform complex calculations, and graph important data.

In this chapter, we’ll explore the basic topics you’ll need to understand in order to begin using Excel, as well as a few advanced ones that you’ll want to refer to later:

• Creating new ...