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 can't ...
Get Excel® 2010 Workbook for Dummies® 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.
