MrExcel Excel Videos

Shlomo sends in a great tip to solve the Cartesian coordinate numbering problem from last week's Episode 876. The solution involves the camera tool. In Episode 883, we will take a look at where Microsoft moved this tool in Excel 2007. 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!

Another way to solve the problem from podcast 881 is to create a pair of custom views. Episode 882 will discuss how you can quickly hide/unhide columns by using a custom view.

Tom from Cincinnati asks how to create a chart which can show either monthly or quarterly data. Episode 881 shows how to manually set up group and outline symbols to achieve the result.

Rick from Madison Alabama sends in a cool trick today. You can use your wheel mouse to quickly scroll from ribbon tab to ribbon tab in Excel 2007. Episode 880 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!

Excel 2007 offers a new visualization called an Icon Set. I usually hate this feature, because my numbers are right justified and the icons are left justified. However, in Episode 879, Joanna from Columbus, Ohio offers a cool tip to get the numbers and icons next to each other.

Can you use a function in an Excel calculated field? Well, Bryony from the U.K. says yes you can, and sure enough...it works. Episode 878 shows an example of using a function to create a new field in a pivot cache. Fairly cool. 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!

Seven ways to paste values in Excel. While I talk about many ways to convert formulas to values, Don from Orrville has come up with a method shorter than the other 6 methods I usually discuss. So...drumroll please... Episode 877 with method #7 for doing Paste Values!!! 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 is trying to label a Cartesian grid in Excel. This is a cool idea - Excel is really the world's largest sheet of graph paper, but the labels for the Cartesian grids aren't working well. In Episode 876, I explore the line tool on the drawing toolbar, the textbox tool, and the XY chart. Also a special deal on a book for your middle school students mentioned at the end of the podcast.

Neville from Germany sends in a good suggestion for overcoming pivot formatting problems from Episode 865. By using conditional formatting on the underlying worksheet, Neville comes up with a way to make sure that the total rows are always highlighted in a pivot table. Episode 875 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!