Excel Roundup 20140714

Are you using Power Pivot or any of the other Power BI tools in Excel 2013? If you’re not sure where to start, there is a new series on the Power BI blog, that will help you dive into the new BI and visualization features.

The series outline is here, and it will have links to all the articles, as they are added to the blog. The first article is Getting Started with Power Query – Part 1, and it features the 15-minute video shown below. You’ll need Excel 2013, and the article has a link to download the Power Query add-in.

Contextures Posts

Here’s what I posted recently:

  • Enter a number in the input box, and that amount is added to each cell in the selected range, with this macro. I use this to add a week, to a  group  of date cells.
  • I sent out an update for my PivotPower Premium add-in last week. If you missed the email, or didn’t open it before the deadline, please let me know and I’ll send you a new link. You can read about the new features on my Pivot Table blog.
  • Finally, 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:

  • On Microsoft’s MSDN Blog, Eric Ligman shared a list of free ebooks, including Excel shortcuts and quick start guide.

Excel Announcements

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

  • Mynda Treacy’s Excel Dashboard course is open for registration, and I highly recommend this online course, which has excellent content, and great student support from Mynda. Save 20% if you sign up by July 24th. Registration closes on July 31st.
    BONUS: If you sign up for the course through this link, you can have a copy of any one of my Contextures Products. When you sign up, type DebraD in the Referral Code box (below the Buy Now button), and email me your receipt number.
  • Excel Dasboard Course
  • Charles Williams has released a new version his add-in, FastExcel V3, and you’ll get 50% off the bundle price, if you use Coupon Code FXLV3Intro Warning: The 50% Discount ends soon -- July 31 2014. Don’t miss the deadline!
498411exceltables Excel Tables: A Complete Guide (pdf version)by Zack Barresse and Kevin Jones”The book begins by explaining what tables are, how to create them, and how they can be used in reporting before moving on to slightly more advanced topics, including slicers and filtering, working with VBA macros, and using tables in the Excel web app. Novice Excel users and experts alike will find relevant, useful, and authoritative information in this one-of-a-kind resource. “

Share Your Events and Articles

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!


Learn Excel Dashboard Course

Links to Recent Excel Books on Amazon.com


You may also like...

7 Responses

  1. ChipG says:

    > Do you agree with these 10 common spreadsheet mistakes? I’m not even sure what some of them mean!

    I think there are a lot more common mistakes than those. And the first sentence calls spreadsheets a “stable in the business world” instead of a “staple” so he lost me there.

  2. Doug Glancy says:

    I’m with ChipG. That first sentence is an accurate indicator of the overall quality. Interestingly, it switches midstream from listing mistakes to listing best practices. Those are admittedly two sides of the same coin, but it adds to the disjointed feel (along with the strange picture choices).

    Ah well, I wish him the best in his future literary endeavors.

  3. Hi Deb,
    Thanks for the link to the “Excel Tables: A Complete Guide”.
    I now use a lot of tables especially in templates for an easy expanding data validation list (data validation > named range > column in table).
    Writing formulas that reference tables is sometimes a bit tricky so I’m looking forward to reading their PDF.

  4. Juno says:

    Do you know any book that is for free to use? a soft copy will do

Leave a Reply to Kevin Lehrbass Cancel reply

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