Spreadsheet Automation
We've spent some time recently putting together a spreadsheet for a client to review advance reservations for a local Dinner Train. It is intended to help management and marketing look down the road to fine-tune marketing and social media efforts.
The magic is the use of templates and macros - the spreadsheet is designed to quickly and easily import data obtained from an eCommerce platform (Shopify), and with the push of a button, to sort, filter, and copy the data so that the charts are automatically produced - in less than a minute, and by users who are not spreadsheet gurus.