Excel Roundup 20140120
If you’ve ever been disgruntled with your bank, you might enjoy Ben Orlin’s vision of how he would run a bank, on his Math With Bad Drawings blog. Instead of annual compounding, he’ll offer other options, such as:
- Compounded Madoff-ly: After years of dubiously high interest, it will come out that I’m just typing random numbers into the spreadsheet.
- Compounded sporadically: Your balance grows whenever I remember to update the spreadsheet.
Each option is illustrated with a bad drawing, like this one.
Here’s what I posted last week:
- Use a macro to link worksheet check boxes to specific cells, so you can track the responses.
- Then, assign a macro to each check box, so it enters the current date when checked.
- Change a pivot table layout to see which customers have not purchased your products.
- Finally, for a humorous peek at what other people are saying about Excel, read this week’s collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read last week, that you might find useful:
- On the Digital Forensics Stream blog, Jason Hale shows how to find the last saved location of an Excel 2013 file.
- At the Daily Dose of Excel blog, Jeff Weir makes a case for investing in corporate Excel training, and you can add your opinion in the comments.
- Alex Roe, in the Italy Chronicles blog, wonders if Excel can save Italy, as one of their political leaders suggested.
- If you’re looking for an art project to keep you busy this winter, see what they created at Maison H & H – a wall hanging based on an Excel worksheet.
- Instead of creating a long concatenation formula, Chandoo shares a quick trick for combining the values in multiple cells.
- Dennis Wallentin recommends that every serious Excel developer should read the VBA Enumeration Database article that’s in the CodeProject newsletter.
- Winston Snyder couldn’t find a pivot table style that he liked, so he wrote a macro to format specific ranges in the table.
No matter how long you’ve been using Excel, there’s always something new to learn.
- Sign up for one or more of the free Business Analytics webinars offered in the 24 Hour PASS series, sponsored by Microsoft, Cisco and Dell. Topics inlclude: "Advanced Analytics in Excel 2013", "Querying in DAX", and"Predictive Analytics for Absolute Beginners". The online sessions run on Feb 5th and 6th, and you can see the schedule here: 24 Hour PASS Schedule
- Mynda Treacy’s Excel Dashboard course is open for registraion, and I highly recommend this online course, which has excellent content, and great student support from Mynda. Click the banner below, for more information. If you sign up for the course through that link, you can have my Excel Tools add-in as a bonus. Save 20% if you sign up by Jan 23rd.
Just enter the Referral Code – DebraD104 – in the box just below the Buy Now button, then email me at firstname.lastname@example.org
What Did You Read?
If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.
Please include a brief description, and a link to the article.