|
|
 |
| Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup |
| See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to... |
Tags:
Excel, MATCH, INDEX, INDIRECT, Two, Way, lookup, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Duel, Dueling |
|
 |
| excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks |
| See how to use the excelisfun YouTube channel: 1) Search For Videos 2) Download Workbooks 3) Find Playlists With The Videos You Want! Excel How To... |
Tags:
Excel, 2007, 2003, 2010, excelisfun, Is, Fun, Learn, How, To, Mike, Gel, Girvin, Highline, Community, College, Formulas, Functions, Search, For, Videos, Download, Workbooks, Find, Playlists, tutorial, Advanced, Basic, Beginning, Intermediate, Formula, Function, Calculations, Data, Analysis |
|
 |
| Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA? |
| See Mr Excel and excelisfun lookup a picture in Excel. See a VBA solution and a Formula Solution using the INDIRECT function and named ranges. See... |
Tags:
Excel, Lookup, Picture, Formula, or, VBA, INDIRECT, function, VLOOKUP, How, do, use, to, retrieve, Database, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, in, using |
|
 |
| Mr Excel & excelisfun Trick 21: Excel 2010 Sparklines (Amazing Cell Charts!!) |
| See Mr Excel and excelisfun demonstrate Excel 2010 Sparklines! Sparklines are small cell charts that help to visualize data! Amazing Cell Charts!... |
Tags:
Excel, 2010, Sparklines, Small, Cell, Charts, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Skew, statistics, Distribution, not, Normal, Amazing |
|
 |
| excelisfun: How To Search For Excel Videos, Find Playlists and Download Workbooks 2012 YouTube |
| Learn how to: How To Search For Excel Videos, Find Playlists and Download Workbooks 2012 YouTube Mike excelisfun Girvin at Highline Community... |
Tags:
Slaying, Excel, Dragons, 2003, 2007, 2010, functions, array, formula, formatting, Date, time, calculations, data, analysis, charts, Pivot, Tables, excelisfun, Mike, Girvin, Highline, Community, College, VLOOKUP, IF, INDEX, MATCH, function, pivottables, SUMPRODUCT, SUMIF, COUNTIF, Count, Add, Sum, multiple, criteria, conditions, Absolute, Relative, Mixed, Cell, References, Worksheet, Workbook, Lookup, mrexcel, Mr, Bill, Jelen, Duel, Conditional, Validation, Business, Math, Statistics, Basics, Advanced, Finance |
|
 |
| Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? |
| See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA... |
Tags:
Excel, Reverse, Lookup, VBA, Macro, INDEX, MATCH, function, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Duel, Dueling |
|
 |
| Mr Excel & excelisfun Trick 96: LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type) |
| Download workbook: people.highline.edu See Mr Excel and excelisfun use two methods to lookup a column of sales amounts in order to create a single... |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Slaying, Dragons, lookup, column, of, sales, amounts, in, order, to, create, single, cell, formula, that, will, add, all, the, bonuses, Learn, many, tricks, function, SUM, and, SUMPRODUCT, functions, array |
|
 |
| Mr Excel & excelisfun Trick 16: Scroll Bar For Percentage |
| See Mr Excel and excel is fun create scroll bars that will control a percentage in a cell. Mr Excel will do an ActiveX Control and excelisfun will... |
Tags:
Excel, activex, Control, Form, Scroll, Bar, for, Percentage, In, Cell, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Duel, Dueling |
|
 |
| Mr Excel & excelisfun Trick 41: VBA or Formula Extract Prefix for VLOOKUP |
| See Mr Excel and excelisfun do VBA and an array formula to extract a varying length number prefix and then use that as the lookup_value for... |
Tags:
Excel, VBA, or, Formula, VLOOKUP, Extract, Varying, Length, Prefix, for, lookup_value, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, LEN, INDIRECT, ROW, MID, ISERROR, MATCH, LEFT, function |
|
 |
| excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more... |
| See how to use the excelisfun YouTube channel: 1) Search For Videos 2) Download Workbooks 3) Find Playlists With The Videos You Want! Excel How To... |
Tags:
Excel, 2007, 2003, 2010, excelisfun, Is, Fun, Learn, How, To, Mike, Girvin, Highline, Community, College, Formulas, Functions, Search, For, Videos, Download, Workbooks, Find, Playlists, pivottables, Pivot, Tables, Data, Analysis, Format, Cells, Math, Statistics, Basic, Advanced, Slaying, Dragons |
|
 |
| Excelisfunner & Mr Excel & Excelisfun Mr Trick 104: Truel With 5 Year old Exceler |
| Download workbook: people.highline.edu See 5 year old Isaac play around with Excel and the Mr Excel and excelisfun jump in too. Isaac has invented... |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Excelisfunner, Bill, Mr, Jelen, Mike, Girvin, Isaac, Highline, Community, College, Slaying, Dragons, Truel, With, Year, old |
|
 |
| Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methods |
| See Mr Excel and excelisfun add a range of values that is dynamic in two directions. The range of values to add changes depending on what you... |
Tags:
Excel, Dynamic, Range, for, Adding, SUM, OFFSET, MATCH, DATEVALUE, MONTH, INDEX, functions, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Delivers, Cell, Reference |
|
 |
