How many shortcuts do you know for Microsoft Excel?
Learn these useful Excel shortcuts to save your time working on spreadsheets.
Learn more at www.mu.my
Office
What is a PivotTable?
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.
Conditional Formatting in Excel
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/
Upcoming Excel Training Basic to Advance on 13-14 July 2017.
Contact info@mu.my or 03-80116639.
Find out more at https://www.mu.my/
Goal Seek in Excel
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 info@mu.my or 03-80116639.
Find out more at https://www.mu.my
Microsoft Access Advanced Training – Kementerian Kesihatan Malaysia
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.
Microsoft Access 2013 Training with Ministry of Health
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.