Corrections and additions to Support Microsoft com Listing of All Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2187804%22%20slang%3D%22en-US%22%3ECorrections%20and%20additions%20to%20Support%20Microsoft%20com%20Listing%20of%20All%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187804%22%20slang%3D%22en-US%22%3E%3CP%3EWho%20or%20to%20which%20department%20should%20I%20address%20this%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20don't%20think%20it%20would%20be%20appropriate%20to%20make%20separate%20discussions%20on%20each%20one%20although%2C%20in%20my%20view%2C%20some%20are%20extremely%20important.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20completed%20a%20review%20of%20the%20alpha%20listing%20of%20all%20Excel%20Functions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20about%2050%20corrections%20and%20additions%20and%20comments%3C%2FP%3E%3CP%3EThis%20is%20an%20important%20%22go%20to%22%20resource%20and%20I%20believe%20it%20is%20important%20that%20it%20should%20be%20authoritative.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2187804%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2194995%22%20slang%3D%22en-US%22%3ERe%3A%20Corrections%20and%20additions%20to%20Support%20Microsoft%20com%20Listing%20of%20All%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2194995%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F855269%22%20target%3D%22_blank%22%3E%40Norman_Harker%3C%2FA%3E%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20so%20much%20for%20putting%20a%20list%20as%20such!%20Please%20share%20it%20with%20me%20here%20or%20send%20me%20a%20direct%20message%20and%20I%20will%20make%20sure%20it%20goes%20to%20the%20right%20team%20to%20review%20and%20make%20corrections%20as%20appropriate.%3CBR%20%2F%3E%3CBR%20%2F%3EWarm%20regards%2C%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2195012%22%20slang%3D%22en-US%22%3ERE%3A%20Corrections%20and%20additions%20to%20Support%20Microsoft%20com%20Listing%20of%20All%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195012%22%20slang%3D%22en-US%22%3EWill%20do!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2202303%22%20slang%3D%22en-US%22%3ERe%3A%20Corrections%20and%20additions%20to%20Support%20Microsoft%20com%20Listing%20of%20All%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2202303%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20now%20completed%20my%20review%20of%20the%20Support.Microsoft.com%20list%20of%20all%20functions.%3C%2FP%3E%3CP%3EI%20attach%20the%20file%20with%20corrections%20and%20notes.%3C%2FP%3E%3CP%3EI%20shall%20be%20putting%20this%20up%20for%20comment%20in%20my%20LinkedIn%20group%20in%20the%20near%20future%20as%20there%20are%20quite%20a%20few%20descriptions%20on%20the%20various%20statistics%20functions%20that%20I%20would%20like%20to%20have%20competent%20statisticians%20look%20at.%3C%2FP%3E%3CP%3EI%20must%20admit%20to%20being%20surprised%20at%20some%20of%20the%20errors.%3C%2FP%3E%3CP%3EThanks%20for%20your%20attention.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2206048%22%20slang%3D%22en-US%22%3ERe%3A%20Corrections%20and%20additions%20to%20Support%20Microsoft%20com%20Listing%20of%20All%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2206048%22%20slang%3D%22en-US%22%3EThank%20you%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F855269%22%20target%3D%22_blank%22%3E%40Norman_Harker%3C%2FA%3E.%20I've%20shared%20your%20list%20with%20the%20team.%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20a%20great%20weekend!%3CBR%20%2F%3E%3CBR%20%2F%3ECuong%20(MSFT)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2206330%22%20slang%3D%22en-US%22%3ERe%3A%20Corrections%20and%20additions%20to%20Support%20Microsoft%20com%20Listing%20of%20All%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2206330%22%20slang%3D%22en-US%22%3EThanks!%20Some%20of%20those%20bloopers%20bring%20ridicule%20about%20a%20great%20product.%20And%20many%20of%20the%20changes%20are%20just%20questions%20of%20fact%20that%20are%20wrong.%20Wrong%20classification!%20Wrong%20year%20of%20introduction!%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20my%20view%2C%20confirmed%20by%20its%20placement%20of%20the%20link%20to%20the%20list%20in%20(e.g.)%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-au%2Fexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-au%2Fexcel%3C%2FA%3E%20the%20list%20of%20All%20Functions%20is%20one%20of%20the%20most%20important%20places%20that%20users%20go%20to%20for%20Help.%20If%20that%20is%20riddled%20with%20errors%2C%20you've%20shot%20yourselves%20in%20both%20feet%20before%20you%20start.%3CBR%20%2F%3E%3CBR%20%2F%3ENext%2C%20I'll%20be%20drilling%20down%20to%20Help%20on%20individual%20functions%20where%20I%20know%20of%20many%20more%20errors%20and%20omissions.%20I've%20given%20up%20pointing%20them%20out%20one%20by%20one%20on%20the%20link%20in%20each%20page%20-%20even%20the%20most%20obvious%20bloopers%20are%20ignored.%3CBR%20%2F%3E%3CBR%20%2F%3ERather%20than%20put%20the%20least%20skilled%2C%20knowledgeable%20and%20competent%2C%20members%20of%20the%20Microsoft%20team%20on%20creating%20the%20Help%20resources%20Microsoft%20should%20put%20their%20best%20ones.%20Just%20ask%20users%20what%20they%20think%20about%20the%20Help%20pages%20on%20Functions!%20And%20many%20of%20the%20web%20sources%20are%20equally%20bad%20or%20worse%20with%20many%20just%20vehicles%20for%20getting%20mugs%20to%20pay%20for%20over-priced%20and%20over-rated%20courses%20that%20I'd%20only%20recommend%20to%20an%20ex-wife.%3CBR%20%2F%3E%3CBR%20%2F%3ELess%20emphasis%20on%20making%20it%20look%20pretty%20and%20more%20on%20getting%20the%20material%20both%20helpful%20and%20correct.%3CBR%20%2F%3E%3CBR%20%2F%3ERant%20over!%20Normal%20service%20will%20now%20be%20resumed!%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20a%20great%20weekend!%20Keep%20yourself%2C%20your%20family%20and%20your%20friends%20safe.%3CBR%20%2F%3ENorman%3C%2FLINGO-BODY%3E
Contributor

