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

February 2009 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • How to Create a Professional Chart using Excel 2007

    Today's author, Robin Wakefield, a Program Manager on the Excel team, discusses charts. As a new program manager in Excel one of my first tasks was to understand what problems users encounter when building professional charts in Excel. I defined professional as following the principles of Edward Tufte by reducing the amount of non-data ink on a chart. On an earlier post , there were a lot of comments about this particular aspect and I agree we could do better in helping users accomplish this...
    Filed under: ,

  • Simple Expense Tracking With New Excel 2007 Functions

    Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, gives an overview of some new functions in Excel 2007 and along the way shows us how to do some simple expense tracking. Considering the current economic environment, one may desire to better keep track of personal expenses. The new functions introduced in Office Excel 2007 simplify this effort. Here is how: given a list of expenses sorted by dates and categories (food, travel, clothing, etc.), how do I find how much...

  • Quick and Easy Data Access with Excel Services

    Today’s author, John Campbell, a Program Manager on the Excel Services team, shows us the quick and easy way to get external data access working with your Excel Services spreadsheets. I have seen a lot of great blog posts that tell folks how to do great things with refreshed data in an Excel spreadsheet using Excel Services. I’ve seen posts about slicing dashboard pages, about using .odc files to manage data, and more. One thing that continues to be an issue is how to get connected to that data in...

  • New Case Study Involving Excel Services

    A new case study has been published that describes how Microsoft IT used Excel Services to build a portal for finance data. Here's a snippet from TechNet: Controller Workspace: Connecting With Excel Services in Microsoft Office SharePoint Server 2007 Describes how Microsoft IT created a centralized user interface platform, called Controller Workspace, that enables users to view reports, key performance indicators (KPIs), and other finance data. Out-of-box features of Microsoft Office 2007 Excel...
    Filed under:
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.