Internet Radio Podcast Directory Radio Playlists

By Keyword

By Location

By Genre

By Popularity
Trumix.com : Podcast : Technology : Computers

Learn Excel from MrExcel Video Podcast

Network:
Language: English
Category: Technology / Computers
Visit Website

-


RSS FeedView RSS | RSS FeedView in iTunes

Previous1 2 3 4 5 ...33 NEXT

Duel: Eval Text Formulas - 1149 - Learn Excel from MrExcel Video Podcast
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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 20 Nov 2009 14:00:00 GMT ]


Splitting a Word - 1148 - Learn Excel from MrExcel Video Podcast
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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 19 Nov 2009 14:00:00 GMT ]


Red Data Labels - 1147 - Learn Excel from MrExcel Podcast
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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 18 Nov 2009 14:00:00 GMT ]


Filling Blanks Uh-Oh - 1146 - Learn Excel from MrExcel Podcast
Mark 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 17 Nov 2009 14:00:00 GMT ]


Splitting Names - 1145 - Learn Excel from MrExcel Podcast
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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 16 Nov 2009 14:00:00 GMT ]


Duel: Unsorted VLOOKUP - 1144 - Learn Excel from MrExcel Podcast
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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 13 Nov 2009 14:00:00 GMT ]


Floating Quartile Chart - 1143 - Learn Excel from MrExcel Podcast
Michael 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 12 Nov 2009 14:00:00 GMT ]


[Color 53] - 1142 - Learn Excel from MrExcel Podcast
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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 11 Nov 2009 14:00:00 GMT ]


Divide Range by Range - 1141 - Learn Excel from MrExcel Podcast
Rob 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 10 Nov 2009 14:00:00 GMT ]


Avoid a Loop - 1140 - Learn Excel from MrExcel Podcast
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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 9 Nov 2009 14:00:00 GMT ]


Duel: Portugal - 1139 - Learn Excel from MrExcel Podcast
A 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 6 Nov 2009 14:00:00 GMT ]


TRIM VLOOKUP table - 1138 - Learn Excel from MrExcel Podcast
Rod 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 5 Nov 2009 14:00:00 GMT ]


Removing Hyperlinks - 1137 - Learn Excel from MrExcel Podcast
In 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 4 Nov 2009 14:00:00 GMT ]


AutoFilter Some - 1136 - Learn Excel from MrExcel Podcast
Mary 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 3 Nov 2009 14:00:00 GMT ]


Embedding Lookup - 1135 - Learn Excel from MrExcel Podcast
Nick 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 2 Nov 2009 14:00:00 GMT ]


Duel: Index:Index - 1134 - Learn Excel from MrExcel Podcast
Today'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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 30 Oct 2009 13:00:00 GMT ]


ADM Calculation - 1133 - Learn Excel from MrExcel Podcast
Patricia 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 29 Oct 2009 13:00:00 GMT ]


Filling Quarters - 1132 - Learn Excel from MrExcel Podcast
The 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 28 Oct 2009 13:00:00 GMT ]


Increase Chart Font Size - 1131 - Learn Excel from MrExcel Podcast
Roger from Columbus Indiana passes along a cool trick for formatting all of the text in a chart at once. Episode 1131 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 27 Oct 2009 13:00:00 GMT ]


Sorta Indirect - 1130 - Learn Excel from MrExcel Podcast
Greg wants to set up dynamic validation, but he has a wrinkle....Once someone chooses from the first data set, he needs to append the word My before that answer to get to the name of the second data set. Episode 1130 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 26 Oct 2009 13:00:00 GMT ]


First Week of Month - 1129 - Learn Excel from MrExcel Podcast
A dueling podcast...how to find the first week of the month. Mike and Bill show you various ways in Episode 1129.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 23 Oct 2009 13:00:00 GMT ]


First Week of Month - 1129 - Learn Excel from MrExcel Podcast
A dueling podcast...how to find the first week of the month. Mike and Bill show you various ways in Episode 1129.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 23 Oct 2009 13:00:00 GMT ]


Love GetPivotData? - 1128 - Learn Excel from MrExcel Podcast
The last in my series of podcasts about GetPivotData. Today, we see how to use GetPivotData to overcome all the bad stuff in a pivot table. Episode 1128 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 22 Oct 2009 13:00:00 GMT ]


Love GetPivotData? - 1128 - Learn Excel from MrExcel Podcast
The last in my series of podcasts about GetPivotData. Today, we see how to use GetPivotData to overcome all the bad stuff in a pivot table. Episode 1128 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Thu, 22 Oct 2009 13:00:00 GMT ]


Understand GetPivotData - 1127 - Learn Excel from MrExcel Podcast
Rather than turn off the evil GetPivotData like we did yesterday, how about trying to understand what GetPivotData actually does? Episode 1127 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 21 Oct 2009 13:00:00 GMT ]


Understand GetPivotData - 1127 - Learn Excel from MrExcel Podcast
Rather than turn off the evil GetPivotData like we did yesterday, how about trying to understand what GetPivotData actually does? Episode 1127 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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Wed, 21 Oct 2009 13:00:00 GMT ]


Hate GetPivotData - 1126 - Learn Excel from MrExcel Podcast
99% of the people in my seminars hate GetPivotData. Most people outside of Microsoft hate GetPivotData. Today, in Episode 1126, as we've done before, we will take a look at how to turn off GetPivotData.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 20 Oct 2009 13:00:00 GMT ]


Hate GetPivotData - 1126 - Learn Excel from MrExcel Podcast
99% of the people in my seminars hate GetPivotData. Most people outside of Microsoft hate GetPivotData. Today, in Episode 1126, as we've done before, we will take a look at how to turn off GetPivotData.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Tue, 20 Oct 2009 13:00:00 GMT ]


HLOOKUP Week!? - 1125 - Learn Excel from MrExcel Podcast
Don't use HLOOKUP...just turn the table back to a vertical table using the two methods shown in Episode 1125.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Mon, 19 Oct 2009 13:00:00 GMT ]


Duel: 2-Way Lookup - 1124 - Learn Excel from MrExcel Podcast
Mike& Bill take a look at various ways to do a 2-way lookup in this dueling ExcelEpisode 1124.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!...

MORE... | LISTEN | DOWNLOAD | MOBILE DEVICE

[ Fri, 16 Oct 2009 13:00:00 GMT ]

Previous1 2 3 4 5 ...33 NEXT





O2 Arsenal Podcast
Sports
Listen to all the build-up ahead of Arsenal's next match with the O2 ARSENAL PODCAST!Dan Roebuck will bring you news, interviews and features before every Arsenal fixture - plus the chance to win great prizes in our exclusive competitions.

Happy House of Hentai
Arts
The weekly show for hentai news & reviews!

Ultima Thule Ambient Music Radio
Alternative
A weekly programme of ambient and atmospheric music from across the ages and around the world, broadcast on Australian public radio since 1989. Ultima Thule features a blend of ambient, trance, drone and chillout electronica, spacemusic, ancient, mediaeva

  Powered by PenguinRadio & PodcastDirectory.com  |  About Trumix  |  Terms of use  |  FAQs  |  Contact Us