Happy Chinese New Year 2021! Gong Xi Fa Cai

Wishing everyone a Happy Chinese New Year! May blessed with an abundance of Good Health, Good Luck, Happiness, Prosperity, Joy, Love, and Peace! 

May the year of the Metal Ox bring us a better year and in this Movement Control Order (MCO) of Covid-19 as we look forward to welcoming you back to our training center for hands-on training and comfortable learning. 

Please take note that our company will be closed on Friday, 12th February 2021 and we will resume our business on Monday, 15th February 2021. 

Happy Holidays, Stay at Home, and Stay Safe! 

1 Free Follow up Training

Free Ionic.my Pro API

Ionic.my API is our custom made API allow you to;

1. Create a secure PHP MySQL Login for your mobile app

2. Sign up, Reset Password

3. User login redirect, log out with session removal

4. Dynamic Form submission to MySQL

5. Data retrieval from MySQL

6. File upload to remote server

7. Dynamic combo box submission to server

8. WordPress login

9. WordPress Contents Retrieval

10. Joomla! Contents Retrieval

WordPress Easiest CMS

First and foremost, WordPress is easy.

WordPress is awesome and easy!

If you can use basic computer software like Microsoft Word or you can handle email, then you can use WordPress.

It’s easy to post new content with drag and drop content editor.

It’s easy to add or change menu items. It's just a drag and drop!

It’s easy to change your site’s look and feel.

It’s easy to add new features.

WordPress is an open source software – free to use, edit and redistribute. That’s why you can easily find its original source codes publicly available.

Attend our WordPress Training to get started today!

WordPress Powerful SEO

WordPress is an open‐source Content Management System (CMS). It gives you a way to structure, manage and publish websites even if you don’t know HTML.

WordPress makes sure that the code itself generates and follows SEO best practice. WordPress makes it dead simple to use SEO best practice. Even if you’re a beginner to SEO, you can optimize your website for higher Google ranking with ease.

We have a number of actionable steps that you need to take to properly optimize your WordPress SEO.

Site's Visibility

If your website is not appearing in search results, then the first thing you need to do is to make sure that this option is unchecked.

Using SEO Friendly (SEF)

You need to visit the Settings » Permalinks page. Select the post name option and then click on the ‘Save Changes’ button to store your settings.

Yoast SEO Plugin

Yoast SEO is the most complete WordPress SEO plugin. It handles the technical optimization of your site & assists with optimizing your content.

Yoast SEO Plugin
Optimize Site Loading

Performance is important for SEO. You really should use one of the many caching plugins to do page caching. WordPress has multiple plugins for you to do this without any technical configurations. It Mostly works out of the box.

Free 3 months support

Get free email support after your training. Email to our trainer anytime. Support is limited to;

Support does not include creating new features or setup your system / application. If you need help with these, check out our Troubleshoot / Support package.

Press Release Mahir.my


Kuala Lumpur, 17th March 2020, Multimedia and Open Source Academy (Mu Dot My plt) will release a new initiative digital learning that aims for improving employees performance at the workplace. Its called MAHIR.MY.

MAHIR.MY targeting all public servants or the government or any people who want to grow their business all around the world. Conducting by our professional trainer will be worth to all participants. It is not just a video conference that we had provided through MAHIR.MY, we also give the participants practical training with a great live tutorial to get a better understanding. Without any concern about the timing or places to attend any training, now everything is just at your fingertips. MAHIR.MY also will come out with new feature which is a character as your artificial intelligences assistance. So, it can help you for your any problem about the courses. 

We are happy to say that it will be launch in June 2020. People can access it everywhere and anywhere without any doubt.

How to Use Elementor in WordPress

How to Use Elementor in WordPress

An Elementor is a plugin in WordPress used to build a page with drag and drop facility which helps to develop a high-end website for any page, theme, and design. 
Elementor gives a platform to develop an ideal website for newbie users and also helps people by providing a user-friendly environment of elements at the right corner of it.

If you are an Elementor newbie, these steps will help you understand the essentials of successful page-building in WordPress. You will learn about:

How to Install

Go to website elementor.com and click

In the WordPress dashboard, Click > .

Click   , and choose the file you’ve downloaded for Elementor.

After choosing the file, click

You will be directed to this page and click

That’s it! Now Elementor is in your WordPress!

