Show % in Excel Reports
Sept 26, 2017
Show percentages in a report, Excel shortcuts, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos.
Note: For some products mentioned below, I earn a commission on sales. That supports the free info on my site!
Learn how to build interactive dashboards with Power BI and Excel. In a free one-hour webinar, Mynda Treacy shows how to go from raw data in Excel, to a sophisticated set of dashboards, in a few simple steps, using free tools. You don't need advanced Excel skills or macros.
The webinar covers lots of material, very quickly, but don't try to take notes. After the webinar, download the full video and practice files, to review the lesson at your own pace. I did that -- there were a few steps that I wanted to see again.
Don't get left behind with these new Excel skills! Mynda's webinar is a great way to see amazing things you can do in modern Excel. Click this link to register today -- the webinars are available for a limited time.
When you create reports in Excel, are the numbers really big, and hard to compare? If you use a pivot table to summarize lots of data, it creates the report quickly, but those large numbers make it hard to do mental arithmetic. (Well for me anyway!)
Take advantage of an underused feature in pivot tables -- use the Show Values As settings to change those big numbers to percentages. I like to leave the big numbers there, then add another column or two with percentages. Show the % of Column, to see how each amount contributes to the overall total. Or use the % of Parent, to compare amounts within a subtotal.
I did a video to show how to set this up, and you can see it on my blog. You'll see Karine Lago there too -- she's an Excel MVP from Brazil.
If you have a range of cells selected, press Ctrl and the period key to go to the next corner cell in the selected range. It changes the active cell, but leaves the whole range selected. Thanks to Patrick M for sharing this tip!
See a list of Excel shortcuts on my website, and download a copy of the list.
Here are a couple of recent Excel articles that you might find useful or interesting.
Excel History - Fast Company has an interesting article on Microsoft CEO, Satya Nadella. Near the end, there's a link to a 1993 video in which he shows how to pull data using Excel and MS Query (starts at 1:51:54). That brings back memories! (Level - All)
Excel Charts - On his PolicyViz blog, Jonathan Schwabish shows how to build a "Tile Grid Waffle Chart Map" in Excel. You have to see the screen shots -- I'm not sure how to describe them!. There's a video to, that shows the steps. (Level - Int/Adv)
Summer ended here last week, and now that it's autumn, we finally have summer weather! It was mid-20s for much of the summer, but we're in a heat wave now, and in the high-20s and beyond.
The poor roses in our garden are so confused that they're blooming again. Oh well, it will be cooler soon, and everything will be back to normal.
That's it for this week! If you have any comments or questions, send me an email.
NOTE: If you have trouble with the images or links in this email, paste this URL into your web browser, to see the online version: http://www.contextures.com/newsletter/excelnews2017/20170926ctx.html
ddalgleish @ contextures.com
Last updated: September 22, 2017 2:25 PM