Microsoft Excel Functions


VLookup function of Lookup & Reference in Microsoft Excel

VLookup function of Lookup & Reference in Microsoft Excel

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

Read More →

Read More →

Compatibility Web button functions Function Library group MS Excel

Compatibility Web button functions Function Library group MS Excel

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

Read More →

Read More →

Cube Information button functions of Function Library group Excel

Cube Information button functions of Function Library group Excel

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

Read More →

Read More →

Engineering button functions of Function Library group MS Excel 2016

Engineering button functions of Function Library group MS Excel 2016

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

Read More →

Read More →

Statistical button functions of Function Library group Microsoft Excel

Statistical button functions of Function Library group Microsoft Excel

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

Read More →

Read More →

Math Trig button functions of Function Library group MS Excel

Math Trig button functions of Function Library group MS Excel

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

Read More →

Read More →



Top