PowerPoint and Excel: Perfect Partners for Dynamic Tables and Dashboards

PowerPoint 2010 and PowerPoint 2013 introduced improvements to a lot of features, but sadly PowerPoint Tables was not one of them (and I can say the same for Word Tables). In both apps, pretty much the only thing you can do with tables is add rows and columns, type in the information and, either apply a pre-existing style or laboriously create your own style which you can't even save as a template. So what's the alternative? In PowerPoint there is a little talked about feature under the Insert, Tables section of the toolbar called Insert Spreadsheet.