MrExcel Excel Videos

Bill Gates asked the question: The ribbon is fine, but there will be a classic mode, right?. The Office interface team convinced Bill that this was not the way to go. And, unfortunately, learning the new ribbon is the #1 complaint about Office 2007. Well, the folks at www.addintools.com did for you what Microsoft would not do, they brought the classic Excel 2003 menu bar, plus the standard and formatting toolbars back to Excel 2007. The add-in is perfect for someone who is trying to learn Excel 2007 in a pain-free manner and is now available at www.mrexcel.com. If you need a new feature, you can use the new ribbon tabs. But, if you need to use an item off the old menu, just stay right on the new Menu tab and find the menu exactly where...

To finish up the recent discussion of VLOOKUP, INDEX, MATCH, and OFFSET, todays episode talks about the strange situation where the data that you want is located to the left of the key field in the lookup table. Episode 487 will show you how to use VLOOKUP and MATCH to solve this problem. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

In todays podcast, we have hundreds of rows of VLOOKUP functions. Learn some tricks to make the entry of the third argument easier using a hidden row or the COLUMN function. Ultimately, though, after several iterations of VLOOKUP solutions, Episode 486 finally gets to the point of replacing VLOOKUP with MATCH and INDEX functions. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

These two functions allow you to dynamically point to a cell or a range. While they are often useless on their own, they can be used as arguments to another function. Episode 485 introduces these two functions. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

The VLOOKUP function is one of the most versatile functions in Excel you can use VLOOKUP to add item descriptions to a database containing item numbers. Episode 484 shows you how VLOOKUP works. This is the first in a series of podcasts to compare VLOOKUP with INDEX and MATCH. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

There is one week left to enter the current challenge of the month. In Episode 483, see this months challenge is how to calculate a blended commission rate. Take a look at the problem, send in your best solution, and well discuss the solutions in a podcast next week. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Today, Scott W sends in a better way to hide and unhide columns. After watching podcast 449, Scott sent in a suggestion that is much better than the typical Format Column Hide and Format Column Unhide methods. Episode 482 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

If you have a CSV file, you will always lose any leading zeroes when you open the file in Excel. This causes problems with zip codes and social security numbers. Episode 481 shows the non-Excel method for solving this problem. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

After importing data, your numbers and dates might be stored as text. While newer versions of Excel allow you to solve the numbers stored as text easily, the exclamation point dropdown never appears for the dates stored as text. Episode 480 takes a look at several methods for solving the problem. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn an Excel tip!