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.
Make your data easier to read.
With Conditional Formatting, you can highlight the data with a certain colour or style based on cell values. For example, you can highlight the sales above RM8000 by creating a certain rule. You also can find duplicated items, hide errors, compare two lists, etc. Conditional Formatting is a powerful feature and can do more than many people realize.
Want to learn more on Conditional Formatting in Excel, enroll with us http://excel.my/
Situation: You want to buy a house and the lender offers loan on at RM 500,000 over 20 years. With this, you can find out how much your payback per month using all those calculators on the net.
However, what if you set your budget to pay RM 1,300 instalment 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.
Want to learn more about Goal Seek in Excel, enrol with us http://www.excel.my/
Upcoming Excel Basic to Advance on 7-8 June and 13-14 July 2017.
Contact firstname.lastname@example.org or 03-80116639.
Find out more at https://www.mu.my
Once again MU DOT MY PLT conducted the Microsoft Access training with the Ministry of Health from Department of Public Health Development. The training was held over two days from 29th November to 30th November 2016 and conducted by our professional instructors. Training was held at the Federal Government Administrative Centre, Putrajaya.
A total of 25 participants from Ministry of Health has participated in Microsoft Access 2013 training at MU DOT MY PLT Training Centre. This training has been held for 2 days on 11&12 October 2016. Training was conducted by our professional trainer.