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 ...
How-To Geek on MSN

Everything You Need to Know About Array Constants in Excel

Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...
TechRepublic

How to return the top or bottom n records without a filter or PivotTable in Excel

How to return the top or bottom n records without a filter or PivotTable in Excel Your email has been sent Returning the top or bottom n records of a data set in Excel isn’t difficult, and there are ...
TechRepublic

Office Q&A: How to evaluate the last rows in a changing data set in Excel

Office Q&A: How to evaluate the last rows in a changing data set in Excel Your email has been sent TechRepublic member Jeff has an interesting and challenging Microsoft Excel problem: He wants to ...