Tame your computer - add Pivot power

In her regular series for Cambridge Network members - now in its 15th year - software training expert Karen Roem offers handy tips to help you 'Tame your computer'.  This week she describes how to create PivotTables - no know-how necessary (Excel 2013 onwards).

Roem tip time logo

If you have large amounts of information in Excel you probably (read: hopefully) use its powerful table management features to help you quickly retrieve and manipulate data. Perhaps you also use PivotTable reports to interactively summarize your data? Or maybe you’ve heard of PivotTables but never looked into them as yet? Or perhaps you don’t know what you don’t know?

Well you don’t have to … as long as you use version 2013 or later and your data has column headings, Microsoft will suggest a set of PivotTable reports it feels are most applicable.

Here’s how:

  1. Click anywhere in your data.
  2. On the Insert tab click on Recommended PivotTables (the second button from the left).
  3. Use your downward arrow to flick through the various recommendations.
  4. Click OK.

Your report has been inserted in a new sheet; your “raw data” is still intact and could be used as a basis for other summary reports.

Related tips

Quickly format and enable filtering of your data

See the data behind a specific figure in a PivotTable report

Filter data in a PivotTable and PivotChart using Slicers

Exclude data from your PivotTable report using Slicers

Two new webinars

Following the success of our four 60-minute webinars, I have developed two additional “further use” sessions, helping you to broaden your knowledge of Excel and Word and to benefit from its overlooked and underused features:

·         60-minute Further Use webinar - Excel with Excel : Thursday 22 October, 10 - 11AM

·         60-minute Further Use webinar - Word to the wise  : Tuesday 27 October, 10 - 11AM

You can book your place online at the introductory price of  £24 per webinar per person. If you are looking for a webinar for a group of people, please get in touch.

And remember, as we respect the fact that people make special arrangements in their personal and professional lives for attending a session, we never cancel classes due to insufficient enrolments. Once payment is received, the webinar is guaranteed to run.

5 October 2020

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk


Looking for something specific?