Results for: learn excel Search Results
Family Filter:
3:07
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. This video podcast is the companion to the book, Learn Excel 97-2007 from MrExcel.
9 Feb 2009
322
Share Video

3:01
Jan asks if it is possible to shade half of a cell. Episode 905 shows one cumbersome way to do it . This podcast is the video companion to the book, Learn Excel 97-2007 from MrExcel.
26 Aug 2009
2082
Share Video

3:53
Take mailing list data from Microsoft Excel and produce labels in Word. Episode 906 will show you how. Watch a new two minute video every workday to learn one of the 377 tips from the book Learn Excel 97-2007 from MrExcel.
9 Jul 2009
656
Share Video

3:40
As you approach year end, you might want to calculate compound growth rates. Episode 908 will show you how. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.
12 Sep 2009
1258
Share Video

3:15
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. This video is a companion to the book Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
4 Dec 2009
695
Share Video

2:03
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. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.Download a new two minute video every workday to learn one of the 377 tips from the book!
31 Dec 2008
940
Share Video

3:52
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. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
27 Dec 2008
1173
Share Video

4:38
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. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.
12 Jul 2010
531
Share Video

2:36
Add a picture as a background for a chart in Excel 2007. Episode 917 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
16 Aug 2009
512
Share Video

2:50
Changing the chart background in Excel 2003. Episode 918 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
11 Aug 2010
446
Share Video

1:59
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. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
29 Jan 2009
563
Share Video

2:19
As you switch to Excel 2007 and try to find things on the new Ribbon, look for the tiny dialog launcher icons to take you back to the old Excel 2003 dialogs. Episode 920 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
2 Jan 2009
1797
Share Video

2:33
Change the default number of worksheets in a new workbook using Excel 2007. Episode 921 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
7 Jan 2009
1247
Share Video

1:32
Add an icon set to a range in Excel 2007. Episode 922 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
21 Jun 2009
791
Share Video

2:04
The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
7 Jan 2009
333
Share Video

2:11
Adjust the ranges used by the icon sets. Episode 924 will show you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
8 Jan 2009
353
Share Video