Raw data used to unnerve me so much that I’d put off the work until I absolutely had to tackle it. That changed once I started using five simple tricks that can turn even the messiest sheet into a ...

Stop manually reformatting Excel spreadsheets. The Spill Manager add-in makes your formatting move dynamically with expanding arrays.

A missing Excel file isn’t always the disaster it feels like.

Reporting lots of large values in Excel is probably a good thing, but if you want them to be readable, try this easy technique. The article, Use a custom format in Excel to display easier to read ...

If you would like to display data in a more visually pleasing and easy to understand way. An Excel heatmap is a data visualization tool that uses color coding to represent different values in a range ...

Microsoft Excel’s Subtotal feature is a great tool, but you can make the results even better by customizing the format. Microsoft Excel’s Subtotal feature calculates subtotals and a grand total for ...