Kevin Lehrbass

Popular uploads Play all

• 13:55

  • Play next
  • Play now

  Video 00050 Vlookup versus Index Match - Duration: 13 minutes.

  • 5 years ago
  • 8,403 views

  Learn how to combine Index Match to replace the vlookup. Index Match is much more versatile.
• 6:03

  • Play next
  • Play now

  Video 00127 All Text Combinations Using Simple Pivot - Duration: 6 minutes, 3 seconds.

  • 3 years ago
  • 7,900 views

  Get Excel file here: http://www.myspreadsheetlab.com/00127-all-combinations-no...
  Believe it or not a simple pivot table can do this. No VBA. No Formulas. No SQL cartesian product.
  
  S...
• 9:36

  • Play next
  • Play now

  Video 00031 DATA VALIDATION restrict values entered into a cell - Duration: 9 minutes, 36 seconds.

  • 6 years ago
  • 4,635 views

  Use Excel's data validation feature to restrict the values that can be entered into cells
• 3:55

  • Play next
  • Play now

  Video 00040 Data Validation Cleanup in Excel - Duration: 3 minutes, 55 seconds.

  • 5 years ago
  • 4,600 views

  How to remove data validation (drop down list) from cells and how to identify cells with invalid data
• 3:10

  • Play next
  • Play now

  Video 00014 Pivot Table: Extend the data range - Duration: 3 minutes, 10 seconds.

  • 6 years ago
  • 4,479 views

  Do you have more data now? Learn how to quickly expand the data range for your pivot.
• 2:10

  • Play next
  • Play now

  Video 00046 Free Template_SWOT planner - Duration: 2 minutes, 10 seconds.

  • 5 years ago
  • 4,404 views

  Use this template to track the strengths, weaknesses, opportunities and threats of your business.
• 10:46

  • Play next
  • Play now

  00172 Unique Values for Drop Down List - Duration: 10 minutes.

  • 1 year ago
  • 3,979 views

  https://www.myspreadsheetlab.com/video-00172-unique-value...
  00:00 Requirement: drop down list with unique values
  01:01 light/simple/dynamic: pick 2
  --------------SOLUT...
• 6:22

  • Play next
  • Play now

  Video 00099 Gantt Chart Planned VS Actual - Duration: 6 minutes, 22 seconds.

  • 4 years ago
  • 3,308 views

  In this video I explain how to use this free Excel Gantt chart template.
  Download the template here: http://1drv.ms/1bYwrTa
  or here
  Download the template here: http://www.myspreadsheetlab.com/2014...
• 5:48

  • Play next
  • Play now

  Video 00052 Use Quartile function to cut data into 4 parts - Duration: 5 minutes, 48 seconds.

  • 5 years ago
  • 2,525 views

  Use Excel's Quartile function to determine the cutoff points so that you can cut the dataset into 4 equal parts
• 6:36

  • Play next
  • Play now

  Video 00075 Count unique values per row in a large Excel dataset - Duration: 6 minutes, 36 seconds.

  • 5 years ago
  • 2,158 views

  Get Excel file 00075 here: http://1drv.ms/1bYwrTa
  
  In this video, I explain this array formula:
  {=SUM(IFERROR(FIND({1,2,3,4,5,6},MATCH(B2:G2,B2:G2,0)),0))}
  It looks complex but I explain each ste...
• 4:47

  • Play next
  • Play now

  Video 00093 Is merged cell with formula a good idea? - Duration: 4 minutes, 47 seconds.

  • 4 years ago
  • 2,127 views

  Merged cells are usually a bad idea when working with data. However, in this video I show you a possible exception.
  Download the Excel file: http://1drv.ms/1bYwrTa
• 7:49

  • Play next
  • Play now

  Video 00020 Use a FILTER to hide rows - Duration: 7 minutes, 49 seconds.

  • 6 years ago
  • 2,126 views

  Learn how to hide rows using Excel's FILTER feature.