VLookup function of Formulas tab Excel 2016 Previous Post: Splitting data using Text to Columns button Microsoft Excel 2016 The Previous post was about the Text to Columns button of the Data tab. It helps to split any single column tabular data into multiple columns. To split any column data, it must be selected first, then the Text to Columns tool […]
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 […]
Stay Connected
Connect with us on the following social media platforms.