Conditional Formatting in Excel

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.

Read moreConditional Formatting in Excel

Goal Seek in Excel

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.

Read moreGoal Seek in Excel