Friday Support: Excel and using pivot tables

If you’re anything like me, Excel is one of the Microsoft Office applications that you use frequently but don’t feel that that you use to its full potential. Yes it’s great for lists and storing data and capturing information and you can make it look pretty but you know it’s capable of so much more.

One of the power user tools in Excel is pivot tables and frankly and I know that a lot of people shy away from trying to use them as they are considered to be too complicated and something that only Business Analysts are capable of creating.  Unfortunately in a Small Business, you’re probably not in the position where you can outsource this activity to someone else and so it really is something that you need to get to grips with.

However, pivot tables really needn’t strike fear in to your heart.  They are an extremely powerful and useful tool which enable you to slice and dice your data in any way you like with the capability of filtering and creating as many views of your data as is required.  This really does enable you to understand your data set in a way that is not possible when you are just looking at rows and rows of data and the good news is that the latest versions of Excel make it much easier for us ‘basic’ users to create them 

Our MS Worksmart guru Rob Atkinson has created a video that talks you through how pivot tables work, how to set one up and how to get the best out of them so that your data tells you what you really want to know, provides
business insight and adds value to your small business.  Can’t ask for much more than that. Make time for this today!


We, at Microsoft, are happy to announce ‘Talking Business’ to help entrepreneurs and business owners’ succeed. We believe in your ability to innovate and in the ability of technology to help, so to support ‘Talking Business’ we have many resources available for businesses like you. We have an informative newsletter, blog posts by people in the industry, and a community looking to help small business succeed.

Follow us on twitter - @MicrosoftSB, or use the hashtag   #TalkingBusiness to find out more information.