Excel Analysis on Lists of Data

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 on www.jplcomputer.co.uk/hints-and-tips/

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

 

Cookie Control

Cookie control

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

I'm fine with this

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

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

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