98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Preparing to Pivot: Why all Excel users should know about Pivot Tables
Sat 30th May 2009
What many people don't realise is that the Pivot Tables feature is one of the most powerful and flexible tools that Excel has. Once you've got the hang of it, you'll wonder why you didn't use it sooner. Get yourself trained up on them and you can use their many benefits. So - what are the benefits?
Perhaps it's easier to begin with the obvious - what is a Pivot Table anyway? Put simply, it's a way of summarising a large amount of data. Sometimes we all have to work with lots of data - whether it's sales records for your company, a census, a mailing list, or just keeping track of your own income and expenditure as part of a budget, for example. Naturally, you're going to put all the data in a worksheet, in the usual summary of rows and columns. What does it mean if you "Pivot" it? Well, you're literally, turning it around, looking at it from a different angle. You can make Excel compute it in different ways, by dragging, dropping and comparing different rows or columns.
Pivot tables are a flexible way of using your data. Let's say, for example, that you're an Ebay seller. Your data will probably be summaries of postage costs, customer information, where the items have been sent, and how many of them you're selling. These will be in the usual columns, under customer name, phone number, address, quantity sold, and so on. What are you doing with that data? Not much. It's a useful record - you can see the total that someone's bought, how many items you sold in a year, and perhaps look at how many times someone has bought from you. This data could be so much more useful to you, if you Pivot it.
A Pivot Table doesn't need you to copy cells, input any more data, or even create a formula - and they're meant to be complicated! With the drag of a mouse, you can analyze your data and make it work for you. Let's go back to the Ebay example. Now your data has been pivoted, you can get summaries of information that wasn't available in your rows and columns - meaning, the relationships between the data.
For example, by pivoting the quantity sold alongside the customer's address, you can tell how much you're selling regionally, and this will help you target your customers better. Or, you could look at a relationship between the cost of your items and the quantity sold - now you can tell if you've perhaps pitched your costs too high or low, and adjust your profit margin accordingly.
Pivot Tables can give you a vast amount of flexible, useful knowledge that is impossible with a static set of information - the usual way people use Excel. By looking for trends, you can use your data better. That's all that Pivot tables are about. You can see it makes perfect sense to include them in your arsenal of Excel tools - you'll realise that life was harder without being able to pivot it around, so get trained up on them, and get your data moving!
Author is a freelance copywriter. For more information on excel microsoft training, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-440-preparing-pivot-why-all-excel-users-should-know-about-pivot-tables.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsFaculty Of Occupational Medicine
Professional Development Manager Alannah Harrison Delegate to Succeed The training was good, it expanded on parts of the process I was already doing, albeit without the structure or consciously thinking of 'why' I was doing it that way - which will help me improve in future. Most helpfully, it also taught me more of the process to start doing. Training via video meeting would not be my first choice for delivery - I appreciate there isn't another option at present due to the pandemic. Thankfully, there were no IT issues to distract attention from the content. Dennis is a knowledgeable trainer, patient and has a very approachable attitude. Some other varied practical examples/scenarios to put the training into context would have helpful. NNPC
ACCOUNTANT RIMAMKYATEN DIO Time Management using Microsoft Outlook GREAT WORK TBS G.B
Biomedical Team Leader Leigh Ireson Excel Advanced The course was very useful and informative. Very pleased. |
PUBLICATION GUIDELINES