MrExcel Excel Videos

Ute from Germany sends in a better way to show negative points in a column chart in a red color. His cool trick works for Excel 97-2003. Episode 674 will show you how. This blog is the video 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!

Hamideh sends in an interesting question. He set up a really cool custom number format to prevent people from having to enter 4 dashes in a part number. However... now Find appears not to work. In Episode 673, I will show you the hidden setting to assist with the Find. This blog is the video 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!

How can you do a VLOOKUP from one worksheet to another worksheet? It is simple to do, but hard to remember the syntax. In Episode 672, I'll show you the easy way to enter these formulas. This blog is the video 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!

How can you change names to proper case, with the first letter of each name capitalized? Episode 671 shows you a few different ways to solve this problem. This blog is the video 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!

OK. Yes. Sorry. I spent two days on insanely hard formulas. Thanks for the letters, phone calls, and e-mails. There is a simple way to total five cells diagonally. Episode 670 shows you how. This blog is the video 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!

Justin asks how to hide columns in Excel 2007. Finding the command on the 2007 ribbon is a little tough, but Episode 689 shows a way to invoke any Excel 2003 command in Excel 2007. This blog is the video 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!

Calculate the last day of this month, using a new trick sent in by Bob. Episode 688 shows you how. This blog is the video 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!

Microsoft hides some of the VBA controls in Excel 2007. Episode 687 will show you how to access the Developer tab in the Excel 2007 ribbon. This blog is the video 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!

Ari sends in a better solution to podcast 677. If you want to prevent text from long cells spilling over to adjacent blank cells, the technique shown in Episode 686 works like a charm. This method might even clean up spills faster than Bounty... This blog is the video 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!