Learn Excel 2010 – “Table Schmable, I Want Results!”: Podcast #1482

Steps in Resolving Frustrations with Formulas that point into Tables.

Dueling Excel – Dynamic Validation VLOOKUP: Podcast #1379

Dueling Excel uses Table Nomenclature for a Dynamic Validation List . . .

PowerPivot Calculated Columns: Podcast #1260

Calculated Columns in the PowerPivot 2010 Grid . . .

Excel in Depth – Charts, Extending Data: Podcast #1247

Don’t recreate last month’s chart – extend it! Read more . . .

Excel in Depth – Table Formulas: Podcast #1237

Excel 2010: Formulas automatically fill when you are using a table!

PowerPivot – Creating Relationships: Podcast #1229

Episode #1229 shows you how to manually define a relationship between two tables in PowerPivot.

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

Pivot SmartArt – 1184

Create a pivot table that drives a SmartArt diagram. Episode 1184 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!

Automatic Freeze Panes – 1094 – Learn Excel from MrExcel Podcast

Excel 2007 offers a cool trick to replace Freeze Panes. Episode 1094 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!

MrExcel’s Learn Excel #994 – Dynamic Charting II

In Episode 994, another solution to Ally’s problem of how to make a chart expand when you type new data in the worksheet. Today’s method shows an easier way to set up a dynamic chart range in Excel 2003 and newer.

This video is the 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!

MrExcel’s Learn Excel #937 – Dynamic Validation

I’ve talked about making the list for your data validation automatically grow with the list. In the past, I’ve used a macro or the OFFSET formula, but today Morne sends in a beautiful solution for either Excel 2003 or Excel 2007 to build a dynamic validation list. Episode 937 shows you how.

This video is the 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!