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.
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.
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).
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.
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.