Show Notes: Episode 164

  • Using Filter to Find Records in Excel 2007
    Bill Jelen
    www.mrexcel.com

    • The old AutoFilter command is now called Filter. Use the Filter button on the Data tab of the ribbon.
    • Select one cell in the data set and click the Filter icon. You can now use the dropdowns at the top of each column to filter the data.

    Demonstrations on the show:
    • Filter a data set to a specific customer.
    • Add a formula that will show the totals for the selected customer
    • Change to a new customer – the formulas are an ad-hoc query tool
    • New in 2007: Filter a date field to a particular month
    • New in 2007: Filter a text field to only items that contain “Bank”
    • New in 2007: Filter a numeric field to records above average
    • New in 2007: Filter to find all the red cells

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

    RELATED WEBSITE LINKS
    www.MrExcel.com

    PRODUCTS SHOWN
    Learn Excel 97–2007 from MrExcel – 377 Excel Mysteries Solved
    $39.95 in print, FREE as an e-book at http://www.mrexcel.com/leobook.html

  • The iPod dock Evolves
    Cali Lewis
    Host, www.GeekBrief.TV

    I’ve been waiting for something like this for a long time!

    Evolve Speakers
    www.evolvespeakers.com
    $299.99

    Transmit up to 150 feet, some people are getting 300 feet
    Has an iPod dock or you can connect other audio via RCA ins.
    Charging stations part of system
    Switch speakers on chargers and they will automatically switch audio channels
    Remote – only thing I’m not impressed with because it has more options than an Apple remote with less funtionality

    Cali Lewis is the host and co-producer of GeekBrief.TV (a video podcast about the latest gadgets and tech news) and The Dear Cali Show (Tech Questions? Answered.). She co-hosted Call for Help with Leo Laporte for three months, and appears regularly on MSNBC, The Tech Guy, and This Week in Tech.

  • The Frightening Insecurity of Wireless Keyboards
    Steve Gibson
    Security Expert. www.grc.com

    Having a keystroke logger installed on a computer is one of the worst things that can happen. But what it everything you type on your wireless keyboard can be easily intercepted by a neighbor or office worker?!!! It turns out, it probably can be.

    Leo and I will examine and describe the incredibly weak “encryption” used on Microsoft’s 1000 and 2000 series (and probably other) wireless keyboards to show how easily that encryption can be broken to allow anyone within “radio range” to log everything typed.

    If you Google: “wireless keyboard encryption” right now you’ll find a number of links to articles about the recent revelation of how simple Microsoft’s wireless keyboard encryption is. You can certainly put any of those links on an accompanying web page … thought I won’t be referring to any of those directly.