Excel Roundup 20140217
On the Power BI blog, Microsoft Finance Director, Marc Reguera, explains how his department is using the new Power BI tools in Excel. Will you be using them too?
You can read more at the Power BI blog, or watch the video below.
The video is also on YouTube: Interview with Marc Reguera
Here’s what I posted last week:
- The heading text was filling in when I typed an "A" code in a column. See how I fixed the AutoComplete problem, and what caused it.
- Find the source data for an #Excel pivot table, to check that all rows are included.
- Select multiple items for a cell, by clicking the check boxes in a popup form. It opens when you select a cell with a drop down list.
- Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read last week, that you might find useful:
- Mitali Pattnaik wonders what kind of software could take Excel’s place. You can add your opinion in the comments on her Disrupting Excel article.
- Jon Peltier shows how to create and update a chart, using only part of a pivot table’s data.
- Tim Wolverson share his instructions for plotting a Fibonacci spiral in Excel, and there’s a sample file to download.
- Recently, I shared a formula for finding the last item in a category, in a sorted list. Oscar created a formula that works with an unsorted list.
- If you’re not sure what linear regression is, or how it works, read Mike Alexander’s excellent, and easy to understand, explanation.
- Microsoft’s Power BI pricing was announced, and the New York Times worries about feature creep in the tools.
- You can select numbers on a worksheet, and see a Sum, Count, or other summaries in the Status bar. There’s no Subtraction option, so Dick Kusleika created one of his own.
Here are some upcoming events, courses and new books, related to Excel.
- If you’re near Tennessee, Rob Collie, from PowerPivot Pro, will be speaking at the first meeting of the Nashville Modern Excel User Group, on Thursday, Feb. 20th. The registration information is here, and there’s free admission to the meeting.
- Bill Jelen is presenting at the Orlando Florida Power Excel seminar, Saturday Feb 22 2014
- Chandoo has re-opened his Power Pivot online course, and you can get the course info and registration details here: Power Pivot Course
- Registration open today for the Amsterdam Excel Summit. The one-day event runs on May 14, 2014, and features sessions by several Excel MVPs, such as Bill Jelen (Mr. Excel), Ken Puls and Charles Williams.
Marketing Analytics: Data-Driven Techniques with Microsoft Excel by Wayne L. Winston
“This practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques—and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn.”
What Did You Read?
If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.
Please include a brief description, and a link to the article.