Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed

Chapter 17. Data-Based Documents: Formatting and Managing Worksheets

In this chapter, you will:

• Learn to approach workbook formatting methodically

• Set defaults for new workbooks

• Learn about the benefits of themes and cell styles

• Discover the advantages of Excel tables

• Explore page layout and header and footer options

Do you think of your Microsoft Excel files as documents? If not, you might be selling them short. Text-based documents—such as reports that require complex formatting with text, tables, and graphics—surely belong in Word. But when you share an Excel file containing worksheet data, charts, or maybe even PivotTable reports, you are absolutely sharing a document.

So, in the first of this book’s chapters on Excel 2010 and Excel for Mac 2011, ...