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?

formula3d01

 

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

__________________________________

You may also like...

8 Responses

  1. Rudi says:

    Hi Debra,

    I can second you on your observation. There is of course new features in Excel 2013 including some new functions like Sheet(), but as for the 3-D capabilities specifically, I am (IMHO), not aware of any changes in 2013 as compared to older versions. Julie was probably just trying to emphasize a point.

    Cheers
    (and TX as always for Contextures – an amazing site with an amazing blog)

  2. Ross Goodman says:

    Thanks for linking to my website – one small correction though: the macro that I posted pulls calendar entries not tasks from Outlook to Excel.
    Although on reflection – I probably SHOULD include this on my weekly report but I tend not to capture this level of granularity in Outlook.

    Thanks

    Ross

  3. Hi Deb,

    I posted a new article on my blog : http://dataprose.org/2014/05/undaunted-by-unpivot/ The article demonstrates how to UnPivot or Normalize data that is in a Cross-tab format.

    Thanks
    Winston

  4. Bob Ryan says:

    Debra – To the best of my recollection, the 3D formula mentioned has been around for awhile, having been shortened from what I think used to be a CONSOLIDATE function years ago. Also, as a CPA, I share your opinion about not preparing separate sheets for monthly expenses. One sheet plus a PivotTable(s) would be my recommendation. A free student budget workbook that uses this latter approach can be downloaded from the spreadsheet day blog (spreadsheet-day.com/blog, then search for student budget workbook).

Leave a Reply to Rudi Cancel reply

Your email address will not be published. Required fields are marked *