MrExcel Excel Videos

When you hide a row, Excel will remove that series from a chart. In Episode 609, I create a hideous chart, but then use an AutoFilter to create a cool ad-hoc charting tool that allows a sales manager to see results for any one sales rep. 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!

Learn how to quickly navigate worksheets. Episode 608 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!

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!