Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

July 2012 - The Excel Team Blog

  • Office Business Intelligence – The way people experience data

    This post is brought to you by Steve Tullis Group Program Manager of the Office Business Intelligence team. This is the third introductory post from the Excel family – Office BI. If you have not read Jane’s post about the Excel client, or Dan’s post about the browser-based versions of Excel, I encourage you to do so, as they are great overviews and provide foundational information about how we decided in what to invest, and how those investments are manifest in the Excel products...
  • Excel Web App - What's now available in a browser near you?

    This blog post is brought to you by Dan Battagin, Group Program Manager for the Excel Web App team. Greetings - I hope everyone's been enjoying the content on the blog over the last few releases, and that everyone's excited to see what's coming in the next version of Office , Excel, and the Excel Web App. Jane mentioned in her last post how we went about deciding what to invest in, and today I’ll share with you some of the broad investment areas for the browser-based versions of...
  • Introducing Excel 2013

    This blog post is brought to you by Jane Liles Group Program Manager for the Excel team. With this post she kicks off a brand new blog series introducing all the features we have added across Excel for the release of Office 2013. Greetings from the Excel team hallway… By now you’ve hopefully tuned into our Office Next blog , which provides all-up view of our latest release for Office, and seen some articles on the web. Today I have the privilege of sharing a high-level view of Excel...
    Filed under: ,
  • The good kind of circular reference

    There have been ample articles about troubleshooting unintentional circular references in Excel workbooks. This post focuses on the opposite: choosing to deliberately work with circular references. Circular references aren't a bad thing in itself: you can use them to achieve complex calculations that are otherwise impossible to do, but first you must set them up properly. ...( read more ) Read More...
  • Too much data? Use Auto Outline to group and view it

    Puget Sound Pets can't keep enough dog chews on the shelves for all the corgies they sell. And they can't keep up with the sales data they generate from their booming business. To better understand their revenue stream, they need to view it on a month-to-month and a store-to-store basis. Excel's Auto Outline feature offers a simple way for Puget Sound Pets to do that. It allows them to group--to limit or expand--the types of data they can view. ...( read more ) Read More...
  • Score! Merge data from multiple worksheets

    The Excel Consolidate feature provides an easy way for a coach to merge data from different expense worksheets into one main budget. By using the Consolidate feature , the beleaguered coach can get a handle on his team's expenses so he can focus on teaching the Decatur Golden Gators to score goals. ...( read more ) Read More...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.