6:20
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 arra...
published: 06 Mar 2009
Author: ExcelIsFun
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 retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) excelisfun: Names, INDIRECT function and the Space Intersector Operator in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) YTL Excel #119: Amazing Lookup Solution! Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup Excel Name Trick #7: INDIRECT function, Names and LOOKUP Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup MrExcel's Learn Excel #965 - Two-Way Lookup Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH
10:09
Mr Excel & excelisfun Trick 109: Electoral College: PivotTable or Formulas
Download workbook: people.highline.edu See Mr Excel and excelisfun use two methods to extr...
published: 06 Jul 2012
Author: ExcelIsFun
Mr Excel & excelisfun Trick 109: Electoral College: PivotTable or Formulas
Download workbook: people.highline.edu See Mr Excel and excelisfun use two methods to extract records that sum to 270 points using a PivotTable or Formulas.
4:34
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks
See how to use the excelisfun YouTube channel: 1) Search For Videos 2) Download Workbooks ...
published: 22 Jun 2010
Author: ExcelIsFun
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 Videos Excel Videos Learn How To Use Excel Videos Excel Tutorial Videos Excel Formula Videos Excel Functions Videos Excel Pivot Tables PivotTables Videos Excel VLOOKUP Videos Videos About Excel
8:47
Mr Excel & excelisfun Trick 38: Weekly Report Formula or Pivot Table?
See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Report...
published: 27 Nov 2009
Author: ExcelIsFun
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 formulas. Learn about: 1.Formula for first Monday in Week using DAY and WEEKDAY functions and DATE, MONTH and YEAR functions 2.Formula to create Text label for Chart using TEXT function, Custom Number Format and the join symbol, Ampersand. 3.Create a Weekly Chart without Chart Junk. 4.Keyboard shortcut for default chart on sheet: Alt + F1 5.Pivot Table Grouped by Week 6.Line Chart and Column Chart for Weekly data
8:29
Mr Excel & excelisfun Trick #4: Comparative Charts
See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked ...
published: 03 Apr 2009
Author: ExcelIsFun
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 MrExcel's Learn Excel #985 - Dueling: Chart Types Excel Basics Chart Basics Highline Excel Class 05: Charts, Page Setup, Data Analysis
8:04
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, ISERRO...
published: 10 Jul 2009
Author: ExcelIsFun
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 excel is fun create an IF function formula that use the functions SEARCH, FIND, AND, OR, ISERROR and ISNUMBER to determine the TRUE or FALSE for the logical test! See the IF formula check to see if criteria is matched (or not matched) and then deposit text in the cell for a new column in a database. Also see the VLOOKUP nad REPLACE functions!
3:57
Mr Excel & excelisfun Trick 21: Excel 2010 Sparklines (Amazing Cell Charts!!)
See Mr Excel and excelisfun demonstrate Excel 2010 Sparklines! Sparklines are small cell c...
published: 31 Jul 2009
Author: ExcelIsFun
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! Great for Skew and Statistics.
13:27
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 re...
published: 23 Apr 2009
Author: ExcelIsFun
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 code (Macro) and excelisfun uses a formula with INDEX, IF, SMALL, MATCH, TEXT, CHAR and COLUMNS functions. INDEX and MATCH magic
2:43
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 value...
published: 09 Mar 2009
Author: ExcelIsFun
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 + decrease), copy remaining percentage, Paste Special, Operations Multiply, Values. Subtract 35% from a column of values. excelisfun: Create formula for remaining percentage (1 + decrease), create new column with formula (Original Price * remaining percentage) to calculate column of values that subtract 35%. MrExcel's Learn Excel #966 - Reduce by 35% YouTubersLoveExcel#16: Percent Number Formatting Tricks
5:20
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 thre...
published: 20 Nov 2009
Author: ExcelIsFun
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 add-in. See how to create a global universal relative Cell Reference in a Defined Name Formula.
10:21
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 f...
published: 02 Sep 2011
Author: ExcelIsFun
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, COLUMNS and more. See a non-array formula for extracting multiple records when there are two criteria.
6:34
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....
published: 25 Jun 2009
Author: ExcelIsFun
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 do a Form Control.
10:47
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 So...
published: 08 Jan 2010
Author: ExcelIsFun
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 many tricks in this video: 1.Data Validation List 2.Hiding Text with formatting 3.Named Ranges 4.Keyboard shortcut for Naming Create Name From Selection 5.Keyboard shortcut for Pasting a Name 6.Insert A Comment 7.Format a Comment (click outer edge) 8.Insert Picture in Comment 9.VLOOKUP 10.VBA to lookup a picture 11.Keyboard shortcut for VBA editor 12.Defined Name Formula 13.INDIRECT function to convert text that represents a reference into a reference 14.Put a formula in a picture 15.Paste Special Linked Picture (Camera Tool) 16.Checking Defined Name accuracy with Collapse Button 17.More How do I Lookup a Picture In Excel VLOOKUP Lookup picture in Database using Excel How do I use VLOOKUP to retrieve a picture
11:19
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 f...
published: 16 Sep 2011
Author: ExcelIsFun
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 that shows an "X" for each class that falls into a Class Category. 2. Mr Excel uses PowerPivot and excelisfun uses two Helper Column Formulas and a PivotTable. 3. Also learn about Custom Number formatting 4. Learn about default setting for empty cells in a Pivot Table using PivotTable Options Related Video Title: Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words Helper Column & PivotTable
Youtube results:
9:52
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...
published: 31 Dec 2009
Author: ExcelIsFun
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 VLOOKUP. See the functions: LEN, INDIRECT, ROW, MID, ISERROR, MATCH, LEFT and VLOOKUP.
5:44
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 ...
published: 09 Mar 2011
Author: ExcelIsFun
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 Videos Excel Videos Learn How To Use Excel Videos Excel Tutorial Videos Excel Formula Videos Excel Functions Videos Excel Pivot Tables PivotTables Videos Excel VLOOKUP Videos Videos About Excel
7:29
Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers
Download workbook: people.highline.edu See Mr Excel and excelisfun use three methods to ad...
published: 27 Apr 2012
Author: ExcelIsFun
Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers
Download workbook: people.highline.edu See Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length: 1. Formula with IF, LEFT and MID Functions and the join symbol ampersand: & 2. Formula with IF, LEFT and RIGHT Functions and the join symbol ampersand: & 3. TEXT, REPT, LEN, LEFT, IF and REPLACE Functions and the join symbol ampersand: & 4. See how to use the REPLACE Function to insert text into another test string (word or sentence in a cell)
5:12
Mr Excel & excelisfun Trick 11: Randomly Select A Name
See Mr Excel and excelisfun create a formula that will randomly select a name from a list ...
published: 21 May 2009
Author: ExcelIsFun
Mr Excel & excelisfun Trick 11: Randomly Select A Name
See Mr Excel and excelisfun create a formula that will randomly select a name from a list of names without having the list of names sitting in cells. See the functions INDEX, RANDBETWEEN, INT, RAND and see how to convert a list in cells (range) to a list that can be placed in a formula (array with array syntax). See how to store a list of values in memory with array syntax and a Named Constant (Define Names Name Manager). Related video: Dueling: Random Name - 1020 - Learn Excel from MrExcel
