How many shortcuts you know for Microsoft Excel?
Learn these useful Excel shortcuts to save your time working on spreadsheets! (more…)
PivotTable is one of the most powerful features in Excel. It will save you a lot of time to summarize your large, detailed data set into a meaningful report. (more…)
Make your data easier to read.
With Conditional Formatting, you can highlight the data with a certain color or style based on cell values. For example, you can highlight the sales above RM8000 by creating certain rule. You also can find duplicated items, hide errors, compare two lists, etc. Conditional Formatting is a powerful feature in Excel and can do more than many people realize. (more…)
Situation: You want to buy a house and the lender offer loan on at RM 500,000 over 20 years. With this you can find out how much your pay back per month using all those calculators on the net.
But what if you set your budget to pay RM 1,300 installment per month. So based on mortgage rate, how much worth of house you can afford for RM 1,300 per month?
Goal Seek allows you to analyses the best value for you to achieve your desired goal. (more…)