Learn Excel from Bill Jelen with this daily 2 minute video podcast.
What if you had to total 168 different fields using the Subtotal command? The maddening Subtotal box only lets you choose three fields before scrolling to see three more fields. In Episode 351, learn the cool way to quickly add the subtotals.
posted by Bill at 9:00 AM
There is another way to use the AutoSum icon in the standard toolbar. This alternate method will show you the totals of the visible cells, ignoring cells in hidden rows. Episode 350 shows you how.
Labels: AutoSum, visible cells
posted by Bill at 9:00 AM
In Episode 349, learn a cool way to add new data to an existing chart. My book usually shows the drag and drop method to add data, but in Episode 349, you can learn how to drag the selection handle to add or remove data from a chart.
Labels: charting
posted by Bill at 9:00 AM
Calculate Sales over Quota using either the IF or MAX functions. Episode 348 shows you how.
posted by Bill at 9:00 AM
Andy "Cyber" Walker once asked me what seemed like a simple question - he wanted to use conditional formatting to change records to green if the total of all records for that day exceeded $1000. While this sounds simple, it actually is incredibly complex to set up. Episode 347 walks you through the amazing conditional formatting option to allow this to happen.
Labels: conditional formatting
posted by Bill at 9:00 AM
Change the decimals in your spreadsheet to display as fractions. Excel offers options for halves, quarters, etc., but Episode 346 shows you how to create a custom format to display in thirty-secondths or even five-hundred-eighty-eighths.
Labels: custom format
posted by Bill at 9:00 AM
How to make a value that is slightly too large for a column automatically fit. Episode 345 shows you how.
Labels: Column Widths
posted by Bill at 9:00 AM
The complete guide to applying borders to a selection. Learn what all of those icons actually do on the borders tab. Episode 344 shows you how.
Labels: Formatting
posted by Bill at 9:00 AM
Tricks for adding a double underline to your cells. Episode 343 shows you how.
Labels: Formatting
posted by Bill at 9:00 AM
Do you get annoyed when you copy a formula and the borders get copied along with the formula? Episode 342 shows you a cool trick to prevent the borders from being copied as you extend a formula.
Labels: border, Formatting
posted by Bill at 9:00 AM
How to print your worksheet with the row and column headings visible. Episode 341 shows you how to make your printout look just like your Excel screen, plus two reasons why you would want to do this. Learn how to print formulas instead of values and how to print your cell comments at the bottom of the sheet.
posted by Bill at 9:00 AM
Why does every TRUE value in your worksheet get a little purple triangle? You can thank some out-of-business company with the stock ticker of TRUE for that one. In Episode 340, we'll take a look at how to selectively turn off SmartTags for one company.
Labels: Smart Tag, stock ticker, TRUE
posted by Bill at 9:00 AM
Today I show you a great trick for copying formatting from one place to another. Unlike Paste Special Formats, this technique also brings over column widths and row heights. Episode 339 shows you how.
posted by Bill at 9:00 AM
Change your worksheet tab colors - a new feature in Excel 2002. Episode 338 shows you how.
posted by Bill at 9:00 AM
Need to print a report quickly but don't want the error cells to show? Episode 337 will show you how to hide the errors by changing them to blank cells.
posted by Bill at 9:00 AM
How to make a report fit to one page wide by hundreds of pages tall. Episode 336 shows you how.
posted by Bill at 9:00 AM
How to use Page Break Preview mode to see all of your page breaks. Episode 335 shows you how.
posted by Bill at 9:00 AM
The difference between automatic page and manual page breaks. Removing all page breaks. Quickly adding many page breaks. Episode 334 shows it all.
posted by Bill at 9:00 AM
If you are using Excel 2003, use the new Watch Window tool to watch the values of far-away cells. Episode 333 shows you how.
posted by Bill at 9:00 AM
Keep an eye on some distant far-off cells. Rather than scroll back and forth between your input cells and the the result cells, use a picture link to see those far-away cells. Episode 332 shows you how.
posted by Bill at 9:00 AM
What if the top section of your worksheet has column widths that don't line up with the bottom section of your worksheet? Episode 331 shows how to overcome this problem.
posted by Bill at 9:00 AM
