'Learn Excel'
350 Metacafe Videos
-
05:47
Duel: Eval Text Formulas - 1149 - Learn Excel from MrExcel Video Podcast 20-Nov-09
Rated 3.16 121 Views 0 Comments
Someone put a bunch of mathematical calculations in column A as text and we want to evaluate those formulas. Mike and Bill provide duelin...
From MrExcel More How To, Science & Tech
-
04:28
Splitting a Word - 1148 - Learn Excel from MrExcel Video Podcast 19-Nov-09
Rated 3.18 108 Views 0 Comments
Ram asks how to split a word into individual letters, and then count how many times each letter appears. Episode 1148 shows you how. Thi...
From MrExcel More How To, Science & Tech
-
04:23
MrExcel's Learn Excel #984 - Snaking Columns 02-Apr-09
Rated 4.02 3,446 Views 1 Comments
You have a really long data set with all of the data in column A. When you print, you will be wasting 75% of the horizontal white space o...
-
07:53
Dueling: Up/Down Symbols - 1035 - Learn Excel from MrExcel 12-Jun-09
Rated 4.01 3,232 Views 1 Comments
Jonathan asks how to insert an Up/Down arrow as the result of an IF statement. In Dueling Excel Episode 1035, Bill and Mike show you a fe...
-
02:28
MrExcel's Learn Excel #974 - NonContiguous Spearing 19-Mar-09
Rated 4.02 2,183 Views 0 Comments
You may have seen how to create a spearing or 3-D formula such as =SUM(Jan:Dec!B3). In Episode 974, an amazing way to create a 3D referen...
-
06:45
MrExcel's Learn Excel #965 - Two-Way Lookup 07-Mar-09
Rated 4.01 2,253 Views 1 Comments
It is a game of Dueling Excel as Bill Jelen and Mike Gel Girvin bring you their own ways for doing two-way VLOOKUPS. Episode 965 shows yo...
-
02:43
Custom Zones - 1064 - Learn Excel from MrExcel Podcast 24-Jul-09
Rated 4.01 1,790 Views 0 Comments
In yesterday's netcast, I talked about using four zones in custom number formats for positive, negative, zero, and text. In Episode 1064,...
-
02:11
MrExcel's Learn Excel #925 - Partial Icon Set 09-Jan-09
Rated 4.00 1,512 Views 0 Comments
Apply icons only to the numbers that qualify for a red X. It is possible, but tricky. Episode 925 will show you how. This video is the p...
-
03:03
MrExcel's Learn Excel #929 - Data Consolidate 16-Jan-09
Rated 4.01 1,170 Views 0 Comments
Yet another solution to matching data from two different worksheets...the Data Consolidate command. Episode 929 shows you how. This vide...
-
02:19
Learn Excel from MrExcel Episode 920 - 2003 Dialogs 02-Jan-09
Rated 3.99 1,400 Views 0 Comments
As you switch to Excel 2007 and try to find things on the new Ribbon, look for the tiny dialog launcher icons to take you back to the old...
-
05:08
MrExcel's Learn Excel #928 - WIIW - Multiple Consolidation 18-Jan-09
Rated 4.01 926 Views 0 Comments
Another solution to matching data on two worksheets is the Multiple Consolidation Ranges option in the pivot table. Unfortunately, it is...
-
02:03
Learn Excel from MrExcel Episode 914 - Selection Color 24-Dec-08
Rated 4.01 499 Views 0 Comments
Jack from Boston sends in a cool Windows trick to change the color of the selected cells. You would this this would solve the problem in...
From MrExcel More How To, Science & Tech
-
02:26
MrExcel's Learn Excel #953 - Ctrl+N Compatibility Mode 18-Feb-09
Rated 4.01 455 Views 0 Comments
A question from Gary: Why does Excel 2007 open with only 65,536 rows? Wouldn't Microsoft want to show off the cool functionality availabl...
-
02:32
MrExcel's Learn Excel #921 - Workbook Sheets 07-Jan-09
Rated 3.98 708 Views 0 Comments
Change the default number of worksheets in a new workbook using Excel 2007. Episode 921 shows you how. This video is the podcast compani...
-
03:48
MrExcel's Learn Excel #927 - Pivot Compare 13-Jan-09
Rated 3.97 608 Views 0 Comments
Match two worksheets using a pivot table. We continue on this week with Jim's question about matching two worksheets with a common column...
Looking For Affiliate Videos...
Learn Excel Metacafe Channels
