Excel Roundup 20170504

There’s always something new and interesting to learn in Excel. Here are some of the articles that I’ve read recently, and links to new and updated Excel resources.

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

Power BI

  • Learn about the pitfalls of Power Query, in this series of articles from Gil Raviv. He previously led the Power Query team at Microsoft, so he’s certainly well-qualified!
  • If you want to learn more about Power BI, Ken Puls is writing a series of free Do It Yourself (DIY) BI ebooks. The first one has Excel tips for Power BI, and other books are coming soon.
  • For more information, I’ve put together a Power BI Resources page on my website. There are links to helpful sites, and a couple of video playlists, to get you started. You can also download the resource list (in PDF format)

Pivot Tables and Excel Tables

  • On his Let’s Excel blog, Don Tomoff shows how easy it is to format a pivot table with one click. He included one of my videos, so he must be very smart! 😉
  • Chandoo shows a problem with Excel Table formulas that refer to a cell in the row below. Have you run into that problem before? To fix it, I refer to the row above instead. (Level – Intermediate)

Excel Charts

  • The Science Goddess explains how to build a backwards bar chart, with an example of where she would use one, and why.
  • Ann K. Emery shows the steps for planning and building an Excel chart, from the sketching phase, to the completed chart. What works, and what doesn’t? There’s a video that shows the process too.
  • On his Clearly and Simply blog, Robert Mundigl shows an amazing interactive Excel dashboard. Usually you have to click on something to run a macro, but Robert makes things happen on the selected chart, when you simply hover over a data point with the mouse.

    clearlysimplyhover01

Excel Tips

  • On his Engineering Excel blog, Charlie Young shows two quick ways to troubleshoot broken Excel formulas. He uses an engineering example, but the tips are useful for any formulas.

Excel Skills

Excel Resources and Tools

  • Andrew Engwirda has updated his Excel VBA tools, to add a few more features. It’s an amazing collection of tools, at a surprisingly low price.
  • Alberto Ferrari and Marco Russo just published their new book – Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Who is the book for? “If you are curious about what data modeling is and why it is a useful skill, then this is the book for you.”  

Excel Humour

  • After all that heavy reading, take a break and read the weekly collection of Excel tweets, to see what people are saying about our favourite spreadsheet. For example, “I try to break Microsoft Excel at least once a day or I feel like I wasn’t working hard enough”

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

_________________________