MrExcel Excel Videos

Chris from Long Island asks how to conditionally format the negative items in a chart. Episode 656 shows two methods for handling this. 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!

Hiro asks how to build a pivot table to show year over year growth. Episode 655 will show you the cool grouping functionality in pivot tables which make this very easy. 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!

There. Ive said it. Let me say it again The Ribbon is Cool. Wow. I havent heard anyone actually say that. We dont adjust well to change and the ribbon is completely new. Yes it is maddening at first, but they really used the Customer Experience Improvement Program data to find those commands that are really popular yet were hidden deep with the Excel 2003 menu. Lets face it how many amazing commands in Excel 2003 were hidden deep behind flyout menus and obscure dialog boxes. In Episode 654, I will take a look at some of the improvements in Excel 2007s ribbon interface. 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...

Do you have a manager whos eyes glaze over when presented with a column of numbers? Excel 2007 offers some new amazing data visualizations. Episode 653 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!

Excel 2007 offers new pivot table functionality. Episode 652 shows you the details. 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!

Excel 2007 offers a fantastic new way to remove duplicates from your data set. Episode 651 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!

In Episode 650, I take a look at the new functionality for Filters 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!

You may have seen how to create a spearing or 3-D formula such as =SUM(Jan:Dec!B3). In Episode 974, an amazing way to create a 3D reference to non-contiguous sheets. 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!

A question from YouTube asks how to write a macro to cut selected rows to Sheet2, adding a completion date. Episode 973 shows you how to write this short macro. 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!