Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know. Desktop-based Excel simply does everything one could ask for in a spreadsheet.

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