Chapter 24
Top Ten Tips for Using Excel Like a Pro
IN THIS CHAPTER
Generating new workbooks from templates and organizing worksheet data
Creating data series with AutoFill and using range names
Freezing row and column headings and catching data entry gaffes
Trapping error values and using array formulas
Using outlines and displaying worksheets side by side
Performing the exercises in this workbook gives you an opportunity to work with the most important features of Excel, especially those related to building and maintaining worksheets. 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 worksheets as you start to work on your own.
Generating New Workbooks from Templates
Whenever possible, generate new workbooks or custom templates from the templates that are available for Excel. Don’t forget that the program provides you with a host of useful online templates from meeting ...
Get Excel Workbook For Dummies, 2nd Edition 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.
