Excel Analysis on Lists of Data – how many of these types do you use?

Excel Analysis on Lists of Data

Excel analysis: Excel icon

On every Excel training course we run there is some kind of work we do on Excel lists of data. It may be:

  • Sorting
  • Conditional formatting using formulas or criteria
  • Filtering
  • Sub Totalling
  • Pivot Tabling
  • Removing duplicate errors


Data can be easily stored and manipulated in Excel but there are key setup features you ought to be aware of:

  • Keep your heading on row 1 and all the details on consecutive rows thereafter
  • No blank rows or columns
  • No merged cells


Using these key setup features can make things a lot easier for you within Excel on general day to day use as well as making it easier for you in the future if you need to carry out more advanced analysis on the data. With the data displayed in this certain way, it gives you a good starting point for the more advanced types of data analysis that are available for you to use within Excel.


Hints and Tips

On average we produce 1-2 hints and tips posts a month. These cover a variety of the Microsoft Office packages and level of difficulty in each of the individual packages. These are produced to cover one, two or more features that are available for use in the packages with some of them being more obvious and used on a regular basis but some are more obscure and are less known! So even though this hint and tip might just cover Excel analysis, there are lots of other hints and tips on Excel and other modules which can be found here.

If you liked this hint and tip and want to know more, have you thought about one of our courses? If you would like more information on any of our courses, please email us on johnlegge@jplcomputer.co.uk

Why not take a look at our previous one on some helpful Excel shortcuts?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy