Excel

Curved Arrows – 1164 – Learn Excel from MrExcel Podcast

               

Brent asked me how I managed to draw a curved arrow on a worksheet. Episode 1164 takes a look at how to customize the drawing tools to draw in curved arrows. …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(…)

January Not = January – 1162 – Learn Excel from MrExcel Podcast

               

A simple MATCH formula is not working. In episode 1162, we wander through the Validation dialog, the Name Manager dialog, all trying to figure out why the MATCH formula is returning #N/A. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday(…)

VLOOKUP All Columns – 1161

               

Today’s dueling podcast question is how to return the sum of all columns from a VLOOKUP. Mike and Bill show you various methods in episode 1161.

Sheet Tabs – 1160 – Learn Excel from MrExcel

               

Riham asks if there is any way to arrange the sheet tabs in two rows. While there is not, Episode 1160 shows various ways of dealing with the issue. 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(…)

MrExcel’s Learn Excel #977 – Filtered Paste

               

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. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Learn Excel from MrExcel