Every afternoon, you could tune in to watch Leo Laporte give computer advice on a great show: Call for Help. If you are familiar with Car Talk on NPR, this was similar; Excel Leo was on TV, not radio, and he was broadcasting five days a week instead of just Saturdays. Between the calls, Leo would have two guests per episode. I was the Excel guy on Call for Help, making 86 appearances. Leo would give me six minutes to demo something cool in Excel. At the end of my segment, he would hold up my book for the camera.
These pages are the show notes that I wrote up for each episode.
Excel 2007 provides dramatic improvements to the Filter function in Excel. You can quickly filter a list to find a specific customer, records from a certain month, or records highlighted in a certain color.
One of the annoying tasks in previous versions of Excel was finding a unique list of invoices, customers, or products in a data set. Today, we’ll look at the various methods, including a new method in Excel 2007.
Sometimes you are working in a Word document and it would be much easier to use Excel for the next section of the document. Perhaps you need a table, a chart, or some quick formulas. Without leaving Word, you can easily replace the Word menus with Excel and use Excel for the next section of the document.
The chief complaint about Office 2007 is that Microsoft replaced the menu and toolbars with a new user interface called the Ribbon. In their arrogance, Microsoft refused to provide a classic mode. In this segment, we’ll review two products that bring back the classic menu
In Excel 2003, Microsoft introduced List functionality (Ctrl+L). They've improved and replaced this in Excel 2007 with table functionality. Most spreadsheets contain data in a tabular format - headings across the top and each row containing a new record.