-
The other day, I was filling out a huge Excel table, and I found myself needing to enter the exact same information in multiple cells. To save time, I used something called End mode in combination with the arrow keys on my keyboard to quickly select all the cells I needed to change. Many of my own coworkers...
-
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...
-
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...
-
In this series of posts I’ve decided to walk through some of my favorite Excel keyboard shortcuts and a few other little tricks I’ve learned along the way that helps me work faster. In fact, when visiting some analysts in financial services, I learned that when they get trained on Excel, the instructor...
-
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...
-
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...
-
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...
-
Today’s author is Bob Umlas, Excel MVP and author of This isn’t Excel, it’s Magic, a book that is filled with tips and tricks for getting the most out of Excel. This post shows you how to quickly remove zero values and blank cells from a list that contains values. Here’s a formula which enables you to...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...