Excel Roundup 20140602

At PC World, Julie Sartain shows how to set up a workbook with a sheet for each month, and 3D formulas to summarize the Year to Data expenses. It’s not the way I’d set it up, but that’s a topic for another blog post.
What struck me was the comment,

“One of Excel’s greatest tricks is the dimensional or 3D reference…In Excel 2013, Microsoft has beefed it up with enhanced options and formulas.”

There are new functions, and other features in Excel 2013, but I don’t know of any new options in this area – did I miss something?


Contextures Posts

Here’s what I posted last week:

  • Create IFRAME code with formulas, and copy it to your web page or blog article, to embed a YouTube video, or other content.
  • Finally, for a humorous peek at what other people are saying about spreadsheets, 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:

Excel Resources

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

Share Your Events and Articles

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!
Links to Recent Excel Books on Amazon.com