For some reasons ….

Dear visitors,

For some reasons, SWF support and other reasons, I finally decide to move this site to
http://excel-tutorial-video.blogspot.com/

But, not all article in this wordpress site was moved yet. I will move it one by one.
Thx

Data Validation

RESULT VIDEO
STEP-BY-STEP GUIDE VIDEO (In making)

Using Toolbox (Spinner Control)

To change value on cell, you don’t need to type it anymore (in some case). Just Click it!

View the Video (maybe take times to load)
Partial Video > Part 1, Part 2, Part 3, Part 4, Part 5, and Part 6

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

Assign Macro to A Button

PROBLEM: You already create macro then you need to run it with click on a button
SOLUTION: Use VBE (visual basic environment)
RESULT:

FOLLOW ME TO STEP-BY-STEP GUIDE