New Edition: PivotTables and PivotCharts from scratch


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

PivotTables and PivotCharts from scratch in a new edition strips away the techobabble so you can make your own PivotTables and make sense of any list of numbers or information. We do that with plenty of step-by-step instructions and, crucially, Excel worksheets you can open and try for yourself.

Understand PivotTables by looking at expert examples, tinkering with the setup to see what happens when you make changes. PivotTables aren’t black magic and you don’t need an advanced degree to understand them.

See for yourself examples of simple, ‘2D’ and nested row PivotTables plus filtering and the many calculation options. Slicers and Timelines demystified with examples to show that they important and simple PivotTable extras.

PivotTables and PivotCharts from scratch Chart with two slicers - New Edition: PivotTables and PivotCharts from scratch

PivotCharts have some tricks of their own, beyond what normal Charts can do. We start with a simple first PivotChart ‘from scratch’ then how to make it look better than the Excel defaults.

PivotTables and PivotCharts from scratch Chart with Slicer - New Edition: PivotTables and PivotCharts from scratch

New Edition

The 2nd edition has new chapters:

  • adding PivotTables/Charts to Word or PowerPoint
  • Ideas in Excel 365 to analyze your lists and quickly make PivotTables/Charts.
  • a full example of using the latest Stock prices and other data to analyze your Stock portfolio.

PivotTables and PivotCharts from scratch goes beyond the basics to show you PivotTable essentials like Conditional FormattingTablesRelationships and the important Data Model.  These aren’t usually included but we know they are vital to getting the most out PivotTables.

PivotTables and PivotCharts from scratch is available now just us$6.95 for Office Watch subscribers ($5 discount).

The new edition is available free to all purchasers of the 1st edition, just login to your Office Watch ebook account and download the latest version.

Real Time Excel is the associated book showing how to grab the latest stock, fund and exchange rate prices into Excel.  Also just us$6.95 for Office Watch subscribers.

subs profile e1563205311409 - New Edition: PivotTables and PivotCharts from scratch
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