Our ebook PivotTables and PivotCharts from scratch now has a bonus extra for all readers, new and existing.
Our Subscriptions Manager is an Excel workbook to organize online subscriptions like Netflix, HBO, Office 365 and (too) many more.
We’ve just added an enhanced version of the Subscriptions Manager to our ebook PivotTables and PivotCharts from scratch. The spreadsheet is available now to anyone who has already bought the book or gets it from today.
It’s an example of how Office-Watch.com ebooks gives customers more than just an ebook. We update and improve the ebooks over time.
Enhanced Subscriptions Manager
The improved workbook demonstrates more features of Excel 365 with a full explanation in a whole new chapter of the PivotTables and PivotCharts from scratch.
Not only can you use the Subscriptions Manager yourself, you can tinker with the workbook to see how we’ve made it happen.
Just some of the extras in the improved workbook:
- Added a broad category column to group subscriptions.
There are two fully working PivotTable/PivotChart combinations. Change the table or charts settings to see how the work together.
Both let you drill down to individual plans/payments.
Dynamic Arrays at work
Have you wondered why there’s all the fuss about Dynamic Arrays in Excel 365?
The Lists tab in the enhanced workbook has two examples of dynamic arrays displaying filtered versions of a table.
The example includes a way to make a pull-down selector from unique list in table. It’s not as simple as it should be!
Better Total row in Excel tables
Adding a Total row to an Excel table can add some limited options for totals etc. But often there’s plenty of empty space.
The special Subscriptions Manager workbook includes some tricks to show other summary details of the table.
Get the enhanced Subscription Manager
PivotTables and PivotCharts from scratch now has the new enhanced Subscriptions Manager with an extra chapter to explain the workbook and the tricks we’ve used to make it. Like all the sample workbooks in the ebook, we encourage readers to open and try them out for themselves.
Buy PivotTables and PivotCharts from scratch today to get the complete ebook (over 200 pages) including 12 sample workbooks.