The First Rule of Microsoft Excel: Don’t Tell Anyone You’re Good at It

Re:The First Rule of Microsoft Excel: Don’t Tell Anyone You’... by css on Friday October 05, 2018 @06:25PM (#18152231)

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.

[ Parent | on HN ]

Re:The First Rule of Microsoft Excel: Don’t Tell Anyone You’... by intended on Saturday October 06, 2018 @01:30AM (#18153695)

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.

[ Parent | on HN ]