Have you ever struggled to make sense of a dataset with too many categories or time-based data? It’s a common challenge—how do you present individual contributions while still showing the bigger ...

Want to get more out of Excel? At Microsoft’s inaugural Data Insights Summit last month, several experts offered a slew of suggestions for getting the most out of Excel 2016. Here are 10 of the best. ...

These four overlooked Excel features completely changed how I design spreadsheets.

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...