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.
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.
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 Formatting, Tables, Relationships 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.