Excel is a black box. When we use it, we have to take on faith that its statistics do what they say they are doing.
Just as people mistrusted hidden power in the medieval period, I must avoid any closed software when analyzing my historical data. I will use open-source programs (like R, QGIS, or simple text editing) to clean and process my data so the exact transformation steps are completely visible and not hidden inside a "black box".