MrExcel Excel Videos

Excel 2007 sports a massive grid. Take a tour of cell XFD1084576 to get a sense of just how big the new grid really is. Also: how to unlock the extra rows when you open your legacy workbooks in Excel. Episode 401 shows you how. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

It is a real pain to try to trace precedents that are on other worksheets or in other workbooks. Episode 400 shows some formula auditing tricks, including a trick to see all of the precedents on other worksheets. This is our 300th episode! 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.

Brett from Australia asks how to format a date to include the words Opening Balance so that he can do a VLOOKUP into a report. The format is easy, the VLOOKUP is tougher. Episode 1115 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!

You need $273 in cash. How many of each currency amount will you need? This Dueling Episode 1114 shows a few different ways to go. 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!

Med asks how to calculate Years, Months, Days between two dates. Episode 1113 discusses the elusive DATEDIF function. 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!

David asks why his total formulas are getting #VALUE errors. Episode 1112 shows this common problem and a solution. 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!

In Excel 2000-2003, if you open a menu and only see a third of the menu items, then you still have Adaptive Menus turned on. Learn why Microsoft included this half-baked feature and how you can turn it off in Episode 419. 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!

Excel 2007 adds new table intelligence that you can use in probably 90% of your worksheets. In Episode 418, learn how table functionality can easily apply greenbar formatting, autofilters, and more. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Sometimes you have a single column with several fields joined together. For example, you might have city, state, zip code in a single column. Episode 417 shows how to break this data into three columns using the Text to Columns command. 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!