Knowledge Education Videos

Someone put a bunch of mathematical calculations in column A as text and we want to evaluate those formulas. Mike and Bill provide dueling ways to solve this problem in Episode 1149. 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!

Dave talks with Scott LaFleur, botanical director of Garden In The Woods, about three different fall-blooming native plants, including a mildew-resistant phlox.

Want the look of brick -- or a pattern of your own design -- on your driveway or walkway, without the expense? It's called street printing, and this video shows you how it's done.

If you're growing vegetables like cabbage -- vegetables that leaf out close to the ground -- it can be difficult to weed near them. Learn about some of the tools that can help you remove weeds in hard-to-reach places.

Gary Vaynerchuk tastes some Thanksgiving picks with writer and blogger Tyler Colman (aka Dr Vino).

Corinne's favorite barret got ruined the other day, so this week she is going to show us how-to make a felt barret using the ancient technique of wet felting! Perfect for the colder months and would make a fantastic gift for someone this holiday season. Terri's Felting Lessons http://www.feltinglessons.com Website http://www.threadbanger.comBlog http://www.threadbanger.com/blogSubmit a Video to Us! http://www.threadbanger.com/submitTwitter http://twitter.com/threadbangerFacebook ...

Gary Vaynerchuk tastes some Thanksgiving picks with writer and blogger Tyler Colman (aka Dr Vino).

Ram asks how to split a word into individual letters, and then count how many times each letter appears. Episode 1148 shows 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!

http://www.FixMyRecipe.com

Wang asks how to change part of one data label to be red. Unfortunately, the label is then broken. A macro should solve this, but it does not. Episode 1147 discusses 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!

Diane from Michigan wants to split a column of names into two columns. Episode 1145 shows two approaches and the problems with each. 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!

Martin from Sweden sends in a question about doing a range VLOOKUP where the lookup table is not sorted. Mike and Bill duel it out in today's Episode 1144. 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!

Dave takes you on a tour of the Common Ground Fair, a celebration of rural living that promotes organically grown Maine produce and showcases beautiful Maine crafts and useful agricultural products.

Dave talks with fiber sculptor Susan Barrett Merrill about the process of turning wool into yarn and gets a live demonstration of the spinning wheel.

Gary Vaynerchuk is back to the Laid Back Friday couch, tasting some value 2007 Chateauneuf du Papes.

A cool way to streamline a VBA loop using SpecialCells. Episode 1140 shows 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!

Gary Vaynerchuk tackles another unheralded region in Italy.

You can specify up to eight colors in the custom number format box. But wait...you can actually do all 56 colors from the Excel 2003 color palette! Episode 1142 shows 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!

http://www.fixmyrecipe.com

California travel expert Veronica Hill learns how to become a fromagier in this episode of "CaliforniaTravelTips."