Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Excel

The team blog for Microsoft Excel and Excel Services.

March 2009 - Posts

Analyzing Data: Functions or PivotTables
Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, discusses two different approaches to analyzing data in Excel. Edit: I've attached a file at the bottom of this blog that contains spreadsheets of the examples discussed Read More...
Excel VBA Performance Coding Best Practices
Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance . I want to start off this post by thanking everyone who sent in their examples in response to my January Read More...
Creating Dynamic Validation Ranges
Today’s author, Dany Hoter, a Product Planner for the Excel team, shares a neat trick he learned recently for creating dynamic data validation ranges. The sample file used for this blog post can be found in the attachments at the bottom of this post. Read More...
Page view tracker