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
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.
- Devin Camenares uses Excel to find which chess piece movements or placements are featured more often in wins versus losses. These are potential difference makers in a chess game.
- 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.
- Chris Webb summarizes the latest news and updates for Power BI and Excel 2016 BI. This is a great way to catch up, if you’ve missed any of the announcements.
- 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.
- Microsoft has announced the release of its Office 2016 IT Pro and Developer Preview for the Windows desktop, for commercial Office 365 customers.
- If you use your Excel data as a source for Tableau files, Ken Black (3danim8) has a tip for dealing with a slow workbook.
- Chandoo shares his favourite keyboard shortcuts for Excel formatting. Do you use any of these?
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
- Enter Jeff Weir’s caption contest, to try to win a copy of his upcoming Excel book. Improve on his photo captions, and you might see your name and caption in his book.
- 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!
Links to Recent Excel Books on Amazon.com