Results for:
PDF

• Excel 2007 Web Data Add-In

  16 Oct 2007

  Some folks at Microsoft Research have developed an add in that makes it easy to use a Web page as a data source in Excel. Here is a brief description: The Excel 2007 Web Data Add-In provides an intuitive user interface for importing textual data from any given webpage via a user’s selections of interest...
• What Keyboard Shortcuts Do You Want To See In Excel?

  24 Sep 2007

  About 18 months ago, I wrote a post on keyboard shortcuts: http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx . It was a well-read post that generated a lot of comments and a lot of follow-up email. To this day, I get emails about this post, a number of which have been people asking for an XLS...
• Super Tooltips and Collapsing The Ribbon

  10 Mar 2006

  While we are talking about the new user interface, I thought I would mention another feature the user interface team has added that I think will prove to be very helpful to a lot of users. The basic idea is to take tooltips, which are useful little devices, and add some additional capabilities. Let’s...
• Excel 2007 – The Final Look, and more rows and columns

  9 Mar 2006

  The Final Look For most of the history of this blog, I have been showing you screenshots produced using “Beta 1” builds of Excel 2007 and making comments along the lines of “not final UI”. Today, the UI became a lot more final. What do I mean? This morning at the CeBIT conference in Germany, Microsoft...
• Making features easier to find and quicker to use

  2 Mar 2006

  One of the things the ribbon afforded us a chance to do was to make existing Excel functionality (meaning functionality already available in current versions of Excel) easier to find and quicker to use. Today I thought I would walk through a few (but in no way exhaustive) examples. Find can be more than...
• Managing External Database Connections in Excel 12

  16 Feb 2006

  Now that we have covered OLAP formulas, I would like to explain a set of work we did in the area of “connection management” in Excel 12 workbooks. Specifically, I want to show you three new things that you can do in a workbook that is connected to external data (whether that is an Access database, and...
• Quick detour #2: Working with currencies made easy …

  2 Dec 2005

  Before I dive into PivotTables, I thought I would mention an Excel 12 feature that resulted from collaboration with our international subsidiaries. Users that work outside North America (and even some users that work within North America) build a lot of spreadsheets that contain multiple currencies....
• Quick detour – cool things on the status bar and great-looking charts

  18 Nov 2005

  Today I decided to take a quick break from Excel Services to talk about a few small but useful changes that have been made to the status bar and show off a few charts First, the status bar Zoom control - we have added a slider that allows the user to adjust the “zoom” of the document without needing...