Quick Reference :

  1. Download Elementor from elementor.com and click
  2. Open WordPress dashboard and click >
  3. Click      then 
  4. Click  after choosing the file

  5. Then, click         

Creating a Page with Elementor

Open your WordPress administrative dashboard and go to     >   

Insert your title at the segment as shown below

Click the big blue     button then you will be redirected to the Elementor  customization panel. 

Elementor Panels Overview

Elementor Widgets

Elementor comes with a set of widgets organized in by following the categories 

Click the      icon to create a Section, or click the     icon to add template  

Set your Column structure

Right-click to Edit, Duplicate, Copy, Delete etc.


Set the Columns Width. You can do it under Layout, or drag the dashed line between the Columns.

To add more Columns Right Click >  

Drag Widgets from widget panel to insert inside your Columns

Quick Reference :

  1. Go to the dashboard and click on    then    
  2. Add title and click 
  3. Click the  icon to create a Section, or click    the icon to add template
  4. Click    then choose the structure
  5. Right click then choose     to add column

Adding Template

Click the    icon to add template.

Click on any template to preview the template 

Click     to use the required template  

Quick Reference :

  1. Click on  icon to add template
  1. Choose any templates

  2. Click  to use the template

Save & Publish

You can always save updates every time you made changes. Just click on the small arrow and then click      

After you’re done designing your page, Preview & Publish it.  

Click the   icon to preview your page.

If you are satisfied with the result, go ahead and click the   button. 

Quick Reference :

  1. Click  to save you work.

  2. Click the   icon to preview your page.
  3. Click to publish you work.

Ionic 5 Installation in Windows & Mac

Ionic is a cross-platform that most widely used for building mobile and desktop apps using web technology. Ionic let us create elegant high-quality apps with ease and quickly. Now Ionic come out with new exciting features in Ionic Framework version 5.0.0.

To install ionic, you need to install Node.js on your system. If you had installed before, make sure it is an up-to-date version. You can install it from here https://nodejs.org/en/

1. Open a terminal window(Mac) or windows PowerShell(Windows).

Test Installation

1. Open Windows PowerShell or Terminal.

2. Write command and enter

3. Your output would be like the example picture below : 6.9.0

4. Write command and press enter

5. Next, you will see your ionic version : v10.16.3

Install Ionic Cordova

1. Open a  Terminal window/ Windows PowerShell and write :

For Mac, and press enter


For Windows, and press enter

Testing Ionic Installation

1.To see your Ionic version, write a command and press enter

Testing Cordova Installation

1. Untuk melihat Cordova version, tuliskan dan tekan enter.

Create New Apps

1. Write a command and press enter
2. To see your new app, write a command and press enter.

3. Name your project (no space no symbol) and press Enter.

4. Choose your starter template as a blank and Enter. Use ‘up’ and ‘down’ arrow key on your keyboard.

5. Write Y for Yes. Your cordova will be installed in your project.

Your new apps is ready!

Preview Your Apps

1. Open a Terminal or PowerShell and write a command and press enter.
2. Change your file directory to the folder that you had created. Write
3. Preview your apps with a command then enter.

4. Write Y for Yes and your Ionic/lab will be installed. Ionic lab gives you to preview your apps.

5. Your preview will be out on your web browser.

Custom Dashboard In Google Analytics With Solutions Gallery!

Google Analytics is a platform to get all data about your websites. I bet you will go nuts while looking at your Google Analytics since it collects a lot of data! 

Custom dashboard exists for you to quickly visualize your data. Let’s dive a bit deeper in using Google Analytics custom dashboard to help you understand more about what is happening on your site.

First of all, log into your Analytics account at http://analytics.google.com
Click  >

Click    then you have 3 option which is ‘Blank Canvas’, ‘Starter Dashboard’ and ‘Import from Gallery’ as below:

As a newbie in Google Analytics, we recommend you to choose 

‘Import from Gallery’ will brings you to this page:

Search your category at the top, left.


This page contains pre-made dashboard from Google Community based on your searched category. Once you have chosen your preferred dashboard, click 

On this page, choose your view   then click

Your dashboard is ready! Now you can start customizing your dashboard as you wish.

If you don’t like the arrangement, you can just drag and drop your widget!

If you want to add some more widget, just click  
Set your own widget and then click

Your new widget will appear at the bottom of other widgets

You can click buttons on the top of every widget to reset or delete it.
Click  to reset your widget and if you want to delete your widget, you can click

