Fri, 30 October 2009 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! |
Thu, 29 October 2009 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! |
Wed, 28 October 2009 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! |
Tue, 27 October 2009 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! |
Mon, 26 October 2009 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! |
Fri, 23 October 2009 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! |
Thu, 22 October 2009 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! |
Wed, 21 October 2009 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! |
Tue, 20 October 2009 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! |
Mon, 19 October 2009 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! |
Fri, 16 October 2009 Mike & Bill take a look at various ways to do a 2-way lookup in this dueling Excel Episode 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! |
Thu, 15 October 2009 VLOOKUP week continues.... Today, you have to lookup an account number
and return the results from four columns in the lookup table. Episode 1123 shows you four possible solutions. 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! |
Learn Excel from MrExcel Video Podcast
Learn Excel from Bill Jelen with this daily 2 minute video podcast!
Bill Jelen
MrExcel Podcast Blog
Buy The Learn Excel Podcast DVD
Categories
podcastsArchives
JanuaryFebruary
March
April
May
June
July
August
September
October
November
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
May
June
July
August
September
October
November
December
Syndication
