Results for:
how to

• Speed up data-entry tasks by using End Mode

  6 Sep 2011

  The other day, I was working on a huge worksheet with lots of rows in Excel table columns that I needed to fill out, often with the same text or values. To do this as quickly as possible, I used something called End mode. Many of my colleagues have never heard of End mode, so I thought that you might...
• Excel Services content refresh is live

  30 Jun 2011

  If you're a developer, you may have been wondering..."When are they EVER going to revise the Excel Services JavaScript Object Model (JSOM) documentation for SharePoint Server 2010?" Well, I'm glad you asked! The SharePoint Server 2010 Software Development Kit (SDK) online documentation has been refreshed...
• Use SUMPRODUCT to find the last item in an Excel list

  4 Aug 2010

  Today’s author is Charley Kyd, an Excel MVP, who describes how to use the SUMPRODUCT function to find the last sequential item in an Excel list. Charley has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. You can find...
• How it's Made: Tower Defense - a Game in Excel 2010

  27 Jul 2010

    This blog post is brought to you by Karen Cheng a Program Manager on the Excel team.     In today's post, we'll show you how the arcade game Tower Defense was created in an Excel spreadsheet (see a video of the game being played here ).  In this game, creeps move toward your castle...
• New Posts From One of the Principal Developers Behind Excel Services

  10 Nov 2009

  One of our most senior developers on Excel Services, Shahar Prish, is busy writing posts in his blog on the new programmability features in the 2010 version of Excel Services. The first set of posts talk about REST and moving forward he will expand to the new JavaScript OM we added this release. Here...
• Excel Services in SharePoint 2010 REST API Examples

  9 Nov 2009

  Thanks to Christian Stich for putting together this series on the REST API. In this final installment on the REST API, we’ll walk through a couple examples of using the REST API to embed spreadsheet data in new and interesting ways. Embedding a ‘Live’ Chart on a SharePoint Wiki Page. For this example...
• Using form controls on a worksheet

  23 Sep 2009

  Today’s author is Rob van Gelder, previously quite active in the online Excel scene (Newsgroups, Excel forums, his own but currently inactive website) and who just upgraded to Excel 2007 because he still likes to dabble. The following power tip shows that he’s still having fun with form controls. My...
• Copying Worksheets with a List or Table

  31 Aug 2009

  Today’s author is Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ Problem : It is not possible to copy more than one sheet to a new workbook or existing workbook if there is a List (Excel 2003) or a Table (Excel...
• Creating a Custom Popup Menu

  31 Aug 2009

  Today’s author is Derek Mang, owner of Systems Solution Developers Inc. You can find more useful tips from Derek on his website: www.officevbasolutions.com . This post shows you how to create a custom popup menu in Excel. Microsoft Excel has lots of popup menus that are made available to the user with...
• One More Sparkline Trick

  3 Aug 2009

  In this blog post I’ll walk through one more interesting way you can use sparklines in Excel 2010. In the above example we have the sales for each book category and for each store. While you can’t see the exact numbers in this view, you can get the feel for which sections sell well at the different stores...
• Using parameters with web queries

  31 Jul 2009

  Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ This post shows you how to dynamically work with data from a website in Excel. Introduction Excel provides a very useful option to gather data from websites, called...
• A Sparkline Trick - Using the Horizontal Axis as a Reference Line

  30 Jul 2009

  In this blog post I’ll walk through some of the ways you can use sparklines in Excel 2010 using sample sparklines from the book store demo file: In the above example we have the data for the employee sign-up contest, this is a contest where employees try to get customers to sign-up for a bookstore club...
• Sparklines – Lining Up the Points

  28 Jul 2009

  In this blog post I’ll walk through some of the ways you can use sparklines in Excel 2010 using sample sparklines from the book store demo file: In the above example we have sales for each year, the cost of sales, and net profit for that year all divided by the category of book. One of the things you...
• Sparkline Axis Options

  24 Jul 2009

  In this blog post I’ll walk through some of the axis options for sparklines in Excel 2010 using sample sparklines from the book store demo file: The above sparklines are displaying the number of books by category for each month. The sparklines in this example are giving the history of the count of books...
• Formatting Sparklines

  22 Jul 2009

  In this blog post I’ll walk through formatting sparklines in Excel 2010 using sample sparklines from the book store demo file: The above sparklines are displaying the net profit by month for the three book stores in 2008. The net profit number alone can tell you which stores are doing well, but the sparklines...
• Adding Some Spark to Your Spreadsheets

  20 Jul 2009

  In this blog post I’ll walk through creating sparklines in Excel 2010 using a sample table from the book store demo file: In the table we have the sales for the month of June: a column for total sales for the month, multiple columns for each day’s sales, and rows that break out different book categories...
• Add Buttons to the Quick Access Toolbar and Customize Button Images

  17 Jul 2009

  Today’s author is Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ This post shows you how to add a button to the Quick Access Toolbar (QAT) for one or all workbooks. It also shows an example of how you can change...
• Modifying Conditional Formatting Color Ranges in Excel 2007

  16 Apr 2009

  Today’s authors, Amit Velingkar, a Program Manager on the Excel team, and Bob Silverstein, a User Experience Researcher on the Excel team, talk about creating professional looking Color Ranges in Excel. Introduction: My fellow PM on Excel, Robin Wakefield, wrote a blog article on how to create professional...
• A Robust Way To Reference Multiple Columns In a Table

  9 Apr 2009

  I’m sure many of you have built a spreadsheet like this before: you’ve got a table of data; one of the columns in this table contains a formula which references a span of columns in the same table. The number of columns you need to reference may change over time as requirements change. How do you you...
• Creating Dynamic Validation Ranges

  5 Mar 2009

  Today’s author, Dany Hoter, a Product Planner for the Excel team, shares a neat trick he learned recently for creating dynamic data validation ranges. The sample file used for this blog post can be found in the attachments at the bottom of this post. The problem: Validating data entry based on hierarchical...