MrExcel Excel Videos

Nancy sends in a cool tip to solve some of the frustrations from Episode 875 -- Excel changing the column widths of a pivot table as you choose new values from a page field. In Episode 887, I will take a look at how to solve this problem. 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!

Mario sends in today's question. He has to do a SUMIF on a non-contiguous section of data. SUMIF can not handle this, but SUMPRODUCT can. Episode 886 shows you how.

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.