Formatting

Episode 369 – AutoShape Text

               

Create cool headlines by adding text to your autoshape and then formatting it using the drawing toolbar. Episode 369 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!

Episode 357 – Date Differences

               

You have two dates in Excel and want to find the elapsed years and months. The solution is to use an ancient function from the days of Lotus 1-2-3. Episode 357 shows you how to use the function, as well as a cool formatting trick to show years and months in the same cell. This(…)

Episode 344 – Border Details

               

The complete guide to applying borders to a selection. Learn what all of those icons actually do on the borders tab. Episode 344 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(…)

Episode 343 – Double Underline

               

Tricks for adding a double underline to your cells. Episode 343 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!

Episode 342 – Without Borders

               

Do you get annoyed when you copy a formula and the borders get copied along with the formula? Episode 342 shows you a cool trick to prevent the borders from being copied as you extend a formula. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two(…)

Learn Excel from MrExcel