Browse by Tags

Guest blogger Emily Warn is a writer and confirmed Excel geek. In this post, she demonstrates how to use the new Quick Analysis feature in Excel 2013 to create a spreadsheet with book sales numbers that can be sorted by name and number in order to make data tell a story by presenting it visually. ...( read more ) Read More...

Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection. ...( read more ) Read More...

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...