• 1
03:12

# MrExcel's Learn Excel #981 - Paste Skip Blanks

## by MrExcel (04/01/09) 667 views

Gary sends in a clever solution for Episode 977 which uses the Skip...

• 2
03:20

# MrExcel's Learn Excel #988 - WIIW: Marker Fill

## by MrExcel (04/08/09) 307 views

While creating a scatter chart, Don is trying to change the marker ...

• 3
03:27

# MrExcel's Learn Excel #930 - QAT 2007

## by MrExcel (01/16/09) 301 views

It is frustrating that commands in Excel 2007 are spread out amongs...

• 4
02:13

# Count Visible Rows - 1034 - Learn Excel from MrExcel

## by MrExcel (06/11/09) 301 views

Isabel asks how to count only the visible entries in a range. =...

• 5
01:24

# MrExcel's Learn Excel #948 - Reverse Chart Axis

## by MrExcel (02/11/09) 290 views

Create a bar chart from a pivot table. If you sort the pivot table ...

• 6
03:45

# MrExcel's Learn Excel #936 - Paste the Total

## by MrExcel (01/26/09) 262 views

Pablo sends in a great question: why can't you copy a range of cell...

• 7
10:58

# Dueling : CountIf Range - 1100 - Learn Excel from MrExcel Podcast

## by MrExcel (09/14/09) 260 views

DRG asks how to use COUNTIF to find records that match a range. Unf...

• 8
02:11

# Multi-Column Find - 1044 - Learn Excel from MrExcel Podcast

## by MrExcel (06/25/09) 252 views

Isabel asks how to use Ctrl+F to find a row where three criteria ar...

• 9
01:47

# No-Header Sort - 1051 - Learn Excel from MrExcel Podcast

## by MrExcel (07/06/09) 243 views

Jeffrey wonders why the top row of his data wont sort. He has a bla...

• 10
02:12

# Learn Excel from MrExcel Episode 902 - Decimal Hours

## by MrExcel (12/10/08) 239 views

Calculate time difference and show the result as a decimal number o...

• 11
03:46

# Axel Font for Excel! - 1054 - Learn Excel Form MrExcel

## by MrExcel (07/09/09) 236 views

Erik Spiekerman has designed a font that is ideal for use in Excel....

• 12
03:15

# VLOOKUP External Workbook - 1082 - Learn Excel from MrExcel P...

## by MrExcel (08/18/09) 235 views

Shaun asks how he can link values in one worksheet to a lookup tabl...

• 13
02:47

# MrExcel's Learn Excel #986 - Rounding NOW()

## by MrExcel (04/06/09) 231 views

Many people use =NOW(), but it is frustrating when you try to calcu...

• 14
08:23

# Duel: Unsorted VLOOKUP - 1144 - Learn Excel from MrExcel Podcast

## by MrExcel (11/17/09) 225 views

Martin from Sweden sends in a question about doing a range VLOOKUP ...

• 15
04:03

# MrExcel's Learn Excel #996 - Center Across Selection

## by MrExcel (04/20/09) 220 views

Rich wonders why you can not center across selection vertically. Ep...

• 16
03:46

# MrExcel's Learn Excel #941 - Count Combinations

## by MrExcel (02/02/09) 217 views

Sergio from Mexico asks how to count unique combinations of two fie...

• 17
02:24

# 2010 Picture Tools - 1088 - Learn Excel from MrExcel Podcast

## by MrExcel (08/26/09) 214 views

Excel 2010 adds some new picture tools. Episode 1088 shows off some...

• 18
02:44

# MrExcel's Learn Excel #964 - Thu Mar 5, 2009

## by MrExcel (03/05/09) 213 views

I bet you thought that I screwed up and put the date of the podcast...

• 19
05:33

# Elapsed Days - 1018 - Learn Excel from MrExcel Podcast

## by MrExcel (05/20/09) 209 views

Figure out the number of billable days between two dates. Episode 1...

• 20
03:25

# MrExcel's Learn Excel #998 - Payoff Early

## by MrExcel (04/22/09) 208 views

Tom & Vicky ask about using Excel for basic household finance. Exce...