Excel-Function

How to use Countif function with wildcards in Excel

Countif is an important function which is used to count number of cells which meet the given single condition or criteria. You can use Countif function to count number of cells which have any number, text or dates that match the given specific condition. But sometime we need to use wildcards for partial matching in the given range of cells in active worksheet. In that situation you must know how to use Countif function with wildcards in Excel Read More

Excel FV Function to know future value of an Investment

Hi friends today we are talking on Excel FV Function to know future value of an Investment. The Excel FV function is an important financial function. The Excel FV function allows you to quickly return the future value of an investment with constant interest rate, payments and periodic. FV stand for future values and this function is located in Formula > Financial library functions. Read More

How to use Excel FV – Future Value Function

Hi, today we are talking on The Excel FV – Future Value Function allows you to return the future value of an investment which is based on a periodic, constant interest rate, constant payments. Future value is an important and popular function which is located in the financial category. You can check this function from Formula tab then Financial functions library.

Read More

How to use index and match functions for advanced lookup in Excel

Hi, today we are talking on Index and Match most popular and powerful function in Microsoft Excel. You can use index match function in excel separately or with combination of other functions as per your need. In this guide we have to discuss how to use index and match functions for advanced lookup in Excel. Index and Match and VLookup functions found in the Lookup and Reference category.  Read More

Combine text from two or more cells into one cell in Excel

Excel allows you to merge or combine text from two or more cells into one cell in Excel. Most of the data in active worksheet in not always structured as per your requirement. In that situation you must have to properly set the data in each column separately. After that you must have to know quickly way to combine text from two or more cells into one cell in Excel sheet. Read More