1. Excel Magic Trick 379: Round to Nearest 1/10th Hour for Payroll

  2. Excel Magic Trick 380: Negative Numbers Round To Nearest 5

  3. Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature

  4. Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List

  5. Excel Magic Trick 383:Conditional Formatting Between a Max and Min

  6. Excel Magic Trick 384: Keyboard Shortcut To Highlight 1000 Cells

  7. Excel Magic Trick 385: Generate Random Letters without RANDBETWEEN function

  8. Excel Magic Trick 386: Less Than the Letter M Conditional Formatting

  9. Excel Magic Trick 387: Data Validation Drop-Down List & Cell References

  10. Excel Magic Trick 388: Conditional Formatting and the Active Cell

  11. Excel Magic Trick 389: Ctrl + Period Keyboard Shortcut

  12. Excel Magic Trick 390: Increment Word & Number 2 Methods.

  13. Excel Magic Trick 391: Custom Number Format to Insert Symbol Automatically

  14. Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blank

  15. Excel Magic Trick 393: Remove Last Two Words From Column Of Data

  16. Excel Magic Trick #394: IF Function and Conditional Formatting

  17. Excel Magic Trick #395: When ROUND function Must Be Used

  18. Excel Magic Trick #396: COUNTIF function and Multiplying

  19. Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)

  20. Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values

  21. Excel Magic Trick 399: NA Error Trouble in Array Formula

  22. Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down

  23. Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable)

  24. Excel Magic Trick 402: Monthly Comparative Report - Pivot Table

  25. Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table

  26. Excel Magic Trick 404: Quarterly Comparative Report SUMIFS function

  27. Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function

  28. Excel Magic Trick 406: Add 1 Extra For Each Deposit

  29. Excel Magic Trick 407: Amortization Table W Variable Rate

  30. Excel Magic Trick 408: VLOOKUP MIN Value

  31. Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record

  32. Excel Magic Trick 410: VLOOKUP: Convert Web Query Result 78.9k to 78,900

  33. Excel Magic Trick 411: Expandable Ranges In SUMIFS function.

  34. Excel Magic Trick 412: Data Validation Drop Down List & OFFSET function

  35. Excel Magic Trick 413: Copied Web Site Data Trouble CLEAN TRIM Text To Columns

  36. Excel Magic Trick 414: Retroactive Dynamic Ranges!

  37. Excel Magic Trick 415: Summarize Survey Results 2 Different Methods

  38. Excel Magic Trick 416: Add Invoices w Same Prefix (Number v Text problem examined)

  39. Excel Magic Trick 417: Get Last Value from Multiple Sheets

  40. Excel Magic Trick 418: Reference Every Third Value

  41. Excel Magic Trick 419: Add Two Largest, But Skip Columns C & E

  42. Excel Magic Trick 420: VLOOKUP w SUM function in 3rd argument (Football Betting Table)

  43. Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Value

  44. Excel Magic Trick 422: Conditional Formatting 1st Two Rows Regardless of Sort

  45. Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function

  46. Excel Magic Trick 424: Conditional Formatting For Dynamic Range

  47. Excel Magic Trick 425: Functions That Can Handle Array Syntax And Do Not Require CSE

  48. Excel Magic Trick 426: VLOOKUP to Assign Category To A Sales Number

  49. Excel Magic Trick 427: Determine Day Name For Future Date

  50. Excel Magic Trick 428: Trouble Entering Dates - Date Syntax

  51. Excel Magic Trick 429: Count IDs that Are the Equivalent (DELTA function)

  52. Excel Magic Trick 430: Count Sales Numbers Greater Than Hurdle (GESTEP function)

  53. Excel Magic Trick 431: Excel 4 GET.CELL Macro Function

  54. Excel Magic Trick 432: Find & Extract Duplicate Records

  55. Excel Magic Trick 433: Custom Number Format for Showing Numbers Rounded to Thousands Position

  56. Excel Magic Trick 434: Extract Completed Records with Formula

  57. Excel Magic Trick 435: Extract Duplicate Records with Formula

  58. Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns

  59. Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays

  60. Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation

  61. Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)

  62. Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010

  63. Excel Magic Trick 440: Array Formulas Advanced Tips

  64. Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)

  65. Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods

  66. Excel Magic Trick 443: SUMIF Cumulative Sales Formula & Pivot Table Cumulative Sales Table

  67. Excel Magic Trick 444: Multiply Column Times Row With TRANSPOSE Function

  68. Excel Magic Trick 445: Complicated Criteria for MODE calculation LOOKUP

  69. Excel Magic Trick 446: Time In & Time Out in Same Cell Bad Setup Leads To Complicated Formula

  70. Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet

  71. Excel Magic Trick 448: OFFSET Function To Avoid #REF! Error

  72. Excel Magic Trick 449: Excel Data Analysis Abbreviated Notes

  73. Excel Magic Trick 450: Number Formatting Abbreviated Notes (House Paint or Halloween Mask)

  74. Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup

  75. Excel Magic Trick 452: IF Function Formula 16 Examples

  76. Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also)

  77. Excel Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions

  78. Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total

  79. Excel Magic Trick 456: Add Only Integer Part SUM & INT functions

  80. Excel Magic Trick 457: SUMPRODUCT & OR Criteria

  81. Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math

  82. Excel Magic Trick 459: Non-Zero numbers = TRUE IF Function logical_test Argument Tricks

  83. Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions

  84. Excel Magic Trick 461: Progress Toward Goal Chart or Thermometer Chart

  85. Excel Magic Trick 462:Show Formula Formula - Excel 4 Macro Function GET.CELL

  86. Excel Magic Trick 463: 4 ways to Add New Data To A Chart

  87. Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation

  88. Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions

  89. Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format)

  90. Excel Magic Trick 468: Count Spaces at Beginning & End of Text String (Array Formula)

  91. Excel Magic Trick 469: VLOOKUP for Horsepower Calculation

  92. Excel Magic Trick 470: Formula For Days In Any Given Month

  93. Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples

  94. Excel Magic Trick 472: Count Spaces at Beginning & End of Text String Simple Formula

  95. Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

  96. Excel Magic Trick 474: Conditional Format At Every Change In Value

  97. Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculation

  98. Excel Magic Trick 477: 13 Digit Number ID Shows Scientific Notation!?

  99. Excel Magic Trick 476: SUMPRODUCT Function for Weighted Average Cost From Transaction Data

  100. Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers

  101. Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations

  102. Excel Magic Trick 480: Percentage Of Total - Formula or PivotTable (Pivot Table)

  103. Excel Magic Trick 481: Change Operator in Formula from Drop-Down Using CHOOSE function

  104. Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheet

  105. Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers

  106. Excel Magic Trick 484: Stop Automatic Copyright symbol ©

  107. Excel Magic Trick 485: Create Shorthand to speed up typing using AutoCorrect

  108. Excel Magic Trick 486: Avoid #DIV/0! Error in Formula 4 Examples (Divide By Zero Error)

  109. Excel Magic Trick 487: Hyperlink That Opens Different Workbook or Goes To Different Sheet

  110. Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors

  111. Excel Magic Trick 490: Conditional Format for Budget Less Than $500.

  112. Excel Magic Trick 491: Count Matches in Individual Cells

  113. Excel Magic Trick 492: Count Matches in Single Cell

  114. Excel Magic Trick 493: Repeat a List of Names 7 times

  115. Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula

  116. Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)

  117. Excel Magic Trick #503: Custom Number Format For Turnover Ratio

  118. Excel Magic Trick #504: 3D Formatting For Cells Using Borders

  119. Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble

  120. Excel Magic Trick #506: Summarize Data - Multiple Sheets & Banks Accounts - Checkbook Register

  121. Excel Magic Trick #507: Fix Bad Data So We Can Add With Two Criteria & Make Summary Report

  122. Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function

  123. Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature

  124. Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changed

  125. Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

  126. Excel Magic Trick 512: Frugal Bargain Hunters - Series Discounts to Calculate Total Savings

  127. Excel Magic Trick 513: Equivalent Earnings Simple Formula

  128. Excel Magic Trick 514: Conditional Formatting Duplicate Values (3 Methods)

  129. Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creation

  130. Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References

  131. Excel Magic Trick 517: Vendor Name For Low Bid & % Cheaper Than Next Lowest Bid Formula

  132. Excel Magic Trick 518: Show Multiple Vendor Names Associated With Low Bid Array Formula INDEX

  133. Excel Magic Trick 519: SUBSTITUTE & REPLACE Functions

  134. Excel Magic Trick 520: FIND & SEARCH Functions

  135. Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding

  136. Excel Magic Trick 522: 30 Days In Each Month Calculations

  137. Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number

  138. Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods

  139. Excel Magic Trick 525: Advanced Filter With Wild Cards

  140. Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functions

  141. Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH

  142. Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions

  143. Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Product

  144. Excel Magic Trick 530: Does Text String Contain Repair OR Rework? OR SEARCH ISNUMBER functions

  145. Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)

  146. Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions

  147. Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekends

  148. Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays

  149. Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function

  150. Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL

  151. Excel Magic Trick 537: Drill Through Spreadsheets -- Formatting, Formulas, Editing

  152. Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through

  153. Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method

  154. Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method

  155. Excel Magic Trick 541: Get Last Price In Column Based On Criteria In Other Columns

  156. Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document

  157. Excel Magic Trick 543: Build Time Schedule With 15 Minute Intervals

  158. Excel Magic Trick 544: Conditional Formatting Row With Multiple Criteria In Other Columns

  159. Excel Magic Trick 545: Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCT

  160. Excel Magic Trick 546: Is Item List? Case Sensitive OR & EXACT functions

  161. Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computer

  162. Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

  163. Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?

  164. Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Dependent DV

  165. Excel Magic Trick 551: Count Mondays or Sundays or Tuesdays, etc. Between Start & End Date

  166. Excel Magic Trick 552: Display VLOOKUP Results Vertically

  167. Excel Magic Trick 553: SUMIF for Dollars and Euros

  168. Excel Magic Trick 554: Conditional Formatting for Weekends and Holidays Better than EMT 534

  169. Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculations

  170. Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table)

  171. Excel Magic Trick 557: CHOOSE function to lookup Formula or Function (2 Examples).

  172. Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table

  173. Excel Magic Trick 559: Extract Nth Word In Text String

  174. Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font White

  175. Excel Magic Trick 561: Wildcards * and ?

  176. Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not

  177. Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions

  178. Excel Magic Trick 564: Daily Gantt Chart

  179. Excel Magic Trick 565: Excel 2010 Daily Gantt Chart

  180. Excel Magic Trick 566: Conditional Format A Chart Student Grades

  181. Excel Magic Trick 567: Collapsible Expandable Cell Ranges

  182. Excel Magic Trick 568: SUMIFS function Monthly Running Total from Transaction Data

  183. Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formula

  184. Excel Magic Trick 570: Remove Duplicate Records Excel 2007 / 2010 Feature

  185. Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import

  186. Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax

  187. Excel Magic Trick 573: VLOOKUP & OR functions For Filtering Data With Categories of Criteria

  188. Excel Magic Trick 574: Array Formula For Filtering Data With Categories of Criteria

  189. Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes

  190. Excel Magic Trick 576: Dynamic Break Even Chart using INDEX and MATCH functions

  191. Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records

  192. Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Exists

  193. Excel Magic Trick 565: Excel 2010 Daily Gantt Chart

  194. Excel Magic Trick 564: Daily Gantt Chart

  195. Excel Magic Trick 579: MOD function and Date Math Each Successive Date Is Repeated Twice

  196. Excel Magic Trick 580: Extract Digits To Right Of Decimal Into Individual Cells

  197. Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter

  198. Excel Magic Trick 582: Excel Errors 9 Types - What They Mean - How To Fix Them

  199. Excel Magic Trick 583: AVERAGEIF & IFERROR functions Mixed Cell References Gross Profit Percentage

  200. Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names