MrExcel Excel Videos

My favorite Excel trick is to double-click the fill handle to copy a formula down to all of your rows of data. In Episode 607, Ill take a look at many different details of the double-click trick. 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!

To create a true histogram from frequency information, you need to make the columns in the chart touch each other. This was difficult to do in Excel 2003 but much easier in Excel 2007. Episode 606 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!

Creating a Frequency Distribution with the FREQUENCY function is fairly difficult. In Episode 605, Ill show you how to quickly produce a frequency distribution using a pivot table. 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!

Do you have a chart which is too confusing? Try replacing the one chart with four smaller charts, each chart focusing on one particular statistic. Episode 604 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!

Add new worksheets in seconds. Episode 603 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!

Rod asks how to set up a summary worksheet that will selectively point to different worksheets. The solution is the INDIRECT function in combination with some other functions. Episode 602 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, in the VBA editor, you accidentally undock the properties window, it is nearly impossible to redock it. Episode 601 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!

I wonder if there is a mile-high club for podcasting? This episode was taped at 30,000 feet above the Microsoft campus. To celebrate our 500th episode, Bill makes a special offer for you today. Episode 600 has the details.

When you declare a range as a table in Excel 2007, any calculations entered to the right of the table are automatically copied throughout the table. Episode 987 talks about how to solve this problem. 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!