Excel Roundup 20140224

If your laptop screen is too small, maybe you’re ready for an 82” touch screen, or start a bit smaller (and maybe cheaper) with a 55” version.

You can see Power Map in Excel on this giant screen, at the 7:15 mark, in the video below. My favourite moment is at 9:10, when the presenter says, “This is not the Excel spreadsheet I grew up with, that’s for sure.”

True! Excel was black and white only, with one sheet, when I started using it.

Or watch on YouTube: How Office Works on an 82” screen

Contextures Posts

Here’s what I posted last week:

  • Shape Styles are flat in #Excel 2013, but you can change a setting to see rounded options, like the ones in Excel 2010.
  • After deleting items from a pivot table's source data, they can still appear in the pivot field drop downs. See how to remove them.
  • If an Excel file is linked to another workbook, you can break the links. If the Break Link button is not available, this might be why.
  • 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:

  • Winston Snyder shares his code for turning the field captions on and off in a pivot table. Tip: If it’s just the headings, “Row Labels” and “Column Labels” that you don’t like, change from Compact Layout to Tabular Layout.
  • I use Feedly for my RSS feeds, to find and read Excel articles. If you’re using it too, remember to download your OPML file, to create a backup of all your feeds. You never know when a reader will suddenly disappear (Yes, I mean you, Google Reader.)

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.

excel2013programmingMicrosoft Excel 2013 Programming by Example with VBA, XML, and ASP by Julitta Korol

The Amazon listing doesn’t have a “Look Inside” feature, and there aren’t any reviews yet, so I’m not sure what topics are covered. The book blurb says, “a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects.”

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.


Excel on 82"  touch screen? I need this! blog.contextures.com

0 thoughts on “Excel Roundup 20140224”

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.