Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

Excel’s data validation feature offers an efficient way to perform a variety of tasks. This collection of techniques demonstrates several handy ways to put data validation to work. From the ebook: ...

With any software, the more you use it, the more hacks and shortcuts you discover, and never a truer word has been said when it comes to Microsoft Excel. What's more, as the program evolves, you add ...

One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data. Excel has several features that ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...