Contextures News 20150602

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.

1. Contextures Posts

In case you missed them, here are the articles that I posted recently:

2. Flexible Formula

To make an INDEX formula more flexible, John Michaloudis uses a drop down list to select the row number for the result. Level - Intermediate

3. Fun With Text

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.

4. Power BI

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

5. Free Book Download

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

6. Interactive Chart

Building on the work of charting experts, Jon Peltier and Andy Pope, Robert Mundigl shows how to create an interactive chart, using an ActiveX label control. Level - Advanced/VBA

7. Track Exam Results

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

8. Conditional Formatting Icons

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

9. Summer Fun

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. ;-)

weekly photo

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.

Debra Dalgleish

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.


Last updated: May 24, 2021 8:13 PM