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 nested IF statements and alternatives that are easier to make and understand later. by David Goodmanson In my last article I looked at a simple Excel IF statement plus their useful cousins CountIf and SumIF. I also touched on the nested IF statement, where there are many IF functions in one cell. […]
PPT Handouts are a special rendering of your slides to be printed out for your audience. PowerPoint Handouts are a special rendering of your slides to be printed out for your audience. It’s one of the ‘PowerPoint support materials‘ including Notes. In this article we show how to make and print PowerPoint handouts. Printing Handouts […]
Three places to save password information in MS Office. Ideally each login to a computer or web site should have its own password but it’s a given that we all use the same passwords too often. Remembering all those passwords is hard enough but you also have to remember the login name; was it your […]
