Index
A note on the digital index
A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.
Symbols
- #NUM! error, Hack One of Excelâs Database Functions to Take the Place of Many Functions
- #VALUE!, Using SUMPRODUCT
- $ dollar sign
- Average function made absolute with, Manipulate Data with the Advanced Filter
- for absolute formulas, Add Descriptive Text to Your Formulas
- force ranges to be absolute, Using Relative References
- reference columns absolutely with, Highlighting Dynamically
- ' apostrophe
- allows for worksheet names with spaces, Extract Worksheet Names Only
- with INDIRECT function, Method 2: the INDIRECT Function
- () parentheses, Use CodeNames to Reference Sheets in Excel Workbooks
- * asterisk, Create Custom Number Formats, Password-Protect and Unprotect All Excel Worksheets in One Fell Swoop
- 1900 date system, Hack Excelâs Date and Time Features
- 3-D effects
- 3-D pie, Explode a Single Slice from a Pie Chart
- 3-D Pie icon, Explode a Single Slice from a Pie Chart
- applying automatically and dynamically, Using a 3-D Effect on a Table of Data
- data tables, Using a 3-D Effect on a Table of Data
- tables or cells, Create 3-D Effects in Tables or Cells
- 80/20 Rule for planning spreadsheets, The 80/20 Rule
- ; semicolon, Create Custom Number Formats
- = equal sign, Add Descriptive ...
Get Excel Hacks, 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.