August 2009 - Posts
Thanks to Chad Rothschiller for helping me put this post together. We’ve spent the last few weeks talking about improvements to the various visualization features in Excel. For the next few posts, I am going to cover some “under the hood” type improvements,
Read More...
I’m back from my vacation (boy, Seattle is really gorgeous during the summer!). Thanks to Sam Radakovitz (Sam Rad) for filling in for me while I was out. And thanks to Ben Rampson and Robin Wakefield for putting together this final post on charting improvements
Read More...
When you open workbooks downloaded from the Internet in Excel 2010, you’ll enter into the new Protected View . While in this mode, Excel runs in a “sandbox,” which means that you are now better isolated from any malicious code that could be contained
Read More...
The Power Tips feature of the Excel Team Blog has started with useful articles from MVPs Ron de Bruin and Jan Karel Pieterse. Thank you both! For everyone else who is interested in contributing to this blog, here’s a quick reminder how the feature works.
Read More...
Thanks to Ben Rampson for putting this post together. In today’s article I will outline some of the significant new chart improvements that impact performance. In Office 2007 the graphics engine used by Office Charts was replaced with one that could support
Read More...
Last month, we blogged about Project Gemini, a cool new add-on to Excel and SharePoint that lets you do some powerful data analysis. Well, the first preview release of Gemini is out this month as part of the SQL Server 2008 R2 August CTP. The Gemini product
Read More...
Over the next three posts this blog will cover some of the charting changes that have been made in Office 2010, many of which are the direct result of customer feedback. As part of the Office 2007 release we overhauled charting throughout Office; however
Read More...
A nice video on the SharePoint blog that answers the question: “ what is sharepoint? ”.
Read More...
New features in conditional formatting extend to the object model as well. Excel has traditionally allowed users to access the formatting of their cells through the object model. For example, Users can use the interior class which lives off the range
Read More...
In this blog post I’ll walk through some of the new Conditional Formatting features in Excel 2010 such as: Cross-Sheet References Robust Error Handling Performance Enhancements Cross-Sheet References In Excel 2010, you can create conditional formatting
Read More...
Data Bars are a popular type of conditional formatting that was introduced in Excel 2007. The basic idea of data bars is that Excel draws a bar in each cell whose length corresponds to the value of the cell relative to the other cells in the selected
Read More...
Thanks to Amit Velingkar, a Program Manager on the Excel team, for putting together the next few posts on conditional formatting. In Excel 2007, we introduced Icon Sets - a new type of conditional formatting. The basic idea is that Excel draws an icon
Read More...
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
Read More...
