FRONT COVER -- TABLE OF CONTENTS -- ABOUT THE AUTHOR ACKNOWLEDGEMENTS -- FOREWORD -- DEDICATION -- PART 1 -- FIND THE FIRST NON-BLANK VALUE IN A ROW -- CALCULATE WORKDAYS FOR 5, 6, 7 DAY WORKWEEKS -- STORE HOLIDAYS IN A NAMED RANGE -- SUM EVERY OTHER ROW OR EVERY THIRD ROW -- WHY THE MINUS MINUS? COERCE NUMBERS FROM TRUE/ FALSE -- INTRODUCING THE BORING USE OF SUMPRODUCT -- UNDERSTAND BOOLEAN LOGIC: FALSE IS ZERO -- AND IS *,OR IS + AND EVERYTHING ELSE IS TRUE -- USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS -- REFER TO A CELL WHOSE ADDRESS VARIES, BASED ON A CALCULATION -- POINT TO ANOTHER WORKSHEET WITH INDIRECT -- GET DATA FROM ANOTHER WORKSHEET BY USING INDIRECT -- USE INDIRECT TO GET A DATA FROM A MULTI-CELL RANGE -- ALWAYS POINT TO CELL B10 -- USE NATURAL LANGUAGE FORMULAS WITHOUT USING NATURAL LANGUAGE FORMULAS -- SUM A CELL THROUGH SEVERAL WORKSHEETS -- SUM VISIBLE ROWS -- LEARN R1C1 REFERENCES -- RANDOM NUMBERS WITHOUT DUPLICATES -- SORT WITH A FORMULA -- DEAL WITH DATES BEFORE 1900 -- USE VLOOKUP TO GET THE NTH MATCH -- USE A SELF-REFERENCING FORMULA -- USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA -- FIND THE SUM OF ALL DIGITS OCCURING IN A STRING -- GET AN ARRAY OF UNIQUE VALUES FROM A LIST -- AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE -- PART 2 -- USE AUTOFILTER WITH A PIVOT TABLE -- SORT SUBTOTALS -- COPY AN EXACT FORMULA BY USING DITTO MARKS -- RIGHT-DRAG BORDER TO ACCESS MORE COPYING OPTIONS -- QUICKLY CREATE A HYPERLINK MENU -- QUICKLY CREATE MANY RANGE NAMES -- ADD FORMULAS TO SMARTART -- CREATE A PIVOT TABLE FROM DATA IN MULTIPLE WORKSHEETS -- DETERMINE THE HEIGHT AND WIDTH OF THE DATALABEL OBJECT -- ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO -- PART 3 -- MAKE A PERSONAL MACRO WORKBOOK -- RUN A MACRO FROM A SHORTCUT KEY -- RUN A MACRO FROM A BUTTON -- RUN A MACRO FROM AN ICON -- CREATE A REGULAR MACRO.

CREATE AN EVENT HANDLER MACRO -- EXTRACT AN E-MAIL ADDRESS FROM A CELL CONTAINING OTHER TEXT -- FIND THE CLOSEST MATCH -- USE TIMER TO MICRO-TIME EVENTS -- DISCOVER THE TEMP FOLDER PATH -- USE EVALUATE IN VBA INSTEAD OF LOOPING THROUGH CELLS -- RENAME EACH WORKSHEET BASED ON ITS A1 VALUE -- USE A CUSTOM PULL FUNCTION INSTEAD OF INDIRECT WITH A CLOSED WORKBOOK -- IN VBA, DETERMINE THE NUMBER OF THE ACTIVE WORK-SHEET -- CREATE WORKSHEET NAMES BY USING THE FILL HANDLE -- COPY THE PERSONAL MACRO WORKBOOK TO ANOTHER COMPUTER -- ADD FILTER TO SELECTION FUNCTIONALITY -- USE A MACRO TO HIGHLIGHT THE ACTIVE CELL -- REMOVE THE CAPTION BAR FROM A USER FORM -- KEEP A BUTTON IN VIEW -- ADD A RIGHT-CLICK MENU TO A USER FORM -- FORMAT A USER FORM TEXT BOX AS CURRENCY OR A PERCENTAGE -- DELETE RECORDS IN VBA -- SELF-SIGN YOUR MACROS FOR CO-WORKERS -- MAGNIFY A SECTION OF YOUR SCREEN -- LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME -- APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE -- INDEX.