Chapter 3

Creating Effective Workbooks and Templates

In this chapter, I'll show you how to create workbooks in which you can enter, edit, and manipulate data quickly and effectively. You'll learn how to save the workbooks, which file formats to use when, and how to add property information to help you identify workbooks when searching.

You may need to start some workbooks from scratch, but you'll be able to save time and effort by basing other workbooks on templates. Excel comes with a good variety of templates, and you can download others from the Office web site; but to save the most time, you'll likely want to create your own templates, as discussed at the end of the chapter.

After seeing how to create and save workbooks, you'll learn how ...

Get Learn Excel 2011 for Mac 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.