How-To Geek on MSN

How to Use the DROP Function in Microsoft Excel

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

How to filter data in Microsoft Excel to organize and sort your spreadsheet

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.
TechRepublic

4 ways to extract sort characters from data when they aren’t at the beginning of the value in Excel

4 ways to extract sort characters from data when they aren’t at the beginning of the value in Excel Your email has been sent Software Installation Policy Five ...
TechRepublic

How to use a custom sort on slicer buttons in Microsoft Excel

How to use a custom sort on slicer buttons in Microsoft Excel Your email has been sent Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list ...
MUO on MSN

I wish I knew about these two Excel functions before struggling with pivot tables

I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...