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.
What is a PivotTable?
Sam S
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/
Joomla! Translation Day (Pek Bahasa ms-MY)
Joomla! Translation Day for Joomla! 3.7 Malay Language pack hosted by Joomla! Community Malaysia will be held on 3 June 2017. This is an online event and anyone can participate from anywhere.
The purpose of this event is to translate new strings of Joomla! 3.7 and release Joomla! 3.7 language pack. Volunteers do not have to be a professional translator to contribute to the translations. All contributors will be listed in joomla.org.my.
For more info, please email to sam@joomla.org.my
Find the event on Facebook: https://www.facebook.com/events/203400116841838/
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
Sam Suresh was appointed as a Team Leader of Joomla! Certification Team
Our trainer, Sam Suresh was appointed as a Team Leader of Joomla! Certification Team effective on May 2017.
The aim of Joomla! Certification Team is to design, deliver and maintain the official Joomla! Certification Program. Joomla! Certification Team is a very large team which contributed by volunteers and composed by 4 working groups as sub teams: Certification Exam Team, Certification Marketing Team, Certification Operations Team (COT) and Certification Platform Team (CPT).
Currently, Sam Suresh are involved in following Joomla! teams:
1. Certification Team – Team Leader
2. Certification Platform Team – Team Leader
3. Certification Operations Team – Member
4. Webmasters Team – Member
Check out Sam Suresh’s profile on Joomla! Volunteers Portal™.
iMoot 2017 (#iMoot17)
iMoot 2017 (#iMoot17), the largest, fully online LMS conference will be organised from 18 May 2017 to 20 May 2017 (GMT+8). It is a 52 hours nonstop online conference that brings together the Moodle community around the world without any physical boundaries.
iMoot is a biannual online conference where the Moodle community, practitioners, administrators and decision-makers meet to share the best practice in online learning. Presentations and discussions will be focusing on the Moodle e-learning software including other extensions, plugins and third party software that integrates with Moodle.
All presentation sessions will be recorded and available for participants to review and discuss via iMoot site and forums. Estimate 300 people from all over the world will be attending the online conference including educators, Moodlers, developers and managers, in education establishments, businesses and government agencies.
Our trainer, Sam Suresh is one of the speakers in the live presentation session of iMoot. He will deliver a topic named ‘Using Moodle as Certification Platform’ to discuss using Moodle as certification platform to run online exams using Safe Exam Browsers and leverage on badges to maintain certified users. Check out Sam Suresh’s presentation profile in iMoot17.
For more details about the iMoot 2017, check out the official website here or follow the twitter hastag #imoot17.
WordPress Meetup KL April 2017
Recently WordPress Meetup Kuala Lumpur was held on 29 April 2017 at the MU DOT MY PLT, Subang Jaya. We have almost 20 participants joined the meetup this month from Argentina, United States and Malaysia.
Among those attended the WordPress Meetup Kuala Lumpur in 2017 are local WordPress developers, designers, and publishers together to share knowledge and experience, and to meet with WordPress users around Malaysia and abroad. WordPress Meetup is open to all who love WordPress and its free organized by volunteers.
We have 4 speakers presented some great topics about WordPress. Our trainer, Sam Suresh and our programming developer, Syahmi were among the speakers in the meetup.
Sam Suresh, who was the first speaker, shared the WordPress story and delivered the second topic entitled “Setting up Your WordPress on Cloud” to talk about how to set up a WordPress on Cloud.
Then, Syahmi delivered a topic entitled “How to create a WordPress Plugin” to talk about how to create a plugin by using PHP language.
The third speaker, Rindy Portfolio delivered a topic entitled “Five Cool WordPress Things” to discuss a few cool WordPress-related things that are happening in his world currently.
The last speaker, Leonardo Losoviz from Argentina shared and talked about an open source framework which named ‘the PoP framework’ to all participants.
WordPress Meetup is suitable for all. If you want to explore WordPress, using it as a Blog, CMS or as a platform, you are very welcome to join.
At the end of the WordPress Meetup Kuala Lumpur April 2017, all of the participants were inspired and excited to be able to share knowledge and experiences with other WordPress users.
The venue for the event sponsored by MU DOT MY PLT and drinks were partially sponsored by Reka MY.
Next meetup is scheduled in July 2017. If you want to sponsor this free event, do contact us sam@wp.org.my
Animated SVG Logos
Scalable Vector Graphics (SVG) is an XML-based vector image format for two-dimensional graphics with support for interactivity and animation.
You can find most of the corporate companies using SVG format to display their logo. SVG is scalable, that means you don’t have to worry about image size anymore.
SVG files are relatively small in size. You still can optimize and reduce the file size by using optimizer. One of the good optimizers I use is http://petercollingridge.appspot.com/svg-optimiser.
Click here to preview the animated SVG Logo: https://samsure.sh/svg-animation-using-snap-svg/
Checkout snap SVG: https://github.com/adobe-webplatform/Snap.svg
You can generate SVG files from Adobe Illustrator, Inkscape or other image editors. I used Adobe Illustrator and ‘Save As’ SVG format to convert my logo into SVG format.
– This post is originally created by Sam Suresh
Malaysia Open Source Conference 2017
Malaysia Open Source Conference 2017 (MOSCMY 2017) will be held on 17th May until 19th May 2017 at University Kebangsaan Malaysia, Bangi, Selangor. MOSCMY is the largest “Teh Tarik Session” for open source community in Malaysia. This event gathers CEOs and leaders, vendors, consultants, associations and regulators from Malaysia and around the world to address mutual challenges and share information on Open Source Software. MOSCMY 2017 theme is “Open Source in Financial Services” to explore the Open Source software and technology at the Enterprise environment to be used worldwide.
Joomla! Super Sprint London 2017
On January 20, 2017, Sam Suresh arrived at Heathrow Airport. The time difference between Malaysia and London is 8 hours and the trip takes 14 hours. According to him, the City of London City is a wonderful city and there are many attractions and historical sites to visit.
Sam Suresh shared his experience visiting some interesting places that are found in London City. In London, there is the hop-on-hop-off service bus (HOHO bus), where the bus will take passengers to see and visit interesting places in London
The temperature in London
HOHO bus route map.
The interesting places that he had visited are Tower of London, Tower Bridge, the Thames River, the Tower ofBig Ben, London Eye, Buckingham Palace, and many more. Sam also managed to share a few photos of the places visited by him
Throughout the Joomla! Super Sprint, they have made great progress in the certification platform. Among them, Michael Snoeren has done a rewrite certification of the user directory with more new features. In addition, LMS engine upgraded to the latest version and URL rewriting is now active. Hosting PHP short account is upgraded to PHP 7 and compatibility tested on both of Joomla! and LMS engine.
Student dashboard for JLPS
Certified directory profiles with social sharing and Profile URLs are SEF friendly.
Live exam status dashboard for supervisors who monitor the exams.
Besides MU DOT MY PLT Trainer, Sam Suresh, Super Sprint has also been accompanied by Michael Snoeren and Chris Keen from Netherlands and a few other members of his team. Assistance given from each team member has a positive impact and achieve the desired objectives successfully
Happy Chinese New Year
MU DOT MY PLT would like to wish Gong Xi Fa Cai to all customers and participants. May we all get good health, peace, prosperity, longevity and happiness.
Learn while building WordPress website with ANS Institute of Technology
ANS Institute of Technology sent three participants from three different campuses of Alor Setar Campus, Johor Bahru Campus, and Kota Bharu Campus to join the WordPress Web Design Project-based Training. The training was held over three days, on 9, 10 and 11 January 2017 at the MU DOT MY PLT. The training was conducted by our professional trainer, Sam Suresh.