Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Excel 2007 offers a cool trick to replace Freeze Panes. Episode 1094 shows you how.
Labels: Excel 2007, Freeze Panes, Table
posted by Bill at 9:00 AM
In Episode 994, another solution to Ally's problem of how to make a chart expand when you type new data in the worksheet. Today's method shows an easier way to set up a dynamic chart range in Excel 2003 and newer.
posted by Bill at 9:00 AM
I've talked about making the list for your data validation automatically grow with the list. In the past, I've used a macro or the OFFSET formula, but today Morne sends in a beautiful solution for either Excel 2003 or Excel 2007 to build a dynamic validation list. Episode 937 shows you how.
Labels: List, Table, Validation
posted by Bill at 9:00 AM
In case 54x20 formats is not enough for you, you can design your own table format. Episode 935 shows you how.
Labels: Formatting, Table
posted by Bill at 9:00 AM
The every-other-row formatting becomes simple in Excel 2007 using the Table functionality. Choose from 54x20 formats in seconds. Episode 934 shows you how.
Labels: Formatting, Greenbar, Table
posted by Bill at 9:00 AM
Joe sends in a tip about converting your pivot table source data to a dynamic range. While this used to mean using the OFFSET function, now it simply means using Ctrl+L (in Excel 2003) or Ctrl+T (in Excel 2007). Episode 825 shows you how.
Labels: Dynamic Range, List, Pivot Table, Table
posted by Bill at 9:00 AM
Six accent colors x 7 options x 20 themes x your imagination leads to thousands of different formats that you can apply to a table with a single click. Episode 425 shows you how.
Labels: color, Formatting, Table
posted by Bill at 9:00 AM
One of the best features of the new Excel 2007 table functionality is the new table formulas that Excel can create. Once you enter a formula in the first row of a dataset, Excel 2007 will automatically copy the formula down to all of the rows. Episode 423 shows you the details.
posted by Bill at 9:00 AM
Once you have defined an Excel 2007 table, Excel will usually automatically sense when you enter data in adjacent cells and extend the table to include the new cells. Episode 420 takes a look at extending tables, using the Table Tools Design ribbon, and new selection options when you have a table.
Labels: Table
posted by Bill at 9:00 AM
Excel 2007 adds new table intelligence that you can use in probably 90% of your worksheets. In Episode 418, learn how table functionality can easily apply greenbar formatting, autofilters, and more.
Labels: 2007, AutoFilter, Greenbar, Table
posted by Bill at 9:00 AM
