Microsoft Excel Functions

HLookup function of Lookup & Reference MS Excel Previous Post: VLookup function Lookup & Reference Microsoft Excel 2016 Alright, the previous post was on the VLookup function of the Formulas tab. Basically, this function helps us to retrieve answers referring from a column of a Table. Particularly, this table is in the Vertical direction. In fact, “V” is for Vertical, […]

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 […]