Excel Roundup 20150323

Have you used PowerMap in Excel? Microsoft's Excel team used it to illustrate the White House budget in 3D. You can read the details, and download the Excel file from their blog.

Or watch on YouTube: The White House Budget

Contextures Posts

Here’s what I posted recently:

  • Find and fix pivot table source data so new data shows up automatically. These tips help if you've inherited a workbook from someone else, or if there are problems updating the pivot table after adding new records.
  • 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 related articles that I read recently, that you might find useful.

  • Sumit Bansal shows how to calculate shared expenses, which will help if you're sharing an apartment, or going on a March Break road trip with friends. You can download his template, and enter your own information.
  • Jon Peltier explains how you can remove some or all of the Recent Colors from an Excel file. You don't need to use a macro, but you'll have to roll up your sleeves, and dig into the file's styles.xml document.
  • The FrankensTeam members, who work together on an amazing Excel blog, finally got together, after 3 years of long distance work. They also show how to build an Alps mountain chart, and yes, there is a picture of the drunken donkey.

Excel Announcements

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

Excel Courses

  • Canada: Ken Puls, from ExcelGuru.ca, is running his Master Your Excel Data course in Victoria, BC (May 11th) and Kamloops, BC (May 15th). You'll need to have the Power Query add-in downloaded and installed on your computer.
  • Amsterdam Excel Summit, April 13-15, 2015. Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and this year should be even better! You can click here to register.

Share Your Events and Articles

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

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


Links to Recent Excel Books on Amazon.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.