MrExcel Excel Videos

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.

It is easy to create a custom theme in Excel 2007. This theme might contain custom colors, fonts, and effects. Episode 531 shows you how to define a theme and share it with others. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!

In Excel 2007, a theme is comprised of fonts, colors, and effects. Episode 530 helps to decode the information in the effects thumbnails. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!

Uma wants to create many worksheets in a new workbook that are named after values in range B2:B20. Episode 1072 shows a VBA macro that makes all of this possible. 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!