Who or to which department should I address this to?

 

I really don't think it would be appropriate to make separate discussions on each one although, in my view, some are extremely important.

 

I have completed a review of the alpha listing of all Excel Functions

 

I have about 50 corrections and additions and comments

This is an important "go to" resource and I believe it is important that it should be authoritative.

 

9 Replies
Hi @Norman_Harker,

Thank you so much for putting a list as such! Please share it with me here or send me a direct message and I will make sure it goes to the right team to review and make corrections as appropriate.

Warm regards,

@cuong 

 

I've now completed my review of the Support.Microsoft.com list of all functions.

I attach the file with corrections and notes.

I shall be putting this up for comment in my LinkedIn group in the near future as there are quite a few descriptions on the various statistics functions that I would like to have competent statisticians look at.

I must admit to being surprised at some of the errors.

Thanks for your attention.

Thank you, @Norman_Harker. I've shared your list with the team.

Have a great weekend!

Cuong (MSFT)
Thanks! Some of those bloopers bring ridicule about a great product. And many of the changes are just questions of fact that are wrong. Wrong classification! Wrong year of introduction!

In my view, confirmed by its placement of the link to the list in (e.g.) https://support.microsoft.com/en-au/excel the list of All Functions is one of the most important places that users go to for Help. If that is riddled with errors, you've shot yourselves in both feet before you start.

Next, I'll be drilling down to Help on individual functions where I know of many more errors and omissions. I've given up pointing them out one by one on the link in each page - even the most obvious bloopers are ignored.

Rather than put the least skilled, knowledgeable and competent, members of the Microsoft team on creating the Help resources Microsoft should put their best ones. Just ask users what they think about the Help pages on Functions! And many of the web sources are equally bad or worse with many just vehicles for getting mugs to pay for over-priced and over-rated courses that I'd only recommend to an ex-wife.

Less emphasis on making it look pretty and more on getting the material both helpful and correct.

Rant over! Normal service will now be resumed!

Have a great weekend! Keep yourself, your family and your friends safe.
Norman

@cuong 

 

3 Months after reporting most of the bloopers in the Microsoft Support list of all functions. You shared the list with the team but the result of your action is zero.

 

Nothing has been changed.

 

How can this be escalated to someone who can actually do something.

The 7870 members of the LinkedIn Group that I manage are fortunate that they have a more reliable source than Microsoft.

@Norman_Harker thanks for the follow up.  Let me check with the team on the status of updates.  Appreciate your staying on top of it.

 

Have a great weekend!

 

Thanks! After correcting the bloopers in the All Functions listing, I've drilled down to the help file for each function where there are also a large number of patent errors, most of which have been there for ages. For example, the formula given for RRI is wrong (missing parentheses) and so is the formula for MIRR (a complete mystery because I don't believe there is an explicit solution).

A good 4th July long weekend.

Aussies are very lucky you declared independence because that led to the establishment of Australia as a replacement colony for dumping English convicts.

@Norman_Harker Thank you! I heard from the doc team over the weekend. They are working through your feedback - thank you. At the same time, they are focused on updating over a thousand support articles for the next perpetual release of Office LTSC - see Upcoming commercial preview of Microsoft Office LTSC | Microsoft 365 Blog for more info on this release.

 

We really do appreciate your feedback. Please keep them coming. We are working through them.