Excel Roundup 20150126

Combine data, sort a list with formulas, see Power Queryimprovements, and more, in this week’s Excel Roundup.

Contextures Posts

Here’s what I posted recently:

• Use Microsoft’s Power Query add-in to combine data from 2 worksheets

• Create a pivot table from data on different sheets

• For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

Other Excel Articles

Here are a few of the Excel articles that I read recently, that you might find useful.

• Mary Ann Richardson shows how to use the WORKDAY function to calculate a delivery date..

• Oz du Soleil is tired of people comparing R and Excel, and bashing our favourite spreadsheet.

• XOR LX shows how to sort a list alphabetically, by using formulas.

• Jordan Goldmeier thinks we make our Excel workbooks more complex than they need to be.

• Power Query was updated in January, and Microsoft’s Excel team outlines the improvements that were made..

• Nitin Mehta created a User Defined Formula to do a lookup to the right or left. You can download the add-in, and look at the code.

• Ken Puls explains an easy way to reference other Power Query queries, when working on a new query.

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel.

Dashboard Course

• Mynda Treacy is running another session of her acclaimed Excel Dashboard Course, and registration closes January 29th. I reviewed this excellent dashboard course when it first opened, and recently updated my review, after taking a look at the latest version. You can read my detailed review here. The course is an even better investment now, with many new videos added.

PASS BA Marathon

• Feb. 3, 2015 — Sign up now, for this free online preview of the upcoming Business Analytics Conference. There will be 6 live webinars, including “Productivity Revolution in Excel”, led by Chandoo (Purna Duggirala) and Avi Singh.

Excel Summit

• Amsterdam Excel Summit, April 13-15, 2015. Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year’s summit was an outstanding success, and registration will open soon, for this year’s event. Registration is now open, and you can click here to register.

Share Your Events and Articles

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

_________________________________