You’re probably familiar with selection shortcuts in Microsoft Excel. There are several that select text, sentences, whole paragraphs, and so on, so it should come as no big surprise that shortcuts ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...

Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a liner regression table. Even though the ToolPak ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Ever found yourself wondering if there’s a more efficient way to handle your data in Excel? If you’ve been using Pivot Tables but feel like you’re only scratching the surface, you’re in for a treat.

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.