Search Contextures Sites
Custom Search

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

TExt Tricks + more Excel tips

June 2, 2015

See how to fix a broken drop down list, create an interactive chart, do fancy text tricks, and many more tips, in this week's Excel news.

 -  Debra -  ddalgleish@contextures.com

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:
http://www.contextures.com/newsletter/excelnews2015/20150602ctx.html

1. Contextures Posts

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

  • 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. 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.

You can see more text function examples in my 30 Excel Functions in 30 Days kit.

Level - Basic

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

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 weakther 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: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

 

__

 

Privacy Policy

 

Contextures Inc., Copyright 2015
All rights reserved.