Excel & Modelling Techniques · EXEMPLUM® INSIGHTS

Time for Positive Thinking

Giving Excel’s most misunderstood features a second look.

Excel advice often sounds absolute. This series asks when supposedly forbidden features may be useful—and where professional discipline should still draw the line.

Original articles and website editions. The list below currently links to the historical LinkedIn originals. As articles are published on EXEMPLUM®, the website editions will appear in the dedicated series category. The historical original dates are retained for reference.

Original publication index

Read the series in its original order. LinkedIn links open in a new tab.

  1. Episode 1

    Episode 1: Merge Ahead with Caution↗

  2. Episode 2

    Episode 2: The Circle of Life↗

  3. Episode 3

    Episode 3: Is it Cake? – The Pie Chart↗

  4. Episode 4

    Episode 4: OFFSET – Not Just a Volatile Relic↗

  5. Episode 5

    Episode 5: Hardcoded Values – The Taboo Nobody Talks About↗

  6. Episode 6

    Episode 6: Very Hidden Sheets – A Secret Worth Sharing↗

  7. Episode 7

    Episode 7: Named Ranges – A Spellbook for the Brave↗

  8. Episode 8

    Episode 8: Spilled Arrays – Elegant… or Explosive?↗

  9. Episode 9

    Episode 9: Excel Anxiety – In Praise of Paranoia↗

  10. Episode 10

    Episode 10: A Button and a Prayer – Goal Seek in the Wild↗

  11. Episode 11

    Episode 11: Table Manners – When Excel Tables Are Actually a Good Idea↗

  12. Episode 12

    Episode 12: Whispers in the Cells – In Defence of Comments and Notes↗

  13. Episode 13

    Episode 13: Watching You Watching Me – Excel’s Spy Tools for Modellers↗

  14. Episode 14

    Episode 14: Don’t Panic, It’s Manual – In Defence of Not Always Auto-Calcing↗

  15. Episode 15

    Episode 15: It’s Down There Watching You – The Hidden Power of the Status Bar↗

  16. Episode 16

    Episode 16: The Table That Turned – Why Excel’s Structured Tables Deserve a Second Look↗

  17. Episode 17

    Episode 17: If Error, Then What? – Learning to Love IFERROR (with Caution)↗

  18. Episode 18

    Episode 18: The Quiet Guardians – Why Every Serious Model Needs Audit Logic↗

  19. Episode 19

    Episode 19: The Forbidden Sensitivity – In Defence of Data Tables↗

  20. Episode 20

    Episode 20: Locksmithing for Modellers – In Defence of Protecting Your Workbook↗