One Possible Application: Plotting a pie chart based on income contributions from all your products and services(daily, weekly or monthly), and reviewing the automatically computed percentages/visual pie slices, can give very illuminating insight.
In addition, visualise it having dynamic query/report drop menu interfaces, and a variety of custom buttons: for navigation(within and between worksheets), printing, data export (as PDF documents or spreadsheet files), saving, auto_data filtering, auto_charts plotting, auto_backup of files, user login authentication (for documents with sensitive or confidential content) etc.
I believe using either of these two applications should not pose any problems for implementing your spreadsheet automation ideas. This is because both have always been "friendly", towards making it easy for users to get more functionality out of them by way of custom programming.
To experience the type of automation I refer to, you can email FREE demos of sample automated Excel VB driven spreadsheet applications like Ƒ) a Training Tracking Database(TM), ƒ) a Fiveƕ) Year Income & Expense Monitor(TM) or Ɠ) an Export Packing List & Invoice Generator(TM) to yourself using the file mailer on my website.