Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Quit the data-search struggle by organizing your raw data into a Microsoft Excel spreadsheet. Rather than manually scrolling through a list of disorganized records, use Excel's built-in tools to find ...

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

Update: There’s a more recent version of this article published here – Visualising geographic data in Excel 2016. If a picture says a 1,000 words, then a beautiful interactive map overlaid with ...