Using the Reference button on the Formulas tab for locating functions

- Excel has 404 built-in functions.…Some of them are specialized:…mathematical functions, engineering functions,…financial functions, some are more commonly used,…and each of us, perhaps, uses Excel…in a slightly different way…than the next person or the next person.…In this worksheet called Reference Button,…we've got some data in column A,…and it doesn't look the way we want it to.…It's all caps.…Now, we might or might not know…that Excel has a way to solve this issue…by turning data like this into…Abbott comma space James,…with only the A in the Abbott…and the J in James capitalized.…

Now, I could tell you that there's a function…in Excel that does that,…but if that's all the information you got,…how do you find it?…Where do you look?…On the Formulas tab in the ribbon,…there is a button called the Reference button.…And this brings up a dialogue box,…and ultimately, we could see a list of all functions.…You'll notice one by one…we see different categories here.…You might not know which category this falls into.…We could get a list of all these.…