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