Browse by Tags

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, and I'm happy to announce that as part of that refresh, the Excel Services JSOM documentation was also updated--in fact, it's been completely revised. Keep reading to learn...

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 actually unplugs the mouse from the classroom computers in order to really drive home the efficiencies that can be gained from keyboard shortcuts. But when I say these are my favorites what I really...

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 we are embedding an Excel scatter chart on a SharePoint wiki page. The scatter chart works like an analog clock, so that you can see that the data returned via REST is dynamic, and the workbook containing...

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 access a list of values interspersed with zeros or blanks and it will pick up only the non-zero values in the same sequence they’re listed. It’s better to illustrate. Suppose you have this list in A1...

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. Let’s see how this is made with sparklines in Excel: There are actually 24 sparklines in the picture above; each one is bound to a single data point in a similar table with the numbers. You can...

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 can do with sparklines in Excel 2010 is to stick them in cells above or below each other and have the points line up. Doing this will allow you to see trends for multiple fields in a related way. Here...

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 help identify trends behind the number: Seattle and Houston both dipped in the summer, in general their profits climbed as the year went on, and Richmond didn’t do well until the last month...