July 2009 - Posts
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
Read More...
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
Read More...
The Office 2010 Engineering blog has a new post up about Backstage and how it improves the experience around printing. Here’s a quote: Has the following ever happened to you? After writing a document, you format the page so it looks just right.
Read More...
We haven’t really gotten into the details of the Excel Web App yet here on this blog, but the Office Web Apps blog is already talking about topics that apply to the web apps as a whole. A new post went up yesterday that discusses how the web apps
Read More...
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
Read More...
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
Read More...
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
Read More...
The Office Engineering blog has a post up with an overview of the security features that went into Office 2010. Here’s a snippet: …we have designed what we have been referring to as a new security workflow, a layered defense that Office documents
Read More...
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,
Read More...
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.
Read More...
Thanks to Sam Radakovitz, a Program Manager on the Excel team, for putting together this series on Sparklines. For Excel 2010 we’ve implemented sparklines, “intense, simple, word-sized graphics” , as their inventor Edward Tufte describes them in his book
Read More...
Before we begin our whirlwind tour of all things Excel, I thought I’d give you a quick glance at the things we’ve done. The “table of contents” if you will. That way you’ll have an idea of what to expect in the coming weeks, and I hope it gives you a
Read More...
Since we're now in "2010 mode", updating the look of the blog site seemed like a good idea. A facelift was overdue. Hope you like it. I also added a list of links to other Microsoft sites and blogs related to Office 2010. You can find it in the side-bar
Read More...
On the topic of “teasers”, one of the things we’ll be talking about in the coming weeks is project Gemini. I won’t get into the details just yet (otherwise it wouldn’t be a teaser), other than to say it’s a powerful data analysis feature, it’s an add-in
Read More...
You’ve most likely heard the news by now. At the Worldwide Partner Conference in New Orleans, Microsoft announced that the next version of Office reached its Technical Preview engineering milestone. You can read the highlights in this press release (and
Read More...
Today’s author is Ron de Bruin , an Excel MVP. You can find more useful tips and links to Excel add-ins at his website: http://www.rondebruin.nl/ You see a lot of old SaveAs code that does not specify the FileFormat parameter. In Excel versions before
Read More...
