Mon, 22 February 2010
Creating a dynamic tag cloud from a pivot table.
|
Fri, 12 February 2010
The MrExcel Podcast returns with a demo of how to mash up two data sets in PowerPivot. Episode 1178 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, 22 January 2010
Using PowerPivot for Excel 2010 to create asymmetric pivot tables. An asymmetric pivot table is where you want to report Budget for next year, but Actuals for this year. ...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, 21 January 2010
Erik asks how do deal with data where each record takes up three rows. Episode 1176 shows you how. This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book! |
Tue, 12 January 2010
A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode 1174 shows why and how to fix this problem forever. |
Tue, 12 January 2010
Paula asks how to take a range and turn it on its side. Episode 1173 shows you how. |
Fri, 8 January 2010
Today's dueling Excel podcast shows how to do a picture lookup in Excel. |
Thu, 7 January 2010
Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster. |
Wed, 6 January 2010
Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 takes a look at this mystery and the solution. This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book! |
Thu, 31 December 2009
Ahmed asks how to do a lookup that only looks at the text portion of the lookup value. Mike and Bill compare methods in this Dueling Excel Episode 1169. |
Wed, 30 December 2009
Khader asks how to concatenate three cells so that they appear on three lines in a new cell. Episode 1168 shows you how. |
Tue, 29 December 2009
Building on Teo's question from yesterday, Bill expands the technique to generate an array of 50 sequential numbers instead of typing that whole range out. Episode 1167 shows you how. |
Mon, 28 December 2009
Teo asks how to sum up the three largest values in a range. Episode 1166 shows you how. |
Thu, 24 December 2009
In today's dueling podcast, we need to look up a value in one of three different tables depending on the product selected. Mike and Bill show many ways to solve the problem in Episode 1165. |
Wed, 23 December 2009
Brent asked me how I managed to draw a curved arrow on a worksheet. Episode 1164 takes a look at how to customize the drawing tools to draw in curved arrows. |
Learn Excel from MrExcel Video Podcast (Vidcast)
Learn Excel from Bill Jelen with this daily 2 minute video podcast!
Bill Jelen
Buy The Learn Excel Podcast DVD
Categories
podcastsVidcast
general
Archives
FebruaryJanuary
December
November
October
September
August
May
April
March
February
January
December
November
October
September
August
July
June
May
April
March
February
January
December
November
October
June
April
April
March
February
January
Syndication
