PivotTables ebook extra now available


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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.

pivottables ebook extra now available microsoft excel 34630 - PivotTables ebook extra now available

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.

pivottables ebook extra now available microsoft excel 34631 - PivotTables ebook extra now available

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.

pivottables ebook extra now available microsoft excel 34632 - PivotTables ebook extra now available

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.

subs profile e1563205311409 - PivotTables ebook extra now available
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address