MrExcel Excel Videos

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!

Jeff from MA writes with todays question; creating a conditional sum array formula that uses OR functions instead of AND functions. Episode 661 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!

Paul from Ontario asks how to create a timesheet dropdown showing all of the weeks ending on Sunday. Episode 660 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!

Greg from Indiana sends in a great mystery today. He removed some borders and somehow the gridlines were removed as well. Well take a look at the pain someone must have went through, when the solution is right in the paint bucket dropdown. Episode 659 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!

Andy wonders why the COUNT function doesn't count text entries. Episode 955 will show you how to overcome this with COUNTA. 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!