Office 2010 and SharePoint 2010 PDC Keynote in Depth

Kurt starts today’s discussion with a quick conversation on the Business Productivity Infrastructure. If you know the Office and SharePoint environment well, this is probably something you’ve seen us discuss before. It was at PDC08 when we announced that we will be releasing Office Web Applications that provide a high-fidelity & consistent experience for users who want to access and modify Office content in a browser, mobile device or the rich client

Original post:
Office 2010 and SharePoint 2010 PDC Keynote in Depth

Now Available: Data Analysis For Excel 2008!

Back in March, I posted to Mac Mojo about Excel's Analysis ToolPack add-in and Office 2008.  For those that don’t know, Analysis ToolPak (ATP) is a wildly useful tool that provides 19 different data analysis options to Excel users. If you’re looking to do a quick histogram, ANOVA or covariance test, ATP is one of those features that can make you fall in love with Excel all over again. There’s just one problem: while ATP shipped with earlier versions of Office (such as Office 2004), it didn’t come with Office 2008

Read the original: 
Now Available: Data Analysis For Excel 2008!

Sheet Navigation in The Ribbon UI – Part II

In my first post about Sheet Navigation I showed a basic approach. Here I will show a more practical and realistic solution to navigate between sheets.

Read the original here: 
Sheet Navigation in The Ribbon UI – Part II

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 request. It is incredibly helpful to be able to look at what you all are doing with Excel! Not only did I see a huge variety in how Excel is being used, you also pointed out various tips and tricks for writing fast VBA code in Excel.

View original post here: 
Excel VBA Performance Coding Best Practices

Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel 2007

MVP Ron de Bruin provides a number of samples to merge data from multiple worksheets into one summary worksheet.

Here is the original: 
Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel 2007