7 Ways to Count + more Excel tips
Excel Weekly News from Contextures March 31, 2015
There are many ways to count things in Excel, and we'll take a look at 7 of them, and many more tips, in this week's Excel news. I've changed the newsletter format, and I hope you find it easier to read!
- Debra - ddalgleish@contextures.com
In case you missed them, here are the articles that I posted recently:
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.
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?
Which Excel forums do you use, when you have an Excel question? Jeff Weir looks at some favourites, and the comments have great suggestions too. I still miss the old Microsoft newsgroups.
Chris Webb shows how to use CONCATENATX – one of the new DAX functions that you can use with Power Pivot in Excel 2016. For example, if you sold apples to 3 customers, it will show all 3 names, separated by commas – Fred, Chris, Joe.
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.
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.
After listening to the podcast about using Excel for project management, I remembered my video that shows how to create a Gantt chart in Excel. It's a quick and easy way to see the tasks for a small project.
The Amsterdam Excel Summit will start in a couple of weeks (April 13-15), and organizer, Jan Karel Pieterse let me know that they are offering a last minute discount. You'll get a 200 Euro discount if you register now.
Last week, my granddaughter turned 5, and had a birthday party, with a fancy cake, that looks too pretty to eat! On top of the cake is Elsa, from her favourite movie, Frozen. Did you have fancy cakes at your birthday parties, or just a few candles on top, like I had?
_____________
See more recommended Excel products.
________________________
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
__
Contextures Inc., Copyright ©2018
All rights reserved.
