4 ms·

So, yes, there is content that exists. What does not exist are real-world examples of problem solving a la open source. As I said in another comment, debugging

by css 8y ago

So, yes, there is content that exists. What does not exist are real-world examples of problem solving a la open source. As I said in another comment, debugging Excel is incredibly opaque (#NA) and most people will never find what they are looking for when they Google "=GETPIVOTDATA #NA error." There is no GitHub for Excel workbooks where people build and extend generalized solutions that people can read, understand, and learn from. There is also a total lack of comments in Excel formulas (short of VBA custom functions) so good luck deciphering the 5 line SUMIF in the 10 year old model you inherited.

intended 8y ago
You can get many, many excel sheets and examples which highlight problems and provide solutions. You can dowload a 3D graphics engine in excel if you so desire, as well as more mundane examples and videos. It’s not couched in engineering terms, but effectively a body of work and reference does exist to help people use excel - I’ve constantly used it to improve myself. It is definitely not made by engineers and coders, but by normal people and excel jockeys.