MrExcel Excel Videos

When you drag the fill handle, Excel offers an extremely useful AutoFill Options dropdown. Well, it is extremely useful UNLESS you really want to get rid of the dropdown so you can see the value in the next row, then the dropdown is really annoying! In Episode 510, you will learn how to control whether Excel will copy or fill the series so that you can turn this annoying icon off. 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!

Craig added an arrow to a line chart. Every time the data changes, the arrow needs to be repositioned. Episode 1092 shows how to add a dynamic XY series to redraw the arrow. 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!

Update: PeltierTech sells an add-in to easily create this chart and many variations: Peltier Tech Charts for Excel 3.0 Jeff from Akron asks how to create a column chart where two series are stacked, but a third series is clustered. Episode 1091 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 today's dueling Excel podcast, the question is how to delete all the records which contain either ski or swim. This requires multiple wildcards in a filter. Mike and Bill will compare various methods in Episode 1090. 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!

It became harder to exit Excel starting in Excel 2007. Episode 1089 takes a look at how to exit Excel 2010. 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 2010 adds some new picture tools. Episode 1088 shows off some of the cool tricks in Excel 2010. 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!

New in Excel 2010, stolen from OneNote 2007 - the ability to insert a screen clipping into your worksheet. Episode 1087 shows you the two ways to use this new functionality. 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!

More tricks with the Paste Options menu, this time with Live Preview. Episode 1086 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!

Rather than having to customize the color palette, Office 2007 offers 20 built-in color schemes. You can change the document theme in just a few clicks. Episode 529 shows you how. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!