everydayExcel Newsletter Header

Did you find Pivot Table difficult to use?

Have you seen people showing off their pivot table and you are wow by what they can do? And yet when you try to do it yourself, you find that you just cannot get it? If you find yourself in the same situation as described, I have good news for you. It is not your fault that you can’t create the PivotTable. The problem is with the data you own. Take for example this set of data you own.

data that cannot be pivoted

Can I do PivotTable with it? You can’t beause the data is arranged in the wrong way. Instead, it should be arranged in this way.

data that can be pivoted

So if your data is arranged in the wrong way, what should you do? Either you re-enter your data from fresh (which is something you won’t want to do) or use Excel 2016. It has a function called “Data and Transform” which is able to change the layout of your data in minutes. In the whole process, you can perform trial and error without having to worry that your raw data is corrupted. You can even go back to as many steps as you want if you find that you have some of the steps wrongly. If you want to know how this is done, sign up for the course now.

Ask us an Excel question and get your question answered by our team of Excel experts

Click on this link to post your question.

Upcoming Courses

Skills Futures CreditFor Individuals - If you are a Singaporean aged 25 and above, you are given $500 in your newly created Skills Future Credit Account. The credit in the account is meant for you to pay for WDA approved courses for the purpose of upgrading yourself without company sponsors. You can pay for our courses using your Skills Future Credit.

High Impact Data Analytics Reporting in Excel 2016 - 30 & 31 Jul 2018 (confirmed)

Hidden Secrets in Data Analysis with Excel  - 19 & 20 Jul 2018 (Limited Seats)

Business Analytics Reporting with PowerPoint 2010 - 1 & 2 Oct 2018 (confirmed)

The Hidden Key to Excel Reporting and Charting - 25 & 26 Oct 2018 (confirmed)

Unleash the Power of Excel PowerPivot for Data Insights - 3 & 4 Sep 2018 (confirmed)

For the details of the courses, please refer to our Excel courses page.

Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.

Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.

Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"


Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.