My name is Mike Rempel and I am certified as a Microsoft Excel 2010 Specialist. I want to share my tips and tricks about Excel with you and hope you will not only benefit from these posts but also pass on this information to others. Enjoy!

How To Use GROUPBY and PIVOTBY Functions In Excel
6:26
How To Use GROUPBY and PIVOTBY Functions In Excel
How To Use The REGEXEXTRACT Function In Excel
14:18
How To Use The REGEXEXTRACT Function In Excel
How To Use The FILTER Function Based On A List With Multiple Criteria In Excel
6:31
How To Use The FILTER Function Based On A List With Multiple Criteria In Excel
How To SUM Alpha Numeric Values In Excel
6:58
How To SUM Alpha Numeric Values In Excel
How To Dynamically Set Multiple Print Areas On The Same Worksheet In Excel
5:11
How To Dynamically Set Multiple Print Areas On The Same Worksheet In Excel
How To Use The Navigation Option In Excel
3:12
How To Use The Navigation Option In Excel
How To Use The Analyze Data Option In Excel
5:06
How To Use The Analyze Data Option In Excel
Three Very Useful Paste Special Options In Excel
4:58
Three Very Useful Paste Special Options In Excel
How To Use SUMPRODUCT To Sum EXACT Matches With OR Scenario In Excel
4:05
How To Use SUMPRODUCT To Sum EXACT Matches With OR Scenario In Excel
Photos From A Dropdown List Without A Volatile Function In Excel
6:39
Photos From A Dropdown List Without A Volatile Function In Excel
How To Extract Numbers Only From A Text String In Excel
5:44
How To Extract Numbers Only From A Text String In Excel
How To Sum Multiple Smallest Values In Non Contiguous Ranges In Excel
3:04
How To Sum Multiple Smallest Values In Non Contiguous Ranges In Excel
How To Generate A Unique List From A Filtered List In Excel
7:13
How To Generate A Unique List From A Filtered List In Excel
How To Select Non Contiguous Cells In Multiple Workbooks Without Ctrl In Excel
5:20
How To Select Non Contiguous Cells In Multiple Workbooks Without Ctrl In Excel
How To Use The LET Function
8:01
How To Use The LET Function
A Practical Use Of The EXPAND Function In Excel
5:11
A Practical Use Of The EXPAND Function In Excel
How To Do Case Sensitive Counts Of Text In Excel
6:42
How To Do Case Sensitive Counts Of Text In Excel
How To Create A Unique List Of Complete or Incomplete Orders In Excel
6:32
How To Create A Unique List Of Complete or Incomplete Orders In Excel
How To Filter An Alphanumeric List If The First Character Is A Number In Excel
3:19
How To Filter An Alphanumeric List If The First Character Is A Number In Excel
Center Across Selection Macro Button In Excel
10:09
Center Across Selection Macro Button In Excel
How To Extract Dynamic Lists In New And Old Versions Of Excel
7:35
How To Extract Dynamic Lists In New And Old Versions Of Excel
How To Use FILTER And TEXTJOIN To Have LOOKUP Results In One Cell In Excel
3:46
How To Use FILTER And TEXTJOIN To Have LOOKUP Results In One Cell In Excel
How To Use Analyze Data In Excel
5:45
How To Use Analyze Data In Excel
How To Timestamp Changes To A Worksheet In Excel
4:20
How To Timestamp Changes To A Worksheet In Excel
You Gotta Use Tables In Excel!
12:00
You Gotta Use Tables In Excel!
How To Extract A Single List From Multiple Tables Based On A Criteria In Excel
3:18
How To Extract A Single List From Multiple Tables Based On A Criteria In Excel
The ISODD And ISEVEN Functions In Excel
3:07
The ISODD And ISEVEN Functions In Excel
How To Copy Power Query Steps From One Workbook To Another In Excel
4:09
How To Copy Power Query Steps From One Workbook To Another In Excel
How To Date And Or Time Stamp Completed Projects In Excel
5:59
How To Date And Or Time Stamp Completed Projects In Excel
Why I Love To Use Tables In Excel
8:53
Why I Love To Use Tables In Excel