Excel’s VLOOKUP function is a powerful and helpful function that can help filter your data down to a desired item. It is sort of a combination of database functionality and search engine ease to refine your spreadsheet’s content to some given search item. However, VLOOKUP for all of its powerful abilities can sometimes be frustratingly… Read more 8 Most Common VLOOKUP Errors
Excel function XIRR is a financial function which returns the internal rate of return for a series of cash flows, occurring at irregular period intervals. The XIRR function includes an initial investment and net income values. This function is derived from the IRR function which does the same calculation but works only with regular (equal)… Read more Excel XIRR Function Examples
The CONCATENATE function in Excel enables a user to join two or more cells into one. We often need to join the first and last name into a full name or street, house number and city into a full address. One of the easiest ways to complete this is using the Concatenate function. In this tutorial,… Read more Excel Concatenate function examples and common errors
