Excel functions Function Tips

The CONCAT, CONCATENATE and TEXTJOIN functions are popular as text combining functions, which have been designed to combine a range of strings that contain parts of text, phrases or numbers.

COUNTIF() family of functions is amongst the most frequency used family of functions in Excel.

One of the most versatile and highly used functions is VLOOKUP. Whenever we have a table and want to quickly retrieve a value, we have to revert to VLOOKUP. Let’s take a quick dive into its use and how we can get maximum out of its use.

Excel has so many functions that either one of their or their combination can fulfill most of the tasks required in our work places.

SUMIF() functions is among the most commonly used functions in excel. Whenever ever we have to sum against a given criteria we revert to this function, be the criteria be only one or more then one (for more then one criteria’s we use SUMIFS(), just another function of this family).

MS Excel offers seven logical functions, today we will discuss how to use AND () when summing up values.

We often see numbers stored in Excel as text which leads to wrong calculations, especially while using the cells in the functions i.e.

Included in the group of six functions released by Excel 2016 is a very valuable function; TEXTJOIN.

Microsoft Excel has many powerful functions which are very useful in manipulating data into meaningful information for all kinds of purposes.

There are many useful functions for Pivot Tables that are available in Microsoft Excel.

Microsoft Excel Pivot Tables have many functions available through the option of Show Values As. One particular calculation can be used to display the Parent Row Total Percentage.

At first instance, you may wonder why we would need to remove spaces in Excel. If you have unnecessary spaces it may prevent working of some functions, filtering etc.

MAXIFS function is considered to be one of the advanced statistical functions available in Excel.

You know the **functions** and **formulas** but need to practive your **Excel skills**? Or do you need **Excel Practice Tests** online? Well you are at the right place. We have free excel practice tests where you can sharpen your skill. These are not multiple choice questions in fact you learn by doing.

This new function allow to add handwritten equations to text, so you can add mathematical equations more easily to excel documents. The sketches of the equations can be made using a mouse or a digital/fingers.

**Vlookup** can be considered as one of the most beneficial functions offered in **Microsoft Excel,** which has become much useful in data analysis and data processing work.

Inserting rows in between selected rows, is one of the most necessary and important functions we require when working in excel worksheets.

Using UPPER(), LOWER() and PROPER() functions with NESTED IF().

Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.

Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list