MrExcel Excel Videos

You need to chart two different orders of magnitude in a chart. I always end up creating a 2-axis combo chart, with a column series and a line series. Today in Episode 979, Bill writes in with a cool way to solve this problem with both series shown as columns. This video is the 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!

Cullen sends in today's Where Is It Wednesday question: how can you change the comment shape in Excel 2007? This was a cool feature in Excel 2003, we just can't find it anymore. Episode 978 shows you how. This video is the 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!

Joe asks if there is any way to do a Filtered Paste operation. I can't figure it out, so I had to resort to a macro. Check out Episode 977 and see if you have a better way. The code from this macro is available at: Pasting into a Filtered Data Set This video is the 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!

Laura from Wisconsin asks about changing the default Excel comment from light yellow to another color. While you can format an individual comment in Excel, the solution to this problem is in the control panel. Episode 976 shows you how. This video is the 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!

Awesome. There is a video on the 'net with Microsoft's Donald Farmer showing off a new add-in called Gemini. This is an amazing product. In Episode 975, I point out where you can get a sneak peak at Excel 2010 pivot tables in the Donald Farmer video. This video is the 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!

Debbie from Virginia asks about adding new calculations to the subtotal lines in a data set with subtotals. Episode 658 shows how to do this. 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!

Today we take a look at some nifty tricks in the Find dialog box. While I bet you will learn something along the way, the big problem is that we can not effectively select all of the results of Find All across multiple worksheets. So, to Norel from California who asked the question, we dont have a good answer, but for everyone else, you might find some cool tricks in Episode 657. 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!

Chris from Long Island asks how to conditionally format the negative items in a chart. Episode 656 shows two methods for handling this. 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!

Hiro asks how to build a pivot table to show year over year growth. Episode 655 will show you the cool grouping functionality in pivot tables which make this very easy. 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!