Learn Excel 2010 – “Conditional Diagonal Borders”: Podcast #1538

“Cross out the numbers…leave the Text”

Learn Excel 2010 – “Comparative Histogram Part II”: Podcast #1523

Create a visual Comparative Histogram without a Chart!

Dueling Excel – “Conditional Format +/- 15%”: Podcast #1509

A Duel to Conditionally Format End Values showing +/- 15%

“VLOOKUP Awesome Quick” by Bill Jelen

A First of It’s Kind, Brilliant, Media-Rich How-To in the realm of VLOOKUP!

Dueling Excel – “The Top 70%”: Podcast #1454

Find the Top 70% of Value, Not Quantity

Learn Excel 2010 – “Within 25% of Budget”: Podcast #1445

Use Conditional Formatting to warn when expenses are getting too close to budget!

Learn Excel 2010 – “Time 1 hour Ago?”: Podcast #1444

You can flag a cell if it is 1 hour late!

Learn Excel 2010 – “Conditional Format the Entire Row”: Podcast #1441

Highlight All Columns in your Data Set using Conditional Formatting.

Dueling Excel- “Price Beneath Lookup Value”: Podcast #1424

Conditional Formatting or Data Validation…? Which would work for you?

Dueling Excel – Data Bars: Podcast #1369

Dueling Excel takes a look at Creating Data Bars in a variety of ways in Excel 2010 and earlier.