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/ There are four primary week numbering systems in use worldwide
See the original post here:
Week Numbers in Excel
Today’s author is Bob Umlas, an Excel MVP since 1994. This tip is a formula which enables you to access a list of values interspersed with zeros or blanks and pick up only the non-zero values in the same sequence they’re listed
Go here to read the rest:
Formula to Access a List of Values Interspersed with Zeros or Blanks
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!
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)