Microsoft Excel

PART 1 - Page 12
FIND THE FIRST NON-BLANK VALUE IN A ROW - Page 13
FIND THE FIRST NON-BLANK VALUE IN A ROW - Page 14
CALCULATE WORKDAYS FOR 5, 6, 7 DAY WORKWEEKS - Page 15
CALCULATE WORKDAYS FOR 5, 6, 7 DAY WORKWEEKS - Page 16
CALCULATE WORKDAYS FOR 5, 6, 7 DAY WORKWEEKS - Page 17
CALCULATE WORKDAYS FOR 5, 6, 7 DAY WORKWEEKS - Page 18
CALCULATE WORKDAYS FOR 5, 6, 7 DAY WORKWEEKS - Page 19
STORE HOLIDAYS IN A NAMED RANGE - Page 20
SUM EVERY OTHER ROW OR EVERY THIRD ROW - Page 21
SUM EVERY OTHER ROW OR EVERY THIRD ROW - Page 22
WHY THE MINUS MINUS? COERCE NUMBERS FROM TRUE/ FALSE - Page 23
WHY THE MINUS MINUS? COERCE NUMBERS FROM TRUE/ FALSE - Page 24
WHY THE MINUS MINUS? COERCE NUMBERS FROM TRUE/ FALSE - Page 25
INTRODUCING THE BORING USE OF SUMPRODUCT - Page 26
UNDERSTAND BOOLEAN LOGIC: FALSE IS ZERO; AND IS *,OR IS + AND EVERYTHING ELSE IS TRUE - Page 27
UNDERSTAND BOOLEAN LOGIC: FALSE IS ZERO; AND IS *,OR IS + AND EVERYTHING ELSE IS TRUE - Page 28
UNDERSTAND BOOLEAN LOGIC: FALSE IS ZERO; AND IS *,OR IS + AND EVERYTHING ELSE IS TRUE - Page 29
UNDERSTAND BOOLEAN LOGIC: FALSE IS ZERO; AND IS *,OR IS + AND EVERYTHING ELSE IS TRUE - Page 30
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS - Page 31
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS - Page 32
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS - Page 33
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS - Page 34
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS - Page 35
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS - Page 36
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS - Page 37
REFER TO A CELL WHOSE ADDRESS VARIES, BASED ON A CALCULATION - Page 38
REFER TO A CELL WHOSE ADDRESS VARIES, BASED ON A CALCULATION - Page 39
REFER TO A CELL WHOSE ADDRESS VARIES, BASED ON A CALCULATION - Page 40
POINT TO ANOTHER WORKSHEET WITH INDIRECT - Page 41
POINT TO ANOTHER WORKSHEET WITH INDIRECT - Page 42
POINT TO ANOTHER WORKSHEET WITH INDIRECT - Page 43
POINT TO ANOTHER WORKSHEET WITH INDIRECT - Page 44
GET DATA FROM ANOTHER WORKSHEET BY USING INDIRECT - Page 45
GET DATA FROM ANOTHER WORKSHEET BY USING INDIRECT - Page 46
USE INDIRECT TO GET A DATA FROM A MULTI-CELL RANGE - Page 47
ALWAYS POINT TO CELL B10 - Page 48
USE NATURAL LANGUAGE FORMULAS WITHOUT USING NATURAL LANGUAGE FORMULAS - Page 49
SUM A CELL THROUGH SEVERAL WORKSHEETS - Page 50
SUM VISIBLE ROWS - Page 51
SUM VISIBLE ROWS - Page 52
SUM VISIBLE ROWS - Page 53
LEARN R1C1 REFERENCES - Page 54
LEARN R1C1 REFERENCES - Page 55
LEARN R1C1 REFERENCES - Page 56
RANDOM NUMBERS WITHOUT DUPLICATES - Page 57
RANDOM NUMBERS WITHOUT DUPLICATES - Page 58
RANDOM NUMBERS WITHOUT DUPLICATES - Page 59
SORT WITH A FORMULA - Page 60
SORT WITH A FORMULA - Page 61
DEAL WITH DATES BEFORE 1900 - Page 62
USE VLOOKUP TO GET THE NTH MATCH - Page 63
USE VLOOKUP TO GET THE NTH MATCH - Page 64
USE VLOOKUP TO GET THE NTH MATCH - Page 65
USE A SELF-REFERENCING FORMULA - Page 66
USE A SELF-REFERENCING FORMULA - Page 67
USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA - Page 68
USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA - Page 69
USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA - Page 70
USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA - Page 71
FIND THE SUM OF ALL DIGITS OCCURING IN A STRING - Page 72
GET AN ARRAY OF UNIQUE VALUES FROM A LIST - Page 73
GET AN ARRAY OF UNIQUE VALUES FROM A LIST - Page 74
GET AN ARRAY OF UNIQUE VALUES FROM A LIST - Page 75
AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE - Page 76
AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE - Page 77
AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE - Page 78
AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE - Page 79
PART 2 - Page 80
USE AUTOFILTER WITH A PIVOT TABLE - Page 81
SORT SUBTOTALS - Page 82
COPY AN EXACT FORMULA BY USING DITTO MARKS - Page 83
RIGHT-DRAG BORDER TO ACCESS MORE COPYING OPTIONS - Page 84
RIGHT-DRAG BORDER TO ACCESS MORE COPYING OPTIONS - Page 85
QUICKLY CREATE A HYPERLINK MENU - Page 86
QUICKLY CREATE MANY RANGE NAMES - Page 87
QUICKLY CREATE MANY RANGE NAMES - Page 88
QUICKLY CREATE MANY RANGE NAMES - Page 89
ADD FORMULAS TO SMARTART - Page 90
ADD FORMULAS TO SMARTART - Page 91
ADD FORMULAS TO SMARTART - Page 92
CREATE A PIVOT TABLE FROM DATA IN MULTIPLE WORKSHEETS - Page 93
CREATE A PIVOT TABLE FROM DATA IN MULTIPLE WORKSHEETS - Page 94
CREATE A PIVOT TABLE FROM DATA IN MULTIPLE WORKSHEETS - Page 95
DETERMINE THE HEIGHT AND WIDTH OF THE DATALABEL OBJECT - Page 96
DETERMINE THE HEIGHT AND WIDTH OF THE DATALABEL OBJECT - Page 97
DETERMINE THE HEIGHT AND WIDTH OF THE DATALABEL OBJECT - Page 98
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO - Page 99
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO - Page 100
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO - Page 101
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO - Page 102
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO - Page 103
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO - Page 104
ADJUST XY CHART SCALING FOR CORRECT ASPECT RATIO - Page 105
PART 3 - Page 106
MAKE A PERSONAL MACRO WORKBOOK - Page 107
MAKE A PERSONAL MACRO WORKBOOK - Page 108
MAKE A PERSONAL MACRO WORKBOOK - Page 109
MAKE A PERSONAL MACRO WORKBOOK - Page 110
RUN A MACRO FROM A SHORTCUT KEY - Page 111
RUN A MACRO FROM A SHORTCUT KEY - Page 112
RUN A MACRO FROM A BUTTON - Page 113
RUN A MACRO FROM A BUTTON - Page 114
RUN A MACRO FROM A BUTTON - Page 115
RUN A MACRO FROM A BUTTON - Page 116
RUN A MACRO FROM A BUTTON - Page 117
RUN A MACRO FROM A BUTTON - Page 118
RUN A MACRO FROM A BUTTON - Page 119
RUN A MACRO FROM AN ICON - Page 120
RUN A MACRO FROM AN ICON - Page 121
RUN A MACRO FROM AN ICON - Page 122
RUN A MACRO FROM AN ICON - Page 123
RUN A MACRO FROM AN ICON - Page 124
RUN A MACRO FROM AN ICON - Page 125
CREATE A REGULAR MACRO - Page 126
CREATE AN EVENT HANDLER MACRO - Page 127
CREATE AN EVENT HANDLER MACRO - Page 128
EXTRACT AN E-MAIL ADDRESS FROM A CELL CONTAINING OTHER TEXT - Page 129
EXTRACT AN E-MAIL ADDRESS FROM A CELL CONTAINING OTHER TEXT - Page 130
EXTRACT AN E-MAIL ADDRESS FROM A CELL CONTAINING OTHER TEXT - Page 131
FIND THE CLOSEST MATCH - Page 132
FIND THE CLOSEST MATCH - Page 133
USE TIMER TO MICRO-TIME EVENTS - Page 134
USE TIMER TO MICRO-TIME EVENTS - Page 135
DISCOVER THE TEMP FOLDER PATH - Page 136
DISCOVER THE TEMP FOLDER PATH - Page 137
USE EVALUATE IN VBA INSTEAD OF LOOPING THROUGH CELLS - Page 138
USE EVALUATE IN VBA INSTEAD OF LOOPING THROUGH CELLS - Page 139
RENAME EACH WORKSHEET BASED ON ITS A1 VALUE - Page 140
USE A CUSTOM PULL FUNCTION INSTEAD OF INDIRECT WITH A CLOSED WORKBOOK - Page 141
IN VBA, DETERMINE THE NUMBER OF THE ACTIVE WORK-SHEET - Page 142
CREATE WORKSHEET NAMES BY USING THE FILL HANDLE - Page 143
CREATE WORKSHEET NAMES BY USING THE FILL HANDLE - Page 144
CREATE WORKSHEET NAMES BY USING THE FILL HANDLE - Page 145
CREATE WORKSHEET NAMES BY USING THE FILL HANDLE - Page 146
COPY THE PERSONAL MACRO WORKBOOK TO ANOTHER COMPUTER - Page 147
COPY THE PERSONAL MACRO WORKBOOK TO ANOTHER COMPUTER - Page 148
ADD FILTER TO SELECTION FUNCTIONALITY - Page 149
ADD FILTER TO SELECTION FUNCTIONALITY - Page 150
ADD FILTER TO SELECTION FUNCTIONALITY - Page 151
ADD FILTER TO SELECTION FUNCTIONALITY - Page 152
USE A MACRO TO HIGHLIGHT THE ACTIVE CELL - Page 153
USE A MACRO TO HIGHLIGHT THE ACTIVE CELL - Page 154
USE A MACRO TO HIGHLIGHT THE ACTIVE CELL - Page 155
REMOVE THE CAPTION BAR FROM A USER FORM - Page 156
REMOVE THE CAPTION BAR FROM A USER FORM - Page 157
KEEP A BUTTON IN VIEW - Page 158
ADD A RIGHT-CLICK MENU TO A USER FORM - Page 159
ADD A RIGHT-CLICK MENU TO A USER FORM - Page 160
ADD A RIGHT-CLICK MENU TO A USER FORM - Page 161
ADD A RIGHT-CLICK MENU TO A USER FORM - Page 162
FORMAT A USER FORM TEXT BOX AS CURRENCY OR A PERCENTAGE - Page 163
FORMAT A USER FORM TEXT BOX AS CURRENCY OR A PERCENTAGE - Page 164
DELETE RECORDS IN VBA - Page 165
DELETE RECORDS IN VBA - Page 166
SELF-SIGN YOUR MACROS FOR CO-WORKERS - Page 167
SELF-SIGN YOUR MACROS FOR CO-WORKERS - Page 168
SELF-SIGN YOUR MACROS FOR CO-WORKERS - Page 169
SELF-SIGN YOUR MACROS FOR CO-WORKERS - Page 170
MAGNIFY A SECTION OF YOUR SCREEN - Page 171
LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME - Page 172
LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME - Page 173
LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME - Page 174
LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME - Page 175
LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME - Page 176
LIST COMBINATIONS OF N ITEMS TAKEN M AT A TIME - Page 177
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 178
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 179
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 180
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 181
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 182
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 183
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 184
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 185
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 186
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 187
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 188
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 189
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 190
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 191
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 192
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 193
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 194
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 195
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 196
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 197
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 198
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 199
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 200
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 201
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 202
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 203
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 204
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 205
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 206
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 207
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 208
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 209
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 210
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 211
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 212
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 213
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 214
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 215
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 216
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 217
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 218
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 219
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 220
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 221
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 222
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 223
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 224
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 225
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 226
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 227
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 228
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 229
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 230
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 231
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 232
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 233
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 234
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 235
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 236
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 237
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 238
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 239
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 240
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 241
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 242
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE - Page 243