| Mr Excel & excelisfun Trick 18: IF function with FIND SEARCH AND OR ISERROR & ISNUMBER functions |
| See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP all is one video! See Mr Excel and... |
Tags:
Excel, IF, AND, OR, ISNUMBER, ISERROR, FIND, SEARCH, VLOOKUP, REPLCE, functions, function, formula, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Duel, Dueling |
|
 |
| Mr Excel & excelisfun Trick 38: Weekly Report Formula or Pivot Table? |
| See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of... |
Tags:
Excel, First, Monday, in, Week, WEEKDAY, DAY, functions, TEXT, function, DATE, MONTH, YEAR, Pivot, Table, Group, Weekly, Summary, Report, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College |
|
 |
| Mr Excel & excelisfun Excel Trick #2: Decrease Values By 35% |
| See Mr Excel and excelisfun demonstrate two methods to subtract 35% from a column of values: Mr Excel: Create formula for remaining percentage (1 +... |
Tags:
Excel, Decrease, Values, By, 35%, Paste, Special, formula, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Duel, Dueling |
|
 |
| Mr Excel & excelisfun Trick 93: Watch Window: VBA or Watch Window |
| Download workbook: people.highline.edu See Mr Excel and excelisfun use two methods to create a Wacth Window |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Slaying, Dragons, Watch, Window:, VBA, or, Window |
|
 |
| Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format |
| 1. See Mr Excel and excelisfun try to take a database with repeat names of students with failing Grades and create a unique list of student names... |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Slaying, Dragons, database, with, repeat, names, of, students, failing, Grades, create, unique, list, student, that, shows, an, for, each, class, falls, into, Category, powerpivot, two, Helper, Column, Formulas, Pivot, Table, Custom, Number, formatting, default, setting, empty, cells, pivottable, Options |
|
 |
| Mr Excel & excelisfun Trick 106: LOOKUP Function in VisiCalc, Lotus and Excel |
| Download workbook: people.highline.edu See Mr Excel and excelisfun talk about LOOKUP in VisiCalc, Lotus and Excel |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Girvin, Highline, Community, College, Slaying, Dragons, LOOKUP, in, visicalc, Lotus, VLOOKUP, Week |
|
 |
| Mr Excel & excelisfun Trick 94: Lookup Data In Text String & Extract Data From Text String |
| Download workbook: people.highline.edu See Mr Excel and excelisfun use two methods to: 1. Lookup Data In Text String & Extract Data From... |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Slaying, Dragons, Lookup, Data, In, Text, String, Extract, From, order, to, list, tupe, of, Washing, Machine, and, Cubic, Feet, Functions, SEARCH, FIND, MID, IF, SUBSTITUTE, IFERROR, ISERROR, Custom, VBA, Function |
|
 |
| Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula |
| See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS,... |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Slaying, Dragons, Extract, Multiple, Records, Based, on, Two, Criteria, using, VBA, and, formulafunctions, SUM, VLOOKUP, ROWS, COLUMNS, function, See, non-array, formula, for, extracting, when, there, are |
|
 |
| Mr Excel & excelisfun Trick 37: Evalualte Text Math VBA, Excel 4 Macro Function, MoreFunc add-in? |
| See Mr Excel and excelisfun take math formulas stored as text and evaluate then using three methods: VBA, Excel 4 Macro Function or the MoreFunc... |
Tags:
Excel, Evalualte, Text, Math, formulas, VBA, morefunc, add-in, Macro, Function, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, global, universal, relative, Cell, Reference, in, Defined, Name, Formula |
|
 |
| Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Table |
| See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his lookup... |
Tags:
Excel, VLOOKUP, Approximate, Match, Unsorted, Table, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, SMALL, ROWS, LOOKUP, MIN, IF, INDEX, function |
|
 |
| Mr Excel & excelisfun Trick 103: Find Missing Numbers In A Series |
| Download workbook: people.highline.edu See Mr Excel and excelisfun use two formula methods to Find Missing Numbers In A Series: See Mr Excel use... |
Tags:
Excel, 2010, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Slaying, Dragons, Find, Missing, Numbers, In, Series, functions, IF, ISNA, VLOOKUP, ROW, SMALL, MAX, INDIRECT, MATCH, IFERROR |
|
 |
| Mr Excel & excelisfun Trick #4: Comparative Charts |
| See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked Column Chart 3) Trendline to predict future data values... |
Tags:
Excel, Bar, Stacked, Column, Trendline, charts, to, compare, data, values, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Duel, Dueling |
|
 |
| Mr Excel & excelisfun Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different Sheets |
| See Mr Excel and excelisfun do a 2 Criteria Lookup and Multiple Table Lookup From Different Sheets. Amazing Lookup Solution that: 1. Uses functions... |
Tags:
Excel, 2007, 2003, excelisfun, Bill, Mr, Jelen, Mike, Gel, Girvin, Highline, Community, College, Two, Criteria, Lookup, and, Multiple, Table, INDEX, INDIRECT, MATCH, functions, function, array, formula, non-array |
|
|
|
