Quick Excel Report Change
September 6, 2016
A quick report layout change, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there..
If you have 2 or more fields in the Values area of the pivot table, Excel automatically creates a new field in the layout, called "Values". You can see that field on the worksheet, and in the PivotTable Field List. Read more about that Values field on my website.
By default, Excel puts that "Values" field in the Columns area, above the other column fields. In the screen shot below, there is a Region field, and the pivot table shows the Quantity for each region, and then the Sales total for each region.
To quickly see a different view of the data:
And if you don't like the revised pivot table, just Undo, or drag the Values field back where it started.
If you're working with pivot tables, I've got a free tool that you can use --Pivot Power Free (PP Free). Use it to quickly change Sum to Count, format numbers, and a few other handy things.
Note: If you have a copy of my Pivot Power Premium (PPP) tool, you won't need this free version
Have you ever had an Excel crash, then discovered that your work wasn't saved, even though you clicked the Save button a few minutes ago?
That has happened to me a few times, and it's usually because I do this -- see if you can spot the problem:
Did you figure out the problem? Unlike some programs, you have to click on Excel once to "wake it up". Then, you have to click on the Save button, to actually save the file.
So, don't make the same mistake -- be sure that Excel is active when you click the Save button, or you might be sorry later!
Here are a couple of Excel articles I read recently, that you might find useful.
Don't Blame Excel - In response to several articles that warn us to stop using spreadsheets for serious work, Professor Felienne Hermans said that people should stop blaming spreadsheets for their problems. (Level - All)
Awesome Charts - A couple of months ago, Chandoo posted a data visualization challenge for financial data. The results are in now, so take a look at the amazing entries, to get inspiration for your own charts and dashboards. But remember to save your Excel file before you head over there! (Level - Basic/Intermediate)
Also, see all my Excel products on my Contextures website.
I'm used to dealing with bugs in Excel, but don't usually pay to much attention to the bugs in the garden. This strange insect caught my eye though, and it waited patiently while I snapped a couple of photos.
It looks a little scary in the original photo, and was much prettier after I touched it up in the Prisma app on my iPad. If you know what type of insect it is, please let me know! Maybe it's one to avoid, instead of getting close enough to take pictures.
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
Debra
ddalgleish @ contextures.com
P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 24, 2018 12:10 PM