Overall, creating a custom Google Analytics dashboard is easy and make everything easier for you. You can have your important data in your Google Analytics account in a blink of eyes. If you’re ready to get serious about customizing Google Analytics dashboards, you can choose any free shared dashboards throughout the web without wasting time start it from scratch.


Follow these steps to customize your own dashboard:

  1. Click   
  2. Click 
  3. Click 
  4.   to get pre-made dashboard
  5. Search your category: 
  6. Choose your prefered dashboard then click 
  7. Select your view:   
  8. Create your dashboard:  
  9. You are now ready to customize your dashboard!
  10. Drag and drop the widget to adjust the arrangement.
  11. Click  if you want another widget
  12. Click to reset and to delete your widget. 


  1. Use the solution gallery. Start everything from scratch is time-consuming!
  2. Copying dashboard to different views if you are willing to reuse it for your other Google Analytics profiles.
  3. A helpful way to make another very similar widget is cloning your widget which can maintain the settings you have made.

Advanced Tips in Microsoft Excel

Why You Should Consider Using These Advanced Tips?

Some of us might have been familiar with Microsoft Excel. While others knew some basic functions or formulas. Regardless of which side you’re in, there are still many tips and tricks when using the software that we might not know, let alone be aware of their purpose. Well, fear not. In this tutorial, I will provide you with Top 10 Advanced Tips in Microsoft Excel you can apply when doing your work using Microsoft Excel.

Let's start with the advanced tips...

1. Quickly shift to the last cell in the column or row.

The first advanced tips is to quickly shift from the first cell to the last cell in the data, either from column-to-column, or row-to-row. What you have to do is simply go to the border of the cell, and then double click on the bottom border to transition to the last active cell in the column. As for shifting from row-to-row, double click on the right side of the cell border.

Shift to the last cell in the column
Shift to the last cell in the row

Bonus Tips:

You can also double click on the opposite side of the box to shift to the first cell.

2. Removing duplicates.

Removing duplication of any data becomes an easy task when using this advanced tips. You can use it to remove both words and number values.

  • First, select all the cells or data that you want to remove duplications.
  • Next, go to ribbon situated on top of the software, go to Data→Remove Duplicates.
  • Select the header for the duplicated data, and click ok.
  • A thread will be displayed once your duplication removal succeeds, click ok and you are ready to go.

3. Selecting multiple cells to insert the same data

If you plan on putting the same data or value into cells on either different cells or row, this method fits perfectly for that task.

  • First, hold the Ctrl button and select all the cells you need to put data in it.
  • Next, type in the data you need to put, and press Ctrl + Enter.

4. Autofill cells by data pattern

If you wish to insert repetitive data, such as date or months into either the whole column or row, follow these simple steps.

  • First, fill in the type of data you wanted for the column or row, for example, in the above image the data is the month.
  • Next, hover your cursor and hold the fill handle‍ – located on the lower right corner of the cell, then pull down or double click on it to fill in by column or pull it sideways to fill in by rows, until the last cell of your data.

5. Transpose data between row and column

Another advanced tips is transpose. Transpose allows you to shift your data arrangement either in row or column view. 

  • First, you have to select and copy the data you want to transpose.
  • Next, click on any blank cells that you intend to paste that data and go to Home, and select the arrow down button below the Paste option.

A number of option will pops up when you click on that button. Hover your cursor to the bottom of the pop up and click on Paste Special.

  • Once you click on Paste Special, another pop up will appear. Select transpose and click OK.

After you click OK, your data will appear in the opposite arrangement from the data you’ve selected before.

6. Wrap sentences to fit perfectly in cells

Wrap tool fits a long sentence perfectly in one cell. Simply press Alt + Enter button, or go to Home→Wrap Text and click the Wrap Text button.

7. Flash fill

Flash fill is a wonderful trick you can use which saves a lot of time when handling piles of data because it assigns the right data according to your data on the side columns.

  • Firstly, fill in the first cell with the appropriate data.
  • Next, select the next cell and press Ctrl + E.
  • Once you have hit CTRL + E, Microsoft Excel will automatically fill up the remaining blank cell with the appropriate data based on the data from the cell before it. For example, in this image, the data is month based on the date given.

Important Notes!

Flash fill only works on data in column cells.

8. Clipboard

To access clipboard in Excel, got to the Home tab and click on the button next to the word Clipboard. Your clipboard will appear on the left side of your spreadsheet.

What Do You Use Clipboards For?

