MrExcel Excel Videos

Paul writes in with today's question. Is it possible to keep Excel 2003 and also install Excel 2007 on the same computer? In Episode 1081, I discuss this issue and show a cool way to export a chart as a graphic. 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 improvement in Excel 2010 is in the pivot table calculation options. You can now calculate the rank of an item, or the % of the parent row! Episode 1079 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 2010 finally gives you an option to fill in the blank spots in the outermost row fields. Episode 1078 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!

Office 2010 finally allows you to customize the ribbon. Episode 1077 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!

More features from the Excel 2010 technical preview: The Excel 2010 Backstage view replaced the old Office Icon for all of the things that you do to a document. Episode 1076 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!

LearnAccessByCrystal sends in a cool tip that will allow you to format dates to show quarters, weeks, and more. Episode 1074 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!

Sarah from the cattle farm in the UK writes in again with an insanely difficult question. Do a VLOOKUP, but find the last previous entry that matches the vehicle. Episode 1073 shows you a formula from Excel Gurus Gone Wild 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!

George would like to mail birthday cards to all of his customers. He has date of birth in his database, but unfortunately, comparing =TODAY() to a birthday in 1942 doesnt provide a lot of information. In Episode 539, we take a look at the DATE function used to solve this problem. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Peter sends in a question that relates back to Episode 444. In that podcast, I showed how to change the gap width in Excel 2003 to have two columns stacked on top of each other. Peter wonders how to do this in Excel 2007. This is a great opportunity to show off a change in Excel 2007s charting engine. While Excel 2003 required you to open and close the Format dialog box repeatedly, you can now format everything on the chart from the new modeless Format dialog box in Excel 2007. Episode 538 shows you how!