Show Notes: Episode 158


  • Perfect Paper Passwords
    Security Expert. www.grc.com

    Gibson Research Corporation (www.GRC.com) recently designed and released a highly secure, zero-cost, freely available “One Time Password” system for providing multi-factor authentication – similar to the hardware “tokens” we’ve discussed before – but requiring NO hardware. It’s known as “Perfect Paper Passwords” and has now been implemented in all popular programming languages. It is being used by end-users to access their PCs, by web sites, by private corporations, and many others:

    http://www.GRC.com/ppp.htm

    Leo and I will describe the design and operation of this freely available, open source, super-secure solution which will likely see increasing use in the future.

    RELATED WEBSITE LINKS
    http://www.GRC.com/ppp.htm


  • Illustrate Business Processes with SmartArt in Office 2007
    www.mrexcel.com

    • From Word, PowerPoint or Excel 2007, Choose Insert – SmartArt
    • Choose one of the layouts (this can be changed later)
    • Build your message in the text pane. Excel automatically resizes the text in the graphic to fit and keep all shapes balanced.
    • Choose a color scheme.
    • Choose an effect from the five 2-D styles or 7 3-D styles. Note the last style is great for sharing bad news (no one can read anything)
    • Show how easy to present the same message in new shapes by changing to a new layout.
    • Show off a gallery of 8–10 SmartArt layouts

    The amazing tip that Microsoft doesn’t tell anyone:
    • Normally, values in the shapes can not come from formulas in Excel. I published the workaround that allows this to happen:
    • Create the SmartArt with dummy text.
    • Select one shape in the diagram.
    • Press Ctrl+A to select all shapes.
    • In a blank section of the worksheet, paste a copy of the SmartArt. But – it is no longer SmartArt – it is now a collection of Excel shapes!
    • Select a shape. Click in the Formula bar. Type =A1 and press Enter. The value in the shape now comes from cell A1.
    • Repeat for each shape.
    Now, when the formulas in the spreadsheet change, the text in the SmartArt will change.

    I will post show notes at http://www.mrexcel.com/tip155.shtml


  • Add Bluetooth to your Asus EEE-PC
    Co-Host/Producer: www.DigitalUnderground.tv