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

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function for ...

If you want to be a master at Microsoft Excel then one of the things you must know are keyboard shortcuts. Not all of them, but mostly the best or more important ones. A lot of Excel users take ...

Another example: If you have cells named SubTotal and Tax, and type a formula =subtotal*tax Excel converts that to =SubTotal*Tax automatically. Because of this and because Excel puts functions in all ...

Excel at using Excel with these keyboard hotkeys that will save you minutes of time—and hours of aggravation. You may not realize it, but clicking around an Excel spreadsheet with your mouse is ...

Please note, there is a new version of this article, with more up-to-date information: 13 quick time-saving Excel tips and shortcuts. The one thing marketers agree on ...

You may not realize it, but clicking around an Excel spreadsheet with your mouse is wasting time—your precious time. There are hundreds of Excel shortcuts that you can use to complete a task without ...