2023 Training Calendar

Tutorials

How to Use Elementor in WordPress

by

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.

12

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

by

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

or

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!

by

Quick Ref

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.

QUICK REFERENCE

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. 

HOT TIPS

  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

by

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.

Conclusions

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

Stay Connected

Follow us on social media for news and promotions.
Facebook Twitter Instagram Youtube
© 2022 MU DOT MY PLT – ICT Training & Development Malaysia

Contact Us

Company