TechRepublic

How to remove duplicate Excel records before running a mail merge with Word

How to remove duplicate Excel records before running a mail merge with Word Your email has been sent Sending the same letter to a few people is easy, and you can probably have them all addressed and ...
TechRepublic

How to use the FILTER() dynamic array function in Excel

How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are ...
Hosted on MSN

How to Use the PIVOTBY Function in Excel

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect changes ...
EDN

Using Solver in Excel, Part 1

Solver allows you to use an Excel spreadsheet to easily solve problems with multiple variables. We'll look at a couple of examples to see what Solver can do and how easy it is to use. Solver is an add ...