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
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:
- Are you an Excel Ninja? On the Lifehacker blog, Eric Ravenscraft shows you Four Skills That Will Turn You Into a Spreadsheet Ninja. The article links to my page on how to build a simple Order Form in Excel – so it must be good!
- 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.
- Office 365 is one year old now, and Ed Bott finds that it has improved steadily since it was introduced.
- Annie Cushing gives us 18 real life examples of when and why you’d want to combine text from multiple cells.
- Should they teach Excel programming in primary schools, instead of text based programming? Miles Berry explains why he likes the idea.
- If you do any programming in Excel, you might discover a few new tips, as Colin Legg takes us on a guided tour of the VBA IDE’s options.
- 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.)
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.
Microsoft 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.