“6 Excel habits I had to unlearn to get good at it”

6 Excel habits I had to unlearn to get good at it
https://www.makeuseof.com/excel-habits-to-unlearn/

  • Holding onto merged cells
    Pretty sheets aren’t worth broken filters and sorting
  • Keeping everything on one sheet
    Tabs exist for a reason
  • Burying my assumptions
    If it’s important, it deserves its own cell
  • Writing unreadable formulas
    Clear formulas beat impressive ones every time
  • Overusing volatile functions
    A slow spreadsheet is a frustrating spreadsheet
  • Ignoring documentation and version history
    Good spreadsheets explain themselves