Learn Excel from Bill Jelen with this daily 2 minute video podcast.
In Episode 761, a look at three cool custom icons you can add to your toolbar in Excel 2007 or 2003. See how easy it is to use Select Current Region, Select Visible Cells, and Set Print Area.
Labels: Customizing, Formatting
posted by Bill at 9:00 AM
Joe asks about using custom autofilters with Excel. He can use a wildcard to find all of the cells that contain *abc*, but how about finding cells that do not contain “abc”? Episode 571 shows you how.
Labels: AutoFilter, Customizing
posted by Bill at 9:00 AM
Ryan from Schaumberg sends in a tip for improving Excel’s presentation of scientific notation. Episode 562 shows you how.
Labels: custom format, Customizing, format
posted by Bill at 9:00 AM
Rather than having to customize the color palette, Office 2007 offers 20 built-in color schemes. You can change the document theme in just a few clicks. Episode 529 shows you how.
Labels: 2007, color, Customizing
posted by Bill at 9:00 AM
Once you have a custom color palette set up in Excel, see how you can easily copy it to other existing workbooks. Episode 528 shows you how.
Labels: color, Customizing
posted by Bill at 9:00 AM
Excel 97 through Excel 2003 was limited to 56 colors, but you don’t have to keep the 56 colors that Microsoft chose. You can customize the colors for any workbook. Episode 526 shows you how.
Labels: color, Customizing
posted by Bill at 9:00 AM
If you have inherited a computer where someone has customized your toolbars, you might want to go back to the default, out-of-the-box set of toolbars. Episode 443 will show you how to reset your standard toolbar, the formatting toolbar, and your worksheet menu bar to undo any rogue customizations.
Labels: Customizing
posted by Bill at 9:00 AM
Sure, Excel can fill in the months of the year. It can fill in the days of the week. It can fill in 1st period, 2nd period, 3rd period. But - what if YOU need to fill in something else? Perhaps a list of departments, customers, co-workers, accounts??? Excel is up to the task. Epsiode 432 will show you how to set up a custom list so that the fill handle can fill in the flavors of bagels from your local coffee shop.
Labels: Customizing, List
posted by Bill at 9:00 AM
Starting on Tuesdays and Thursdays, I will be taking a look at the new features in Excel 2007. Today, an introduction to the ribbon and the options to minimize the ribbon. Episode 391 shows you the details.
Labels: Customizing, Excel 2007, Ribbon
posted by Bill at 9:00 AM
Jim from Montreal calls in today to ask if there is any way to change the grey background lurking behind your workbooks in Excel. While there is a setting that will adjust this background, it also annoyingly changes many other items as well. Episode 390 shows you how.
Labels: Customizing, Workbooks
posted by Bill at 9:00 AM
When you have created automatic subtotals and want to format the subtotals rows, you will probably be visiting the Edit - Goto - Special - Visible Cells only setting. However, by customizing your toolbar, you can select the subtotals using a single button click. Episode 376 shows you how. Also - see how to move buttons on a toolbar without displaying the customize dialog.
Labels: Customizing, GoTo Special, Subtotals, toolbar
posted by Bill at 9:00 PM
Once you have customized a chart, add the chart to your library of user defined charts. You can then apply all of that chart formatting to a new chart with a single keystroke! Episode 372 shows you how.
Labels: chart, custom format, Customizing, shortcuts
posted by Bill at 9:00 AM
