MrExcel Excel Videos

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!

Ben asks how he can automatically append a sequence number to duplicate values in his spreadsheet. Episode 537 shows how. 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!

Robbie calls in today to ask how to add a hyphen at an unknown position in each cell. For example, whenever Excel finds a period, add a dash. There are three solutions to this problem. Episode 536 compares them all. 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!

Mario writes in with a comment about Episode 507 on sorting text that looks like dates. No need to jump thru hoops to convert the data. In Episode 535 Mario suggests an easier way to sort by month. 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!

Kyle is trying to build a worksheet to create practice SAT tests for his students. His IF formula to mark answers as correct is working fine, but the COUNT function cant seem to count the correct answers. Episode 534 troubleshoots this function. 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!

Gary asks about converting text from lower case to upper case an vice versa. Episode 533 shows you how. 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!

Doug sends in a question today about managing his growing collection of netcasts. Instead of an Excel tip today, Episode 532 shows you how to set up a smart playlist of just your favorite Excel tips.