MrExcel Excel Videos

Tamir asks if you can add labels between columns in a chart. Episode 956 shows a tricky way to solve this. 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!

Kambiz sends in a question today that is far more difficult than the example from podcast 668. Kambiz needs running diagonal totals. In Episode 669, we take a look at Chips formula from Episode 668 and figure out how to modify it to solve this tricky 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!

Today, we look at how to total a data set diagonally. Episode 668 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!

Mustafa asks a question of how to see the totals from only the visible rows in a filtered data set. There is an easy way to do this, but it is not completely obvious. Episode 667 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!

Rodney asks how Excel can make a clustered column chart. While it is not immediately obvious, it is relatively easy to do. Episode 666 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 todays netcast, I will show you how to use a simple loop and some recorded macro code to pull all of the data from many web pages. Episode 665 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!

When you paste web data to Excel, many hyperlinks are created. In todays episode, I create a couple of lines of code to extract all of the links and write them to a new column in Excel. Episode 664 also shows you how to use the Watch Window to discover property names. 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!

When you copy data from a web page and paste into Excel, you often end up with a whole series of tiny graphical icons. Rather than deleting those one at a time, Episode 663 will show you how to get rid of many objects at once. 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. I said it. SumProduct. Some of my friends in the U.K. seminars asked why I NEVER talk about SumProduct. And there is a really simple, but really stupid reason for it. I missed that day in Excel class. SumProduct simply was not in my arsenal of tools, and so I find myself writing complex array formulas when a SumProduct would do the trick. In todays Episode 662, we take a look at how to convert yesterdays array formulas to SUMPRODUCT 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!