MrExcel Excel Videos

Chuck sends in a great question about charts that use a time-series along the x-axis. Chuck has weekly data. The default chart in Excel 2003 is ugly. Excel makes the columns ultra-thin in the chart. Chuck has one workaround, but his manager doesn't approve. In Episode 885, a workaround, then the real solution, and a bonus tip about widening the columns in a chart.

Robert asks how he can combine an HLOOKUP and a VLOOKUP together into a single formula. This is a common problem, but you don't use either VLOOKUP or HLOOKUP. Instead, Episode 884 will introduce a function called MATCH. This obscure but versatile function is similar to both VLOOKUP and HLOOKUP. Episode 884 shows you how to solve this problem.

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!