Excel Roundup 20140303

Have you used Power Pivot yet? If you’d like a quick intro, and a few tips, watch this 15 minute video from Microsoft. Owen Duncan, Senior Content Developer for Power Pivot, takes you through some basics in this video, and talks about best practices.

If you’d like to learn more, their blog article has links to other Power Pivot articles on the Microsoft site.

Or watch on YouTube: Understanding Power Pivot for Excel

Contextures Posts

Here’s what I posted last week:

  • Instead of using the default icon sets in Excel, you can create colored Harvey Balls, or other icons, with conditional formatting and custom number formats.
  • Did you know that you can accidentally create calculated items in a pivot table? Learn how it happens, and how to remove them.
  • 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:

  • If you like trains, as much as you like Excel, the National Railway Museum (UK) is looking for volunteers to enter historical data into spreadsheets.
  • Scott Lyerly lists his favourite books and websites for getting started with Excel programming. What would you add to the list? And if Dick Kusleika is “Sam Malone”, who are the other characters at the Daily Dose of Excel?
  • Have you ever built a convoluted workbook, with formulas that make even your head hurt? John Rougeux shares his 3 Excel pro tips for helping others not hate you. 
  • Jeff Weir explains Robert Mensa’s technique for creating robust dynamic drop downs, without VBA. Just remember, the best we can do is build things that are idiot resistant, not idiot proof.

Excel Resources

Here are some upcoming events, courses and new books, related to Excel.

  • Registration is open 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. All the sessions are in English, and the limit is 100 participants, so sign up now, if you’re interested.

imageExcel 2013 for Scientists by Dr. Gerard Verschuuren

This 250 page book is published by Holy Macro! Books, and here’s the intro from Amazon:
”With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more.”

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.

__________________________________

Don't build spreadsheets that people hate. blog.contextures.com/

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.