 Primary Format :
Language :
Also Listed as:
City : State/Province : Country : Region : User Tags:
User Votes:
RSS Feed Website
People found this Podcast
Searching for:
View this Podcast on a Google Map. 

Text Only listing of Learn Excel from MrExcel Video Podcast Podcasts
Methings.com listings of Learn Excel from MrExcel Video Podcast Podcasts
If you like this podcast, you might also like:
|
View the full archive of Learn Excel from MrExcel Video Podcast
Watermark - 1151 - Learn Excel from MrExcel Video PodcastHow can you add a watermark behind your spreadsheet? It is not obvious, but Episode 1151 shows you a couple of methods.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 | Word DataBars - 1150 - Learn Excel from MrExcel Video PodcastIn Episode 1150, I wanted to add data bars to a series of words. Episode 1150 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!Listen | Listen in your iPhone | Download | View full cache | Duel: Eval Text Formulas - 1149 - Learn Excel from MrExcel Video PodcastSomeone 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!Listen | Listen in your iPhone | Download | View full cache | Splitting a Word - 1148 - Learn Excel from MrExcel Video PodcastRam 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!Listen | Listen in your iPhone | Download | View full cache | Red Data Labels - 1147 - Learn Excel from MrExcel PodcastWang 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!Listen | Listen in your iPhone | Download | View full cache | Filling Blanks Uh-Oh - 1146 - Learn Excel from MrExcel PodcastMark asks how to fill blanks in with the data from above. Now...if
you've watched this podcast, you've seen the trick for this, but Mark's
data has something preventing Go To Special Blanks from working! So -
another way to go. Episode 1146 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!Listen | Listen in your iPhone | Download | View full cache | Splitting Names - 1145 - Learn Excel from MrExcel PodcastDiane 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!Listen | Listen in your iPhone | Download | View full cache | Duel: Unsorted VLOOKUP - 1144 - Learn Excel from MrExcel PodcastMartin 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!Listen | Listen in your iPhone | Download | View full cache | Floating Quartile Chart - 1143 - Learn Excel from MrExcel PodcastMichael from Kansas City asks how to build a floating quartile chart. Episode 1143 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!Listen | Listen in your iPhone | Download | View full cache | [Color 53] - 1142 - Learn Excel from MrExcel PodcastYou 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!Listen | Listen in your iPhone | Download | View full cache | Divide Range by Range - 1141 - Learn Excel from MrExcel PodcastRob from Cambridge needs to divide nine cells by nine other cells and sum them up. In Episode 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 | Avoid a Loop - 1140 - Learn Excel from MrExcel PodcastA 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!Listen | Listen in your iPhone | Download | View full cache | Duel: Portugal - 1139 - Learn Excel from MrExcel PodcastA viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows 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 | TRIM VLOOKUP table - 1138 - Learn Excel from MrExcel PodcastRod from Cincinati asks how to solve the problem of trailing spaces in
the lookup table. I had never tried it before, but you can apply a TRIM
to the entire lookup table. Episode 1138 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!Listen | Listen in your iPhone | Download | View full cache | Removing Hyperlinks - 1137 - Learn Excel from MrExcel PodcastIn Episode 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 | AutoFilter Some - 1136 - Learn Excel from MrExcel PodcastMary from Louisiana passes along a cool tip for applying AutoFilter dropdowns to a subset of your records. Episode 1136 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!Listen | Listen in your iPhone | Download | View full cache | Embedding Lookup - 1135 - Learn Excel from MrExcel PodcastNick asks how to do a pretty lengthy bonus calculation. It might be too
complex for the Excel 2003 nested IF limit, so I decided to use the
range version of VLOOKUP. But...as a twist, I embed the table right in
the formula. Episode 1135 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!Listen | Listen in your iPhone | Download | View full cache | Duel: Index:Index - 1134 - Learn Excel from MrExcel PodcastToday's Dueling Excel Podcast is a question sent in by Hassan. Hassan
wants to enter a name and a through-month and then add up that person's
sales from January through the selected month. Mike and Bill show
various methods in Episode 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 | ADM Calculation - 1133 - Learn Excel from MrExcel PodcastPatricia called the other day with a problem which will be familiar to
everyone who works in a public school district. The state pays the
school for every student who is enrolled on the magic date of October
1. Given a start date and end date, how can you tell if the date is in
that range? Episode 1133 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 ... Listen | Listen in your iPhone | Download | View full cache | Filling Quarters - 1132 - Learn Excel from MrExcel PodcastThe Excel fill handle is really cool with quarters. But wait....it can
not do quarters and years. But wait...it can do them but in a hideous
format. Episode 1132 asks - "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 |
|