'Girvin'
31 Metacafe Videos
-
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...
-
03:07
MrExcel's Learn Excel #966 - Reduce by 35% 09-Mar-09
Rated 3.79 324 Views 0 Comments
Another dual podcast as Bill Jelen and Mike Gel Girvin show you multiple ways to reduce a range by 35%. Shot in Seattle, Washington. Epis...
-
02:25
MrExcel's Learn Excel #982 - Sequence Column 30-Mar-09
Rated 3.41 327 Views 0 Comments
Mike Girvin wonders why Joe from Episode 977 doesn't just sort the data so that all the filtered records are together? You can do this if...
From MrExcel More How To, Science & Tech
-
06:17
MrExcel's Learn Excel #980 - Dueling: Wildcard Match 27-Mar-09
Rated 4.83 53 Views 0 Comments
Mike Girvin and Bill Jelen meet up again to offer three solutions to the problem of counting how many records match a wildcard criteria....
-
25:44
Highline Excel Class 20: Pivot Tables 20 Examples 13-Apr-09
Rated 4.33 87 Views 0 Comments Affiliate Video: YouTube
See these 20 PivotTable Pivot Table examples: 1 Proper Format 2 Understanding Pivot Tables 3 Drag & Drop in 2003 4 Change 2003 to 2007 5...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
04:49
Excel Magic Tricks # 1: Formulas & Cell References 05-Mar-08
Rated 4.48 1,332 Views 0 Comments Affiliate Video: YouTube
See Excel Magic! See how to build your spreadsheet smartly, so it updates automatically. See how to create formulas with cell references!
Affiliate Submitter: ExcelIsFun More Science & Tech
-
09:46
Excel Magic Trick #90: Consolidation 30-Jun-08
Rated 4.50 568 Views 0 Comments Affiliate Video: YouTube
See how to use the Consolidating feature in Excel. Summarize data from a number of different tables quickly using the Consolidation Featu...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
10:31
Excel Magic Trick 167p1 IF Function Formula: 12 Examples! 02-Dec-08
Rated 4.50 534 Views 0 Comments Affiliate Video: YouTube
Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different ex...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
10:47
Excel Lookup Series #13: INDEX & MATCH Functions Example 3! 01-May-08
Rated 4.50 452 Views 0 Comments Affiliate Video: YouTube
See how to use the INDEX & 3 MATCH functions in one formula to look up a value from 1 of 3 different tables! Also see how adding Names &...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
03:38
Excel Lookup Series #3: VLOOKUP Function 3rd Example 29-Apr-08
Rated 4.50 436 Views 0 Comments Affiliate Video: YouTube
See how to Use VLOOKUP to deliver a value to a formula. See how to deliver a late fee percentage to a formula using the VLOOKUP. In a for...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
10:15
You Tubers Love Excel #1: Dynamic Data Validation & OFFSET 01-Apr-08
Rated 4.50 276 Views 0 Comments Affiliate Video: YouTube
In this series of videos, You Tubers Ask ExcelIsFun Questions. See how to create a dynamic Data Validation Dropdown list that will update...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
09:03
Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates 19-Nov-08
Rated 4.50 175 Views 0 Comments Affiliate Video: YouTube
See how to take a value in a table and then return the row or column value when there are no duplicate values. See how to do a reverse tw...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
03:51
Excel Lookup Series #6: HLOOKUP Function 30-Apr-08
Rated 4.50 115 Views 0 Comments Affiliate Video: YouTube
See how to use the HLOOKUP function! We all know how to use VLOOKUP, but how do we use HLOOKUP? See how to use HLOOKUP in this video. In...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
10:51
YTLE#56: Excel Count Unique Values Greater Than $30 05-Jan-09
Rated 4.50 10 Views 0 Comments Affiliate Video: YouTube
See SUMPRODUCT and COUNTIF together in one amazing Array Formula from Aladin at the Mr Excel (mrexcel) Message Board. See the amazing log...
Affiliate Submitter: ExcelIsFun More Science & Tech
-
08:07
Excel Array Formula Series #1: Basics of Array Formulas 26-Jun-08
Rated 4.48 218 Views 0 Comments Affiliate Video: YouTube
See how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets...
Affiliate Submitter: ExcelIsFun More Science & Tech
Looking For Affiliate Videos...
