Data

Episode 731 – Copying Subtotals Only

               

Kerry asks: after adding automatic subtotals, how can you copy only the subtotal rows? Episode 731 will show 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!

Episode 599 – Text Box Length

               

Joe Marten sends in a better way to limit the number of characters entered in a cell. Episode 599 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! For(…)

Episode 544 – Rearranging all Columns

               

In yesterday’s podcast, I showed how to rearrange one column. But – what if you need to rearrange all of the columns? Episode 544 shows how to use a little known sorting trick to sort the columns back to the original sequence. This blog is the video podcast companion to the book, Learn Excel from(…)

Episode 472 – Quick Transpose

               

Do you need to turn data on its side in Excel 2007? PowerPoint MVP Kathy Jacobs shares her favorite new feature in Excel 2007. Episode 472 show you how.

Episode 461 – March Madness

               

You are invited on Monday to download MrExcel’s NCAA bracket and enter his free NCAA pool. The winner will get their choice of books from the MrExcel store. In today’s Episode 461, we will take a look at the Data – Validation commands used to make the NCAA bracket selection worksheet work. This blog is(…)

Learn Excel from MrExcel