Extract Birthdate from Malaysia IC No

You can extract the birthday from the Malaysian IC No using the formulas as shown below:




You may need to check your Microsoft Windows date format settings to make sure the date format is set as d/m/yyyy.

If you set as m/d/yyyy, then you have to change the arrangement in B8 as B5&"/"&B6&"/19"&B4.

Excellent Excel Tips from chandoo.org

Go to this blog to learn more about Excel. Excellent discussion on Microsoft Excel.
You can even download a free Excel Tips ebook for free when you sign up for the newsletter.
http://chandoo.org/wp

Learn Microsoft Excel Basic from GCF

I found this website by Goodwill Community Foundation International has a very good web based interactive learning page for Microsoft Excel, other software and other life skills. It even has very basic maths interactive learning.

The learning concept is using the step by step screen captures with simple descriptions. It also has youtube videos link to learn from videos.

Go to this link http://www.gcflearnfree.org/excel2010 to start learning.

Employment Income Comparator

Find out how much you are actually earning from your employment. Most times, you have more than just the monthly salary. You can calculate the total income per year using this template. Add in more sources if you have them.

For those who want to resign and start your own business, use this comparator to check what is the total amount you are getting from the company that is paying you.

This comparator only compares the dollar and cents. Other benefits like less stress, good friends, conducive work environment and good boss are not quantifiable.

Have fun!!!!

As always, you can down the Microsoft Excel file from:
Download the file: employment_income_comparator.xlsx from:
http://seanexcel.weebly.com/work-files.html

Home Loan Monthly Repayment Comparator

You can easily compare the different home loan monthly repayments with different criteria.
Drag the excel table to more columns to have more comparison.

Note that you are paying more interest as your loan period is longer, even more than your house value.

Download the file: home_loan_comparator.xlsx from:
http://seanexcel.weebly.com/work-files.html

Asset Allocation Template

Download the file to use this Asset Allocation template.



Change the portfolio allocated % to calculate for switching amount.

Download the file: asset_allocation_template.xlsx from:
http://seanexcel.weebly.com/work-files.html