Microsoft-Excel

How to convert standard date mm-dd-yyyy format into mm/dd/ format

Excel by default use MM-DD-YYYY format during filling the date in any cell. But most of the person use different format to fill the date of birth in Excel. Sometime we need to fill the date in different format as compared to standard format. In that situation it will take lot of time to do this job manually. In this guide we have to discuss how to quickly convert standard date mm-dd-yyyy format into mm/dd/ format using Find and Replace command. Read More

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

Beauty of Goal Seek feature in Excel to Find the Answer

Goal Seek feature in Excel is an important part of What-If-Analysis. it is an important feature of Excel which allows you how to one value in the formula impacts to other cell value. Goal Seek is the best tool used to find the result by adjusting an input value. There are lot of situation in which you can use Goal Seek feature during preparing different kind of reports. If you have more than one variable values and you want to change the final result value but want to apply effect only for one cell. Read More

Latest 7 Excel Tricks which makes you an Excel Expert

Excel plays an important role during daily working on different worksheets. If you have a big data than you must have to use given latest 7 Excel tricks which makes you an Excel expert. Most of the novice Excel users don’t about these tricks. But after using these tricks your working speed is faster than others. You can also gain lot of knowledge about the Excel. If you want to become an expert on Excel then you must know about the different Excel tips and tricks.  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