Unfortunately, this is not a problem with the tool, Excel does what it’s supposed to. Any tool in the hands of someone not properly trained to use it, or without the discipline to use it correctly, adds a risk of incorrect output.
Unfortunately, this is not a problem with the tool, Excel does what it’s supposed to. Any tool in the hands of someone not properly trained to use it, or without the discipline to use it correctly, adds a risk of incorrect output.
On the other side of the spectrum there’s pure user error aka pebkac.
Where does this instance sit on the spectrum, I.e. even although it is possible to do a lot of things in excel, it’s often not a good idea to do many of things in it for a variety of deficiencies.
In some settings the sheets are just a giant white boards: different parts of the same sheet can contain partially replicated and not cross-checked data. Samples in columns, so each row is a different type. "Free flow of thought" or annotations of say numerical cell with text in the same cell.
All this steams from the fact that users do not see the data as something to be queried and compared but as a board one can just look at.