Text

Episode 414 – Joining Dates

               

If you try to use the concatenation character to join text with a date, you will not get the results that you expected. Episode 414 shows you how to modify the formula to properly format the date. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two(…)

Episode 413 – Mini Toolbar

               

Get quick access to all of the text formatting commands by moving your mouse towards the completely invisible mini toolbar! (Who at Microsoft comes up with this stuff?) Episode 413 shows you how to get the shy mini toolbar to appear. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles(…)

Episode 412 – Joining Text

               

How to join text from two columns using the concatenation character. Episode 412 shows you how to do concatenation, plus how to convert upper case to proper case on the fly. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn(…)

Episode 370 – AutoShape Formulas

               

Rather than static text in the AutoShape, use a formula to add dynamic text to an AutoShape. Episode 370 shows you how to create a shape that shows off the total of all sales made today. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute(…)

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!

Learn Excel from MrExcel