Skip to content

PivotTables ebook extra now available

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.

PivotTable/PivotChart combos

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.

Past purchasers of PivotTables and PivotCharts from scratch can login to their ebook account and download a complete replacement ebook including the new chapter and workbook.

About this author

Office-Watch.com

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.