Excel 2010 changes function names like STDEV and VAR partly for Microsoft’s own benefit. Excel 2010 has revamped all the Standard Deviation STDEV and VAR functions with the old version ‘deprecated’ or demoted. There is now STDEV.S and STDEV.P for the sample and population versions of the function. STDEV and STDEVP are still available for […]
More useful stats functions in Excel by David Goodmanson Continuing our series on Excel’s statistical functions … we started with Average/Mean and now move onto the misunderstood cousin Median plus also Mode. Median and Mode If we are looking for work and are told that the average salary is $45,000, then we have an idea […]
Create the ultimate lookup or decision formula; a User Defined Function using Visual Basic for Applications. by David Goodmanson Following our recent theme of reference, decision and lookup functions, in this article we will go one step further and create the ultimate lookup or decision formula; a User Defined Function (UDF), using Visual Basic for […]
Excel alternatives to nested IF’s from our readers. After David Goodmanson’s features on IF and nested IF’s we’ve received many messages from readers suggesting another alternative – CHOOSE() and here even more possiblities. Tony D writes: “ Small snippet for your “IF” library next time. I’m sure there will be hundreds of better ideas, but you […]
A look at the progress of Office 2007 SP2 – bugs fixed or not. It has been over a month since Office 2007 Service Pack 2 was released. Here’s a look Outlook 2007 won’t start We mentioned reports of Outlook 2007 not starting after SP2 was installed. Those initial reports appear to be a problem […]