Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest. This ...

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 ...

How to quickly make Excel subtotals stand out from the data Your email has been sent Microsoft Excel’s Subtotal feature is a great tool, but you can make the ...

Econometrics is important, but a great deal of the work of economists is simply looking at data, graphing data, charting data, calculating ratios and percent changes, and performing other data ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more. Everyone knows Microsoft Excel as a ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...

If you ask me, Excel's what-if analysis tools are under-used. I often respond to readers with "Have you tried a data table?" Invariably, they don't know how to implement the feature--sometimes, they ...

Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area. They are also useful for limiting the choices an Excel spreadsheet user can make when editing ...