When you copy anything on Microsoft Excel, the data or value that you’ve copied will be saved in the clipboard, make it easy for you to access your data there without having to scroll to find the same data. Clipboard also enables you to copy multiple data. When you want to paste it, just pick the data from your clipboard.

9. Converting a number to a money value

Need to convert numbers into money value? You can use this advanced tips to do that. Simply select the data that you want to convert, then head towards the number section under Home tab, and press button under the Number tab.

Pro Tips:

This method allows you to convert your data into almost every currency in the world.

10. Sorting data

Another interesting advanced tips that you might consider using is the sort tool. The sort tool allows us to sort raw data into organized data, either in ascending or descending order. 

  • Firstly, select the data that you need to arrange.
  • Go to the Data tab, head to the sort and filter section and click button for ascending order.
  • As for sorting the data in descending order, you must click button  and the data will sort in descending order.

Be careful!

When sorting data, some data from another cells tend to change because the data is connected to each other, and a checkbox will appear just like the one above.

11. Replace multiple same words altogether.

When handling big data that tend to change, such as a group of persons age, it must be frustating to select and change, one by one. If you opt for an easier method, you’ve come to the right place. It’s simple to change multiple words or data alltogether, actually.

  • Firstly, go to Home Tab ➜ Editing ➜ Find & Replace ➜ Replace.
  • A window will pop up. Input the words you want to replace on the first box, and on the next box, type the words that replacing it, then press   to replace all the value in the spreadsheet or to replace only one value.

Bonus Tips!

You can use the button  to find all the value mentioned written to be replaced. You can also use the button to find the value by order, from the first to the last.

12. Delete multiple error cells.

Deleting multiple errors when the spreadsheet is already finished can be done by following the steps given.

  • Firstly, go to Home Tab ➜ Editing ➜ Find & Replace ➜ Go To Special.
  • Select Formula ➜ Errors and click ok.

13. Use Macro to automate task for data of the same format

Macro is one of the advanced tips known to help user when handling a set of data, for example, financial data, which is sent to you every week. Macro helps shorten your task, while ease your daily workload too. By the way, a simple macro is no big deal, actually. You can start your very own simple macro by following the steps listed below.

  • Set up a Developer ribbon. Go to File ➜ Options ➜ Customize Ribbons and on the right side of the popup, select Developer.
  • Next, go to the Developer ribbon and click on Record Macro. A popup will appear which requires you to fill in the macro name. Press ok and start creating your procedure.
  • Once you have finished creating your procedure, and ready to save it as a macro, click Stop Recording.
  • When you want to use that macro, simply click on Macro which then a popup will appear. Select Run

Bonus Tips!

You can also start recording for macro by clicking the button situated on the bottom left corner of the software, next to the word Ready.

14. Setting Rows or Columns As Spreadsheet Guidelines

Sometimes, you might need a guideline to fill in your data, usually using the spreadsheet header, when you scroll down. You can set up a guideline by using this tip.

  • Select the header that you want to use as your guidelines, either row or column.
  • Next, go to View ➜ Freeze Panes and select Freeze Panes.

15. Using Format Painter

Format Painter is useful when you need to copy the same format of a recent table to a new table.

  • To start, first you have to select a complete table to be set as a format for your new table.
  • Go to Home and click the   button next to the Paste option.
  • When you have selected format painter, your cursor will become something like this . While your cursor is in this form, select the range of data that you want to set the format into.
  • After you’ve selected the range of data, all that’s left is to wait for Excel to transform it and once it’s done, your data will be viewed in the same format as the table you’ve selected before.

16. Impliment Cell Message Into Cells

When collaborating with others on a certain project, sometimes you want another user to avoid make changes to the cells you’ve made. To do this, you might want to put a cell message which will then pop up when someone click on the cell and display the message written on it.

  • Select the cell or range of cells that you want to display the message.
  • Head towards the ribbon, go to Data ➜ Data Tools and click the Data Validation icon on the bottom right next to Text To Column.
  • Put in your message thread into the Input message box and once you have done, click OK.
  • When the message had been set in place, your message will be displayed like this.


Well, that’s all this section can offer for now. Thank you for taking your time visiting and revising this section. Want to know more? Head on to our main website at https://www.mu.my/en/, and register for our course training to know more about Microsoft Excel Tips. We also provided bonus formulas and functions for those who attend this course training.

Other Post You Might've Interested