Excel Hacks
Subtitle: Tips & Tools for Streamlining Your Spreadsheets
Contributors: Hawley, Raina
Edition: 2nd Edition
Publisher: O'Reilly Media, Inc.
Published: 2008
Place of publication: Sebastopol
Language: eng
Format: [electronic resource] :
Number of pages: 541
ISBN-13: 9780596555283
Description: There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known backdoor" tricks for several Excel versions using different platforms and external applications."
Notes: Description based on print version record.
Table of contents: title: Excel Hacks, 2nd Edition; Contributors; Acknowledgments; Preface; Getting and Using the Hacks; How to Use This Book; How This Book Is Organized; Windows, Macintosh, and Earlier Excel Versions; Conventions Used in This Book; Using Code Examples; Safari® Enabled; How to Contact Us; 1. Reducing Workbook and Worksheet Frustration; 1.1.2. Structural Tips; 1.1.3. Formatting Tips; 1.1.4. Formula Tips; 1. Create a Personal View of Your Workbooks; 2. Enter Data into Multiple Worksheets Simultaneously; 1.3.2. Grouping Worksheets Automatically; 3. Prevent Users from Performing Certain Actions.; title: 1.4.2. Preventing Users from Printing a Workbook1.4.3. Preventing Users from Inserting More Worksheets; 4. Prevent Seemingly Unnecessary Prompts; 1.5.2. Prompting to Save Nonexistent Changes; 1.5.3. Stopping Excel & s Warning Prompts for Recorded Macros; 5. Hide Worksheets So That They Cannot Be Unhidden; 6. Customize the Templates Dialog and Default Workbook; 1.7.2. Using a Custom Default Workbook; 7. Create an Index of Sheets in Yo.