Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Jamie from Hampshire UK offers a better way for hiding data in cells. Rather than changing the font color to white, you can use this custom number format. Episode 919 shows you how.
Labels: Formatting
posted by Bill at 9:00 AM
Changing the chart background in Excel 2003. Episode 918 shows you how.
Labels: charting
posted by Bill at 9:00 AM
Add a picture as a background for a chart in Excel 2007. Episode 917 shows you how.
Labels: charting, Excel 2007
posted by Bill at 9:00 AM
The day after Christmas and you are at work? Or just checking out the podcast on your new iPod? Let's do a social networking experiment. Plus...how to autonumber rows. And...a podcast special at the MrExcel store. Watch it all in Episode 916.
Labels: formula
posted by Bill at 9:00 AM
Chuck has a spreadsheet where he has bolded the client name in a dozen cells. Unfortunately, only a portion of the cell is bolded and not the whole cell. The Excel 2007 Edit-Replace can not deal with this and changes the entire cell to bold. Episode 915 will show you a solution.
Labels: Formatting, replace
posted by Bill at 9:00 AM
Jack from Boston sends in a cool Windows trick to change the color of the selected cells. You would this this would solve the problem in Episode 907, but it doesn't. Still, you can watch Episode 914 to see how to enhance Excel 2003 and earlier.
Labels: color
posted by Bill at 9:00 AM
Yesterday, I talked about Jason's request to format a grouped pivot field in the row area of a pivot table. There is a solution, but it requires a bit of work in the original data set. Episode 913 will show you about the TEXT function and the other type of VLOOKUP.
Labels: Pivot Table
posted by Bill at 9:00 AM
Jason from Texas asks about formatting percentages in a pivot table. I thought this would be an easy question, but Jason wants to format the grouped percentages in the row area of the pivot table. Episode 912 talks about grouping in a pivot table but doesn't come up with a good solution to the problem.
Labels: Grouping, Pivot Table
posted by Bill at 9:00 AM
Where is it Wednesday? A person in one of my seminars asked me about a feature missing from Excel 2007. While the feature sounded familiar, it was also missing from Excel 2003. In Episode 911, we will take a look at a faster way to start a formula using the mouse.
posted by Bill at 9:00 AM
Patrick has a tricky overtime calculation. Episode 910 will show how to calculate overtime for people who worked over 80 hours and to show a blank for people who worked less than 80 hours.
Labels: IF
posted by Bill at 9:00 AM
Roseanne asks about the Scenario Manager in Excel. I hope that she will be able to use the Data Table discussed in Episode 794, because the Scenario Manager is relatively very difficult to use. Episode 909 will show you how.
Labels: Scenarios
posted by Bill at 9:00 AM
As you approach year end, you might want to calculate compound growth rates. Episode 908 will show you how.
Labels: calculation
posted by Bill at 9:00 AM
One of the annoying things about Excel 2007 is that the color for selected sheets and cells is almost identical to the color for unselected sheets and cells. Harry from Culver-Stockton college suggests a simple solution for the tab color in Episode 907.
Labels: Excel 2007
posted by Bill at 9:00 AM
Take mailing list data from Excel and produce labels in Word. Episode 906 will show you how.
Labels: mail merge, Microsoft Word
posted by Bill at 9:00 AM
Jan asks if it is possible to shade half of a cell. Episode 905 shows one cumbersome way to do it .
Labels: autoshapes, format
posted by Bill at 9:00 AM
Mike from OK City asks how to delete all names in a workbook. In Episode 904, I will show you a way to delete all names or to delete only the invalid names.
Labels: VBA
posted by Bill at 9:00 AM
Beardless Rot wants to know how to sort filtered data so that the top 10 autofilter will show items high-to-low. Episode 903 will show you how.
Labels: AutoFilter, Data Analysis, Filter
posted by Bill at 9:00 AM
Calculate time difference and show the result as a decimal number of hours. Episode 902 will show you how.
Labels: formula
posted by Bill at 9:00 AM
Morne sends in a question about highlighting records that fall on a weekday. There are a couple of approaches. Episode 901 shows you how.
Labels: conditional formatting
posted by Bill at 9:00 AM
Continuing yesterday's discussion about minus minus, we'll take a look at using SUMPRODUCT vs the new Excel 2007 SUMIFS to solve the multiple conditional sum problem. Episode 900 shows you how.
Labels: formulas
posted by Bill at 9:00 AM
Kim asks about the minus minus in certain formulas. In Episode 899, I will break one of those formulas down and show exactly why people use the minus minus.
Labels: formula, SUMPRODUCT
posted by Bill at 9:00 AM
