99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Flout Formula For Excel PivotTables
Sat 4th February 2012
It may be tempting to leave worksheets in a simple format of columns and rows if you have a small spreadsheet, but once it starts to accumulate large amounts of data then PivotTables can help you spot trends and show off figures. If you're unsure how well Excel is being put to use within your company then a training needs analysis is useful for identifying issues of productivity and highlights where tutorials could prove useful.
Take the work out of worksheets
Let's say you're looking at a range of data about employees in your firm and their sales figures. You'd like to compare and contrast this information with the number and type of training courses that they have completed. Rather than applying individual formulas and coming up with entirely new spreadsheets, instead you could create a PivotTable, without the need to use any formula.
This element of Excel can prove very useful as it's a quick way to view the information you need. Icons allow you to quickly navigate to the necessary functions needed to do this within the programme. By using simple drag-and-drop technology you can take field data (from the original spreadsheet) and use it to build your PivotTable. This would then allow you to compare the type of training with the number of sales in seconds.
Refresh and rearrange
Another useful aspect to PivotTables is that they are entirely flexible. Once you have created one, it can also be changed in seconds to reflect other kinds of data, this is more difficult to do with spreadsheets. So, if you'd prefer to compare the amount of profit generated by one employee (rather than the number of units sold) with their training qualifications then this is possible, and could also highlight areas where a full training needs analysis may be useful.
As well as being able to rearrange PivotTables so easily, you're also free to refresh them when new data hits the original spreadsheet. This means that if you change the values and add that colleagues have completed extra training courses, this will be reflected in the PivotTable so it is kept up to date.
PivotChart your progress
Excel has several formatting options that give you the chance to highlight statistics when they are in a simple spreadsheet. You can use sparklines, for example, that give an easy-to-understand visual representation of how the information in a cell compares to that held in a different cell. There are similar options when it comes to PivotTables, so you can create graphs of the information. These are called PivotCharts and are great for revealing the statistics summarised by PivotTables.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Crown Prosecution Service
Development And Resource Officer
Effective Communication Skills
Sometimes people seemed slightly reluctant to give answers in group discussion - I don't know why that was but if people had been more willing to join in I think it could have been useful and made the course more fun. Maybe more introductory tasks could have broken the ice more?
Purchasing Systems Senior Analyst
After this course I feel confiden using MS project for creating, sequencing tasks and assigning resources and cost.
I quite liked the fact that there was a lot of practical excercise which allowed for things to be better understood.
Polaris UK Ltd
Senior Marketing Analyst
Power BI Modelling, Visualisation and Publishing
Update the Trainer's enthusiasm scores so we can select more than 6 for Jens :)
He is SO enthusiastic about the subject, you can tell he loves the subject and it's infectious - I can't wait to get back to work now to try the things I've learnt :)