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

Browse by Tags

  • Using Excel 2007 for Progress Tracking in the Classroom

    Today's author, Danny Khen, a Program Manager on the Excel team, discusses a solution he recently built using Excel. The Manual Spreadsheet Spreadsheets are the bread and butter of running the business world, where PCs are ubiquitous. The possibility, indeed even the need, to use spreadsheets in an environment where access to a computer is not taken for granted seems absurd to us, as business users and technology professionals. We do still print reports for some output scenarios, such as executive...
  • Tracking Split Costs

    Today’s Author: Joe Chirilov , a program manager on the who has done a lot of work on both the Excel and Excel Services teams. Joe is going to discuss a spreadsheet he recently built using Excel 2007. Recently a large group of friends and I went on a multi-city tour of Europe that lasted a couple weeks. We had a blast, but that’s a conversation for another day. There was a lot of planning that went into this trip and responsibilities for booking different legs of the trip were spread out across the...
  • Data Bars – Feedback Please

    Today’s author: Scott Ruble, the program manager who leads the charting and visualization efforts in Excel. Scott is looking for some feedback on potential changes to data bar behaviour. Excel 2007 has a conditional formatting feature that graphically displays bars in a cell to represent the value of the cell. This feature is called Data Bars. You can see an example of this by using the following steps: In Excel 2007, enter 1, 2, 3 in cells A1, A2, and A3 respectively. Select cells A1:A3. From the...
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.