There are many ways to sort data in Microsoft Excel, and one of the simplest and most convenient is the SORTBY function. It ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

An Excel workbook called ISLMCS.xls provides a simple example of how to use Solver and the Comparative Statics Wizard to set up a standard short run macro model and then do comparative statics. The ...

Also, don’t worry about trying to remember all the options; Excel will provide drop-down lists with all the choices. Let’s work on a few examples using the AGGREGATE function. If you would like to ...