You'll want to add this quick selection trick to your repertoire. It's handy when the range isn't a complete data range or it comprises more than one data range. You probably know about the [F5] key – ...

Here's a quick method, and the equivalent keyboard shortcut, for selecting an entire data range. Working with a complete data set is a common task in Excel. You might want to move the data, apply a ...

Excel isn’t the sexiest application in the world—it has an unfortunate association with the type of Milton-esque office drones we all wish we weren’t. All the same, you’re going to have to use at some ...

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 ...