Excel® 2010 Workbook for Dummies®

Chapter 24. Top Ten Tips for Using Excel Like a Pro

In This Chapter

• Generating new workbooks from templates

• Creating data series with AutoFill

• Trapping error values in their original formulas

Performing the exercises in this workbook gives you an opportunity to work with the most important features of Excel 2010, especially those related to building and maintaining spreadsheets. To help you make the most of this hands-on experience, this chapter brings together ten of the most important ways to work efficiently and design the best possible spreadsheets as you start to work on your own.

Generating New Workbooks from Templates

Whenever possible, generate new workbooks from templates that are available for Excel. Don't forget that the program provides you with a whole host of useful templates from online Office.com from Agendas to Time Sheets that you can start using right out of the box. To do so, just open the Available Templates panel in the Backstage View by clicking File

In addition to the templates listed in the various categories in the Available Templates panel, you can search Microsoft Office Online for other templates, which you can then download for use in Excel 2010. Simply click the Start Searching button (the one with arrow pointing to the right) located after the text box in the Office.com Templates section of the panel that contains, Search Office.com for Templates.

If you ...