Microsoft Excel training Warwickshire

The Microsoft Excel training Warwickshire blog is all about the services we provide in the Warwickshire area.

Over the last 20 years we have delivered courses in Stratford Upon Avon, Warwick, Leamington Spa and other parts of the county.

Clients that we have carried out training for include:

  • Jutton Associates (Energy Consultants)
  • Blythe Liggins Solicitors
  • AHDB
  • Antolin Interiors
  • Contechs Consultancy

Excel training is just as popular today as it was 20 years ago, maybe even more so!

We have developed 5 courses in Excel and these can be seen below. You can click on each one to see a sample of an agenda for each course we run:

Microsoft Excel training Warwickshire provides companies with a full understanding of the business essential features to increase productivity in the workplace.

We focus on Data Analysis in this topic with some hints and tips for good practice.These hints and tips can be seen below:

Sorting – always keep the lists of data sequential, only 1 row of headings, no blank rows or columns, no merge cells in the headings

Filtering – Use the drop down arrow where possible. Choose from tick options when repeated text fields and use number filters for numeric values.  If the question contains an AND together with OR  you’ll need to use Advanced Filtering

Data Sub totals in Excel – always sort the list first then Data Sub total. Examples include counting and summing records.

Pivot Tables – always keep the same format as you would when sorting.  Insert a pivot table to a new sheet. Use Options to choose classic pivot table layout.

An example of our bespoke training was for Antolin Interiors where we developed a full half day course just on Pivot Tables for them. You can see the agenda that we prepared for the course here.

If you are interested in any Excel training with us, you can take a look at our website Microsoft Excel Training page or alternatively you can email us on johnlegge@jplcomputer.co.uk.

If you liked this hint and tip, then you might find our last one on Excel Consultancy interesting.

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