Text Tricks + more Excel tips
June 02, 2015
See how to fix a broken drop down list, create an interactive chart, do fancy text tricks, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
In case you missed them, here are the articles that I posted recently:
To make an INDEX formula more flexible, John Michaloudis uses a drop down list to select the row number for the result. Level - Intermediate
On the CFO blog, Bill Jelen shares a couple of quick tips for working with blocks of text. I've never used that Justify command – have you?
For more fun with text, Tomer Dean shows how to replace part of a text string in a cell, by using the SUBSTITUTE function.
You can see more text function examples in my 30 Excel Functions in 30 Days kit. Level - Basic
Chris Webb explains how to work with international date and number formats in Power Query. For example, does 6/2/15 mean June 2nd, or Feb 6th?
If you're still confused about which version to get, Mike Alexander found details on all the Office 365 plans, and summarizes their features, to identify which ones have the Power BI tools. Level - Intermediate/Advanced
Note: Debra Dalgleish is an Amazon Associate. As an Amazon Associate I earn from qualifying purchases.
Doug H recently published Excel for the New Project Manager: A Primer on Microsoft Excel 2010 as an Amazon Kindle ebook. You can get a free copy this week -- from June 1st to June 5th (Pacific Time). If you download the book and like it, please leave a review on the Amazon site. Level - Basic
A professor uses Excel to track exam results, down to the individual questions, so he can improve the learning outcomes for his students. Level - Intermediate
In a short video, Mike Girvin (ExcelIsFun) show 3 ways to use conditional formatting icons with a set of student grades. (NOTE: The video is on YouTube, and will start to play automatically.) Level - Basic/Intermediate
My granddaughter came to visit on the weekend, and the weather was beautiful. She played in the sandbox, and we added some water, to make the sand "sticky" -- better for building towers. Then, she added more and more water, until we eventually had a box filled with sandy mud -- good for jumping in! Later, I had to hose her off before we could go back into the house. ;-)
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy the link below, and paste it into your browser:
That's it for this week! If you have any comments or questions, send me an email.
Last updated: March 11, 2021 2:39 PM