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

Using the VLookup Function in Excel 2007 (Visual How To)

Learn how to dynamically search table arrays in Excel 2007 using the built-in VLOOKUP function.

See the original post: 
Using the VLookup Function in Excel 2007 (Visual How To)