When it comes to mundane office programs, spreadsheet editors are some of the most powerful and versatile tools you're likely to come across. While Microsoft's Excel is what you likely associate with ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

You can use Microsoft Excel to set up a simple row-and-column matrix of information, listing income data, itemizing expenses and documenting events. These tasks barely scratch the surface of Excel's ...

I'm working with a VERY large excel spreadsheet and I'm trying to apply a bunch of formulas to some sorted data. The way the data is sorted normally, I can't easily apply a formula that will work for ...

It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make sure ...

I have a simple spreadsheet with 15 columns and ~200 rows. At some point when doing a custom sort on it, one of the columns was not selected, therefore destroying the relationship of the data. Excel ...

Mastering Excel goes far beyond SUM and VLOOKUP. By learning functions like COUNT, AVERAGE, SUMIF, SUBTOTAL, XLOOKUP, and INDEX/MATCH, you can find opportunities to improve your Excel sheet. Some ...