If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple function lets you remove a specified number of rows or columns from the start ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Excel formulas are a powerful way to quickly manipulate and display the data in your spreadsheets to your exact specifications. Once you've created an effective formula for your data, you may want to ...

Excel's main function is to interlink cells, through the use of formulas, so that the formula cell changes when data is inputted into linked cells. The best way to store information in spreadsheets is ...

Please note: This item is from our archives and was published in 2003. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I often recruit ...

Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For ...