Microsoft Excel Shortcuts That You Should Know

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

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.

Read more

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.

Read more