Excel Roundup 20160307

In this week's roundup, Power Map, Excel formula errors, cell references, and more.

Excel Roundup http://blog.contextures.com/

1. Excel Formula Problems

Is your VLOOKUP formula returning the wrong results? One simple thing can cause errors that you might not notice. The same problem can affect INDEX/MATCH formulas too.

2. Free Business Analytics Webinars

If you missed the recent PASS Business Analytics webinars, there's good news. The recordings are online now, so you can watch when you have some free time.

3. Excel Basics

Ian Green's article is for auditors, but the difference between absolute and relative references is important for all Excel users to understand.

Another thing that can confuse Excel beginners is a workbook with the "handcuffs" on. On the Journal of Accountancy blog, J. Carlton Collins shows how to "unlock" a workbook like that. I'm surprised that the sheets weren't protected too.

4. Power BI

In another one of his cool and useful tricks, Ken Puls shows how to create bands in Power Query. For example, group overdue accounts by 0-30 days, 31-60 days, etc.

And who knew you could use Power Map to pick concert tickets? Gašper Kamenšek shows the steps, using Mick Jagger as an example.

5. Excel for Scientists

This short profile of Andrew Willoughby shows that Excel is an important tool for plant scientists too.

And I think it would take a scientist or engineer to understand Nathan Brink's article on using Excel formulas for bilinear interpolation. It looks fascinating, but it certainly went way over my head!

6. Excel Humour

Finally, for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets. Here's one of my favourite tweets from this week's collection.


Get Weekly Excel News By Email

To get Excel news and tips by email, add your name for the Contextures Excel newsletter.



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.