PodcastDirectory.com's listings of the Learn Excel from MrExcel Video Podcast Podcasts

ASTM E29 Rounding - 1046 - Learn Excel from MrExcel Podcast

If you have to round 0.5, do you think it should round to 0 or 1? I bet that you learned in school that it should round to 1. However, this will introduce errors.Episode 1046talks about the errors introduced by this rounding.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!

Listen | Listen in your iPhone | Download | View full cache |

After yesterday’s podcast about ASTM E29 rounding, I produce a function in VBA that will correctly do the bankers rounding algorithm in Excel.Episode 1047shows 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!

Listen | Listen in your iPhone | Download | View full cache |

The Excel fill handle is really cool with quarters. But wait....it cannot do quarters and years. But wait...it can do them but in a hideousformat.Episode 1132asks  -"Does anyone have a better way?"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!

Listen | Listen in your iPhone | Download | View full cache |

Patricia called the other day with a problem which will be familiar toeveryone who works in a public school district. The state pays theschool for every student who is enrolled on the magic date of October1. Given a start date and end date, how can you tell if the date is inthat range?Episode 1133shows 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!

Listen | Listen in your iPhone | Download | View full cache |

Today's Dueling Excel Podcast is a question sent in by Hassan. Hassanwants to enter a name and a through-month and then add up that person'ssales from January through the selected month. Mike and Bill showvarious methods inEpisode 1134.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!

Listen | Listen in your iPhone | Download | View full cache |

Nick asks how to do a pretty lengthy bonus calculation. It might be toocomplex for the Excel 2003 nested IF limit, so I decided to use therange version of VLOOKUP. But...as a twist, I embed the table right inthe formula.Episode 1135shows 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!

Listen | Listen in your iPhone | Download | View full cache |

Mary from Louisiana passes along a cool tip for applying AutoFilter dropdowns to a subset of your records.Episode 1136shows 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!

Listen | Listen in your iPhone | Download | View full cache |

InEpisode 1137, a cool way to remove all hyperlinks from a spreadsheet.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!

Listen | Listen in your iPhone | Download | View full cache |

Rod from Cincinati asks how to solve the problem of trailing spaces inthe lookup table. I had never tried it before, but you can apply a TRIMto the entire lookup table.Episode 1138shows 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!

Listen | Listen in your iPhone | Download | View full cache |

A viewer from Portugal sends in a question about finding which row contains the match.Episode 1139shows you a few ways to go!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!

Listen | Listen in your iPhone | Download | View full cache |

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

Listen | Listen in your iPhone | Download | View full cache |

Rob from Cambridge needs to divide nine cells by nine other cells and sum them up. InEpisode 1141, we look at an array formula to solve 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!

Listen | Listen in your iPhone | Download | View full cache |

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

Listen | Listen in your iPhone | Download | View full cache |

Michael from Kansas City asks how to build a floating quartile chart.Episode 1143shows 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!

Listen | Listen in your iPhone | Download | View full cache |

Martin from Sweden sends in a question about doing a range VLOOKUPwhere the lookup table is not sorted. Mike and Bill duel it out intoday'sEpisode 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!

Listen | Listen in your iPhone | Download | View full cache |

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

Listen | Listen in your iPhone | Download | View full cache |

Mark asks how to fill blanks in with the data from above. Now...ifyou've watched this podcast, you've seen the trick for this, but Mark'sdata has something preventing Go To Special Blanks from working! So -another way to go.Episode 1146shows 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!

Listen | Listen in your iPhone | Download | View full cache |

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

Listen | Listen in your iPhone | Download | View full cache |

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

Listen | Listen in your iPhone | Download | View full cache |

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

Listen | Listen in your iPhone | Download | View full cache |