Excel Roundup 20150330
This week, see how to highlight items in a dashboard, change the background colour in a chart, use Excel for project management, and many more tips.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
1. Contextures Posts
In case you missed them, here are the articles that I posted recently:
- There are many functions for counting in Excel. I covered 7 ways to count in Excel, with function tips and tricks.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
2. Dashboard highlighting
Robert Mundigl shows how to highlight a specific item in several places, in an Excel dashboard. For example, make the data for Germany stand out in a line chart, map and bar chart, by colouring it blue.
3. Your name in an Excel book
Enter Jeff Weir’s caption contest, to try to win a copy of his upcoming Excel book. Improve on his photo captions, and you might see your name and caption in his book.
4. Change chart background colour
Chandoo shows two ways to change the background color on a chart, depending on a cell value. One method used VBA and the other uses conditional formatting.
5. New DAX formulas
Chris Webb shows how to use CONCATENATEX – one of the new DAX functions that you can use with Power Pivot in Excel 2016. If you sold apples to three customers, it will show all the names, separated by commas – Fred, Chris, Joe.
In a related post, Erik Svensen shows how to list the selected items in a Slicer, by using the CONCATENATEX function.
Great news! A last minute discount was just announced for the Amsterdam Excel Summit (April 13-15, 2015) — you can save € 200, if you register now. Last year’s summit was an outstanding success, and this year’s should be even better!
7. Transform web data with Power Query
Meagan Longoria used Power Query to transform web data, from 2 rows per record, to a single row. After working with all that brewery data, I hope she enjoyed a good craft beer!
8. Project management
In the Project Management Podcast, Doug Hong shares his tips for using Excel for project management tasks. Do you ever get formula fatigue, as Doug mentions?
9. Best Excel forums
Which Excel forums do you use, when you need help? Jeff Weir looks at some favourites, and the comments have great suggestions too. I still miss the old Microsoft newsgroups.
10. Mapping Manhattan
Last week, the Excel team explored the White House budget with Power Map. This week, you can see the buildings in Manhattan, as it grows over time. Which buildings have the most residential space? The most office or retail space? And if you need to park your car, where is the garage space?
Or watch on YouTube: Exploring Manhattan with Excel Power Map