Finding Inverse Matrix

Your Problem: To Find Inverse Matrix using Excel
The Solution: Use MINVERSE function
The Result:

FOLLOW THE STEP-BY-STEP GUIDE

VIDEO HERE

Count Items in Column

PROBLEM: How to count items in column (not count number)
SOLUTION: Use addition column and countif function
RESULT:

FOLLOW ME TO STEP-BY-STEP GUIDE

Change Uppercase to Title Case

PROBLEM: You need to change UPPERCASE string/text to Title Case
SOLUTION: Use PROPER function
RESULT:

FOLLOW ME TO STEP-BY-STEP GUIDE

Set a Filter

PROBLEM: I need to sort data or see appropriate data
SOLUTION: Use filter tool
RESULT:

FOLLOW ME THE STEP-BY-STEP GUIDE