Data Analysis in Excel and 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
- 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:
- Formulas for Excel
- Basic Excel
- Intermediate Excel
- Advanced Excel
- Master Class Excel Bronze
- Master Class Excel Silver
Microsoft Excel training Warwickshire provides companies with a full understanding of the business essential features to increase productivity in the workplace.
Data Analysis in Excel
We focus on Data Analysis in Excel 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 liked this hint and tip, then you might find our last one on Excel Consultancy interesting.