Tame your computer - go easy in Excel

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 analyse your data - the easy way (Excel for Microsoft 365).

Roem tip time logo

Good training doesn’t have to be long or torturous to be effective, which is why I’ve been running 60-minute sessions for years. This week I’ve taken it a step further and developed and delivered a five-day 15-minute series - bitesize portions, that fit into a busy schedule and are easy to digest.

I’m going on my gut instinct to share what I believe was well received … one of those underused and overlooked new buttons available for 365 subscribers (also on the Mac, I think): the Analyze Data button at the far end of the Home tab.

Excel will look at your data and display visuals such as PivotTables and Charts that can be inserted into your workbook. It’s simple, fast and intuitive and there are many examples, so I’d say … open one of your workbooks and go and explore.

[[{"fid":"294191","view_mode":"default","fields":{"format":"default","alignment":"","field_file_image_alt_text[und][0][value]":"Excel sample page","field_file_image_title_text[und][0][value]":"Excel sample page"},"link_text":false,"type":"media","field_deltas":{"1":{"format":"default","alignment":"","field_file_image_alt_text[und][0][value]":"Excel sample page","field_file_image_title_text[und][0][value]":"Excel sample page"}},"attributes":{"alt":"Excel sample page","title":"Excel sample page","style":"height: 347px; width: 700px;","class":"media-element file-default","data-delta":"1"}}]]

Here’s how:

1.       Click anywhere in your data. (No need to select it, unless you only want Excel to look at a specific part of your data.)

2.       Click on the Analyze Data button in the Analysis group at the far end of the Home tab.

3.       Scroll through the options, click on one of the pre-defined suggestions at the top or type your own question.

By the way, when you click in your data you might spot the Quick Analysis button pop up – another fab, underused feature which I’ll talk about in a separate tip.


Related tips

Create PivotTables - no know-how necessary

12 July 2021

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?