1. Thumbnail

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

  2. 2 Thumbnail

    Excel Magic Trick 380: Negative Numbers Round To Nearest 5

  3. 3 Thumbnail

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

  4. 4 Thumbnail

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

  5. 5 Thumbnail

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

  6. 6 Thumbnail

    Excel Magic Trick 384: Keyboard Shortcut To Highlight 1000 Cells

  7. 7 Thumbnail

    Excel Magic Trick 385: Generate Random Letters without RANDBETWEEN function

  8. 8 Thumbnail

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

  9. 9 Thumbnail

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

  10. 10 Thumbnail

    Excel Magic Trick 388: Conditional Formatting and the Active Cell

  11. 11 Thumbnail

    Excel Magic Trick 389: Ctrl + Period Keyboard Shortcut

  12. 12 Thumbnail

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

  13. 13 Thumbnail

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

  14. 14 Thumbnail

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

  15. 15 Thumbnail

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

  16. 16 Thumbnail

    Excel Magic Trick #394: IF Function and Conditional Formatting

  17. 17 Thumbnail

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

  18. 18 Thumbnail

    Excel Magic Trick #396: COUNTIF function and Multiplying

  19. 19 Thumbnail

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

  20. 20 Thumbnail

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

  21. 21 Thumbnail

    Excel Magic Trick 399: NA Error Trouble in Array Formula

  22. 22 Thumbnail

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

  23. 23 Thumbnail

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

  24. 24 Thumbnail

    Excel Magic Trick 402: Monthly Comparative Report - Pivot Table

  25. 25 Thumbnail

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

  26. 26 Thumbnail

    Excel Magic Trick 404: Quarterly Comparative Report SUMIFS function

  27. 27 Thumbnail

    Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function

  28. 28 Thumbnail

    Excel Magic Trick 406: Add 1 Extra For Each Deposit

  29. 29 Thumbnail

    Excel Magic Trick 407: Amortization Table W Variable Rate

  30. 30 Thumbnail

    Excel Magic Trick 408: VLOOKUP MIN Value

  31. 31 Thumbnail

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

  32. 32 Thumbnail

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

  33. 33 Thumbnail

    Excel Magic Trick 411: Expandable Ranges In SUMIFS function.

  34. 34 Thumbnail

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

  35. 35 Thumbnail

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

  36. 36 Thumbnail

    Excel Magic Trick 414: Retroactive Dynamic Ranges!

  37. 37 Thumbnail

    Excel Magic Trick 415: Summarize Survey Results 2 Different Methods

  38. 38 Thumbnail

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

  39. 39 Thumbnail

    Excel Magic Trick 417: Get Last Value from Multiple Sheets

  40. 40 Thumbnail

    Excel Magic Trick 418: Reference Every Third Value

  41. 41 Thumbnail

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

  42. 42 Thumbnail

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

  43. 43 Thumbnail

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

  44. 44 Thumbnail

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

  45. 45 Thumbnail

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

  46. 46 Thumbnail

    Excel Magic Trick 424: Conditional Formatting For Dynamic Range

  47. 47 Thumbnail

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

  48. 48 Thumbnail

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

  49. 49 Thumbnail

    Excel Magic Trick 427: Determine Day Name For Future Date

  50. 50 Thumbnail

    Excel Magic Trick 428: Trouble Entering Dates - Date Syntax

  51. 51 Thumbnail

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

  52. 52 Thumbnail

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

  53. 53 Thumbnail

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

  54. 54 Thumbnail

    Excel Magic Trick 432: Find & Extract Duplicate Records

  55. 55 Thumbnail

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

  56. 56 Thumbnail

    Excel Magic Trick 434: Extract Completed Records with Formula

  57. 57 Thumbnail

    Excel Magic Trick 435: Extract Duplicate Records with Formula

  58. 58 Thumbnail

    Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns

  59. 59 Thumbnail

    Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays

  60. 60 Thumbnail

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

  61. 61 Thumbnail

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

  62. 62 Thumbnail

    Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010

  63. 63 Thumbnail

    Excel Magic Trick 440: Array Formulas Advanced Tips

  64. 64 Thumbnail

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

  65. 65 Thumbnail

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

  66. 66 Thumbnail

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

  67. 67 Thumbnail

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

  68. 68 Thumbnail

    Excel Magic Trick 445: Complicated Criteria for MODE calculation LOOKUP

  69. 69 Thumbnail

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

  70. 70 Thumbnail

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

  71. 71 Thumbnail

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

  72. 72 Thumbnail

    Excel Magic Trick 449: Excel Data Analysis Abbreviated Notes

  73. 73 Thumbnail

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

  74. 74 Thumbnail

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

  75. 75 Thumbnail

    Excel Magic Trick 452: IF Function Formula 16 Examples

  76. 76 Thumbnail

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

  77. 77 Thumbnail

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

  78. 78 Thumbnail

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

  79. 79 Thumbnail

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

  80. 80 Thumbnail

    Excel Magic Trick 457: SUMPRODUCT & OR Criteria