Recent Videos RSS
| Videos with tag MrExcel | All | Novice | Advanced | Expert |
Add to FavoritesLearn Excel Episode 862: Color Preced...
Dan from Texas asks: is there a way to change the color of cells that are precedents of a particular formula. Use the technique in Episode 862 to quickly complete this task.read more »
| Level: any | Oct 08, 2008 | Votes: 0 | Dmytro Shteflyuk  |
0  |
Learn Excel Episode 861: Subtotal Ano...
The subtotal command is a fantastic time-saver, but it occasionally behaves erratically. In Episode 861, I will show two situations which can cause the subtotal command to whack out.read more »
| Level: any | Oct 08, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 860: Header Logo
Adding a company logo jpg to your worksheet header. Episode 860 shows how to add a header, and then poses a question about if your image is scaling in size as you add more data.read more »
| Level: any | Oct 03, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 859: Two Mysteries
Its two-for-the-price-of-one-Thursday (sounds like we need a new theme...). Question 1: When editing a long formula, the formula covers up adjacent cells, making it difficult to point to thos... read more »
| Level: any | Oct 03, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 858: WIIW - Copy ...
In our Where Is it Wednesday podcast, we go looking for a command that most people never would have been able to find in Excel 2003! If you want to send a perfect copy of a formatted spreadsh... read more »
| Level: any | Oct 03, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 857: Smaller Pivo...
Say that you have a pivot table and need to send the file via e-mail. Use the trick in Episode 857 to dramatically reduce the size of your Excel workbook.read more »
| Level: any | Oct 03, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 856: Print 2-Up
Is there any way to make Excel print 2 pages per physical sheet of paper? The answer is maybe...it all depends on your printer! Episode 856 shows you how.read more »
| Level: any | Oct 03, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 855: Dynamic Comm...
Sergiy asks if there is any way to have a cell comment or a validation input box reflect a value from a formula in a cell. I couldn't find a good solution, other than using VBA. Episode 855 s... read more »
| Level: any | Sep 27, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 854: VLOOKUP Below
Can the VLOOKUP return a value one row below the matched value? Episode 854 shows you how to achieve this result using two other functions.read more »
| Level: any | Sep 27, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
Learn Excel Episode 853: Preventing #N/A
You love VLOOKUPs, but you hate the #N/A error that results. In our Where is it Wednesday edition of the MrExcel podcast, I will show you two ways to prevent #N/A as the result of your VLOOKU... read more »
| Level: any | Sep 27, 2008 | Votes: 0 | Dmytro Shteflyuk |
0 |
