Kevin Lehrbass

Popular uploads Play

• 8:56

  Learn Excel: Add Sporadic Totals

  • 5 months ago
  • 730 views

  Add dynamic subtotals to a dataset in Microsoft Excel using formulas instead of macros (VBA). Four simple steps.
• 2:10

  Free Template_SWOT planner

  • 1 year ago
  • 619 views

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

  Solution_Dynamic array HYPERLINK

  • 1 year ago
  • 588 views

  Create a dynamic hyperlink using an array formula. This means that you can jump to a location in your data depending on a condition in the values. Advanced formula with several functions.
• 9:20

  Free Template_Wedding Planner

  • 1 year ago
  • 583 views

  Keep track of wedding contacts, event attendance, tasks and reception seating.
• 3:55

  Data Validation Cleanup in Excel

  • 1 year ago
  • 529 views

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

  Pivot Table: How to Group Dates

  • 1 year ago
  • 483 views

  Learn how to group a column of dates by Year & Month and sum another field