Mon, 31 May 2010
Patrick asks how Excel chooses to assign icons to values when you use the icon set feature. Episode 1208 explains how the icon sets work and how to change the default behavior. ...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, 27 May 2010
This problem is similar to episode 1206, but this time the question is how to highlight the entire row of the record with the largest value. Episode 1207 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, 26 May 2010
Today's Time Warp Wednesday Podcast: Secret Menu Items - Episode 104 will reveal how to unlock powerful menu items in Excel....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, 25 May 2010
How can you highlight the lowest value in each row? Episode 1206 shows you how. |
Mon, 24 May 2010
Create a Top 10 in a Pivot Table report where the grand total shows the total for all customers, not just the top 10....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, 20 May 2010
Solving the same problem from episode 1203, doing a VLOOKUP that matches two columns, but without using a concatenated key. This solution uses the OFFSET function to dynamically change the position of the lookup table. |
Wed, 19 May 2010
How can you do a lookup to find records that match 2 columns? Episode 1203 shows how to use a concatenated key to solve the 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! |
Tue, 18 May 2010
Bob from Kalamazoo shares a trick of how to fill a range of cells from 1 to 500000 in a couple of mouse clicks. Also, another way to have the fill handle work to fill 1, 2, 3. Episode 1202 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! |
Sat, 8 May 2010
Please be patient as we attempt to overcome the new 'codec' issues we've encountered with the older podcasts.
This episode is a test... Add new icons to your Excel toolbars. Access your frequently used commands with a single click of the toolbar. Episode 103 will show you how. |
Sat, 8 May 2010
Please be patient as we attempt to overcome the new 'codec' issues we've encountered with the older podcasts.This episode is a test... Move these two important toolbars back to occupying two rows so that you can see all of the icons and later add new icons. Episode 102 will show you how. |
Learn Excel from MrExcel Video Podcast
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
