October 2016
New Query button overview of Data tab MS Excel See Previous Post: Compatibility Web button functions Function Library MS Excel 2016 The Data tab ribbon has the Get & Transform group. So, the New Query button is part of this group. In this post, we’ll know further about this button. Also, this button has more other tools. To emphasize, the New […]
Compatibility Web button functions Formulas tab Excel See Previous Post: Cube Information button functions Function Library MS Excel 2016 Finally, the last two remaining are the Compatibility Web functions. So, these are part of the Function Library group. And, this is the first group of the Formulas tab ribbon. In the previous post, the Cube and Information button functions […]
Cube Information button functions in Microsoft Excel See Previous Post: Engineering button functions Function Library Microsoft Excel 2016 Earlier, in the post, we knew about on the Engineering button functions. These functions gets used for the engineering related tasks in Microsoft Excel. Some of they are the BIN2DEC, the CONVERT, the IMABS, the IMREAL and the OCT2HEX etc; and so on. […]
Engineering button functions of Formulas tab Excel See Previous Post: Statistical button functions Function Library group MS Excel 2016 Above all, this post is based on the Engineering button functions. So, as the name itself states, these functions gets used for the Engineering tasks in Excel. This button is part of the Function Library group of the Formulas […]
Statistical button functions Formulas tab Excel See Previous Post: Math Trig button functions Function Library MS Excel 2016 So, in this post, we’ll discuss about the Statistical button functions. Also, we’ve discussed the Math & Trig function of the Function Library group previously. To enumerate, few of the functions are the AGGREGATE, the PRODUCT, the SQRT, the SUMIFS and the […]
Math Trig button functions in Microsoft Excel 2016 See Previous Post: Lookup Reference button functions Function Library Microsft Excel 2016 So far now, we’ve already discussed, the five button functions. They are the Financial functions, Logical functions and the Text functions etc. Also are the Date & Time functions and the Lookup & Reference functions. But, in this post, the Math Trig button functions would be […]