Publish date:08-06-2010 06:00:00
Right-click the orange icon and click 'Copy the Link Location' (Firefox) or 'Copy Shortcut' (IE). Then paste it into your Podcatcher
Learn Excel from MrExcel Video Podcast
VBA & Macros 2010: Never AutoSum - Podcast #1219
Media Player
File Size: 16.8 MB Download

When you are recording a macro, never use the AutoSum button. Episode #1219 will show you the workaround to summing a column in a macro.

...This episode is the video podcast companion to the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

Learn Excel from MrExcel Video Podcast 's Offers
 http://www.mrexcel.com
Archived Episodes
Publish Date: 08-05-2010 03:25:09
File Size: 7.8 MB    Click the Speaker to listen to or view this podcast   Download Media File  

From October, 2005. Podcast #108: 'Freeze Headings' - Scroll down multiple pages and still see the column headings at the top of your worksheet. Episode 108 will show you how.

Time Warp Wednesday is our "Thank You" to everyone who has emailed, called or posted at the MrExcel Message Board!! Enjoy!!

...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!

 

Publish Date: 08-05-2010 03:09:00
File Size: 10.5 MB    Click the Speaker to listen to or view this podcast   Download Media File  

As you start to use the Excel 2010 ribbon, you will notice that it has a different arrangement of icons depending on the resolution of your monitor. This can lead to some confusion as you try to help your coworkers over the phone. 

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

 

Publish Date: 08-02-2010 12:29:25
File Size: 18.1 MB    Click the Speaker to listen to or view this podcast   Download Media File  

PowerPivot will not automatically sort your months into custom list sequence, which means that you will get month names arranged in alphabetical sequence of April, August, and so on. Episode #1217 shows the eight-click workaround.

…This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

 

Publish Date: 07-30-2010 12:42:00
File Size: 14.8 MB    Click the Speaker to listen to or view this podcast   Download Media File  

In Chapter 2 of "PowerPivot For The Data Analyst", you will see how to import a 1.8 million row text file into the PowerPivot window.

...This episode is the video podcast companion to the book, "PowerPivot For The Data Analyst: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

 

Publish Date: 07-29-2010 12:37:00
File Size: 12.7 MB    Click the Speaker to listen to or view this podcast   Download Media File  

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

One of the best features of Excel 2010's Backstage View is the Recently Used File List. This episode takes a look at the ins and outs of the Recently Used File list.

 

Publish Date: 07-28-2010 18:59:23
File Size: 9.7 MB    Click the Speaker to listen to or view this podcast   Download Media File  

From October, 2005. Podcast #107 shows you how to change the direction of the cursor to match data keying - Move from cell to cell in the same direction as your data entry.

Time Warp Wednesday is our "Thank You" to everyone who has emailed, called or posted at the MrExcel Message Board!! Enjoy!!

...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!

 

Publish Date: 07-28-2010 12:43:00
File Size: 15.7 MB    Click the Speaker to listen to or view this podcast   Download Media File  

PowerPivot is a free download that you can easily add to Excel 2010. It is the best product to come out of Microsoft in twenty years. Learn about the Five Main Benefits of PowerPivot with Excel 2010 from Bill Jelen a.k.a. "MrExcel".

...This episode is the video podcast companion to the book, "PowerPivot For Data Analysts: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

 

Publish Date: 07-27-2010 12:11:06
File Size: 8.7 MB    Click the Speaker to listen to or view this podcast   Download Media File  

An answer to the question from Podcast 1209; how do you prevent the F1 key from opening Excel help. This episode shows two 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!

 

Publish Date: 07-26-2010 14:47:03
File Size: 1.1 MB    Click the Speaker to listen to or view this podcast   Download Media File  

Clive provides a great tip for filling years and quarters using the Fill Handle. Episode 1212 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!

 

Publish Date: 06-16-2010 03:00:00
File Size: 6.9 MB    Click the Speaker to listen to or view this podcast   Download Media File  

Open Multiple Files with a Single Click. Do you always have to open the A/R file every time you open the invoice file? Group them in a workspace so you can open them together. Episode 106 will show 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!

 

Publish Date: 06-04-2010 03:00:00
File Size: 27.1 MB    Click the Speaker to listen to or view this podcast   Download Media File  

Eric writes in with a frustrating question; "Why can't the macro recorder record the action of creating a pivot table? No matter what I do, it hardcodes that the original pivot data is 469 rows tall." Eric doesn't want to learn VBA, but needs enough to be able to generalize the recorded code. Episode 1211 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!

 

Publish Date: 06-03-2010 03:00:00
File Size: 6.4 MB    Click the Speaker to listen to or view this podcast   Download Media File  


Denise from Orlando checks in with a cool trick for converting text to numbers using the minus minus trick. Episode 1210 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!

 

Publish Date: 06-02-2010 03:00:00
File Size: 8.1 MB    Click the Speaker to listen to or view this podcast   Download Media File  


Double the Power of the Recently Used File List. Episode 105 will teach you an easy customization to improve the recently used file list 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!

 

Publish Date: 06-01-2010 03:00:00
File Size: 17.7 MB    Click the Speaker to listen to or view this podcast   Download Media File  
​
Alternate shortcut keys....other ways to undo. Other ways to copy and paste. How to edit a cell comment. How to insert a new worksheet. And, a quest...how to assign F1 to do F2. Episode 1209 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!

 

Publish Date: 05-31-2010 03:00:00
File Size: 11.7 MB    Click the Speaker to listen to or view this podcast   Download Media File  

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!

 

Publish Date: 05-27-2010 03:00:00
File Size: 9.6 MB    Click the Speaker to listen to or view this podcast   Download Media File  

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!

 

Publish Date: 05-26-2010 03:00:00
File Size: 8.4 MB    Click the Speaker to listen to or view this podcast   Download Media File  
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!

 

Publish Date: 05-25-2010 03:00:00
File Size: 11.3 MB    Click the Speaker to listen to or view this podcast   Download Media File  

How can you highlight the lowest value in each row? Episode 1206 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!

 

Publish Date: 05-24-2010 03:00:00
File Size: 8.3 MB    Click the Speaker to listen to or view this podcast   Download Media File  
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!

 

Publish Date: 05-20-2010 02:30:00
File Size: 16.6 MB    Click the Speaker to listen to or view this podcast   Download Media File  

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.
 
...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!

 

Publish Date: 05-19-2010 02:30:00
File Size: 8.5 MB    Click the Speaker to listen to or view this podcast   Download Media File  
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!

 

Publish Date: 05-18-2010 02:00:00
File Size: 6.4 MB    Click the Speaker to listen to or view this podcast   Download Media File  
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!

 

Publish Date: 05-08-2010 19:28:00
File Size: 10.9 MB    Click the Speaker to listen to or view this podcast   Download Media File  
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.

 

Publish Date: 05-08-2010 19:03:55
File Size: 18.6 MB    Click the Speaker to listen to or view this podcast   Download Media File  
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.