Excel hacks
If you think that getting creative with Excel means the underhanded tweaking of numbers, think again. Excel Hacks shows even the most experienced users how to do things with Excel they might never have thought of doing--and lets them have a little fun while they're at it. Microsoft Excel is n...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2004.
|
| Edición: | First edition |
| Colección: | Hacks series.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627177906719 |
Tabla de Contenidos:
- Excel Hacks; Contributors; Acknowledgments; Preface; Getting and Using the Hacks; How to Use This Book; How This Book Is Organized; Windows and Macintosh Users; Conventions Used in This Book; Using Code Examples; How to Contact Us; 1. Reducing Workbook and Worksheet Frustration; Structural Tips; Formatting Tips; Formula Tips; 1. Create a Personal View of Your Workbooks; 2. Enter Data into Multiple Worksheets Simultaneously; Grouping Worksheets Automatically; 3. Prevent Users from Performing Certain Actions; Preventing Users from Printing a Workbook
- Preventing Users from Inserting More Worksheets4. Prevent Seemingly Unnecessary Prompts; Prompting to Save Nonexistent Changes; 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; Using a Custom Default Workbook; 7. Create an Index of Sheets in Your Workbook; 8. Limit the Scrolling Range of Your Worksheet; 9. Lock and Protect Cells Containing Formulas; 10. Find Duplicate Data using Conditional Formatting; 11. Tie Custom Toolbars to a Particular Workbook
- 12. Outsmart Excel&s Relative Reference Handler13. Remove Phantom Workbook Links; 14. Reduce Workbook Bloat; Honing Data Sources; Cleaning Corrupted Workbooks; 15. Extract Data from a Corrupt Workbook; If You Cannot Open Your File; 2. Hacking Excel&s Built-in Features; 16. Validate Data Based on a List on Another Worksheet; Method 2: the INDIRECT Function; The Pros and Cons of Both Methods; 17. Control Conditional Formatting with Checkboxes; Toggling Number Highlighting On and Off; 18. Identify Formulas with Conditional Formatting
- 19. Count or Sum Cells That Meet Conditional Formatting Criteria20. Highlight Every Other Row or Column; 21. Create 3D Effects in Tables or Cells; 22. Turn Conditional Formatting and Data Validation On and Off with a Checkbox; 23. Support Multiple Lists in a ComboBox; 24. Create Validation Lists That Change Based on a Selection from Another List; 25. Force Data Validation to Reference a List on Another Worksheet; Method 2: the INDIRECT Function; The Pros and Cons of Each Method; 26. Use Replace... to Remove Unwanted Characters; 27. Convert Text Numbers to Real Numbers
- 28. Customize Cell Comments29. Sort by More Than Three Columns; 30. Random Sorting; 31. Manipulate Data with the Advanced Filter; 32. Create Custom Number Formats; 33. Add More Levels of Undo to Excel for Windows; 34. Create Custom Lists; 35. Boldface Excel Subtotals; 36. Convert Excel Formulas and Functions to Values; Using Copy Here as Values Only; Using a Macro; 37. Automatically Add Data to a Validation List; 38. Hack Excel&s Date and Time Features; Time and Date Calculations; Real Dates and Times; A Date Bug?; 3. Naming Hacks; 39. Address Data by Name
- 40. Use the Same Name for Ranges on Different Worksheets
