• Motivate yourself Everyday with Inspirational Stories.
  • Motivate yourself Everyday with Inspirational Stories.
  • Motivate yourself Everyday with Inspirational Stories.

Sunday, September 13, 2020

Easy & Quick Way to Remove Image background in Powerpoint

 

 

Hello Everyone, removing background of an images in Old days was quite time consuming and hard but with advancement of technology and development we can remove background of an images in a second using Power tools available in Microsoft PowerPoint. We do not have to install any photo editing software and lots of experience of it. 

Steps To Remove Image background in PowerPoint: 

Step 1. Open Microsoft PowerPoint and Choose Blank Presentation. 

Step 2. Add/Insert Image 

Step 3. For plain Background Image (Select the Image)
  • Go to Format Menu
  • Click on "Color" Option 
  • Select "Set Transparent Color" Option
  • Now Click in the Background of the Image to Remove.
Step 4. For Image with Complex Background (Select The Image)
  • Go to Format Menu
  • Click on "Remove Background" Option
  • Now, Choose "Mark Areas to remove" & Select the areas to remove
  • You can Choose "Mark Areas to Keep" for dis-select the selection.
  • After Selecting the unwanted background click on Keep Changes.

Step 5. Well Done... Your Background is Removed.

Thursday, September 3, 2020

Easy & Quick Way to Merge and Split Column/Row Data in Excel

 

Easy & Quick Way to Merge and Split Data in Excel


1. Select the column which contain your Text/Data which you want to split. (Without Including Header)

    


2. Select the
Data Tab from the Tab menu
    


3. Select
Text to Columns option
    


4. Choose “
Delimited” option and Click Next
        


5. Choose Space if you want to split your text having Space (You can choose comma, semicolon as required) & Click on
Next
        



6. Click on
up arrow in Destination option then, choose location (absolute address) where you want your text to insert
        




7. Click Finish, now all done You have got your text in required columns.
        

Tuesday, August 11, 2020

How to Create Power Point Presentation Quick Guide

 


Presentation is one of the key factor for a successful Project. From the beginning to end of any project there is a need of Presentation. To present the idea regarding project, analysis of project, discussion regarding project and final result of project after completion, there we must go through these stages with presentation.

There are different kinds of approaches to develop the presentation but we will understand and try to develop our presentation through the Microsoft PowerPoint which is rich in features and easy to learn.

At First :
You need to download and install Microsoft Office for Power Point. After Installation you can access or open Microsoft Power Point from start menu. We are using Office 2019 for this tutorial. (file)

Steps 1:

  1. Click on Start Window icon at the bottom left corner of the taskbar. OR, you can simply press Windows Key in the keyboard.
  2. Type PowerPoint and click on PowerPoint application icon.
 Fig: Accessing PowerPoint from start menu


Step 2:
  1. Choose Blank Presentation
  2. We can see the single presentation slide thumbnail at the left side.
  3. Click on the box saying Click to add title and Type the Title for your presentation
  4. click on the second box saying Click to add subtitle and type the name who develop this presentation. 
  5. Like in the given images/snapshots
Fig: 1st slide

Fig: adding title and subtitle

Step 3:
  1. Now add new 2nd slide in our presentation for more content
  2. Right click on blank space in the left slide thumbnail panel 
  3. Click on New Slide 
  4. Now we have new slide with different content box
  5. Here in the small box for title or topic (example: Introduction, Features, Objective)
  6. In second box we can add text as our need. (example: Introduction Paragraph, list of features)
  7. Like in the given snapshot.

Fig: Adding New Slide

Fig: New Slide with Different content field than 1st one

Fig: 2nd Slide with Content

Step 4:
  1. To add Image click on the picture icon in the box
  2. Now we have to select the image from the folder location
  3. Select the image and click in insert button
  4. You can resize the picture as your requirement
  5. You can get hint from the Snapshot
Fig: Adding Image


Fig: Find the folder location

Fig: Select the Image and Insert

Fig: Image in the Slide


Step 5:
  1. Follow the Previous steps and add more slides.
  2. You can get hint from the given snapshots.
Fig: Adding more slides

Fig: adding Thank you, an ending slide


Step 6:
  1. Now we can add design to our presentation slides
  2. Click on Design tab at the top
  3. Select the design template which you like
  4. Now you can find the design applied to all slides.
  5. Like given in the Example slide snapshot
Fig: Click on Design Tab at the top


Fig: Select the required Design template & applied to all slide


Fig: to present your presentation slide click on this icon OR you can press F5 key and to end the presentation press ESC key in your keyboard.



Fig: Save you Presentation file in computer

Fig: Click in Save

Fig: Find the location to save your file and give the name for your presentation & click on save button


You can quickly develop the presentation for you topic by simply following the given steps. If you have any queries then you can write in the comment section.
























How to Configure the Mikrotik router for Access the Internet/ Set up WAN & LAN

 


Mikrotik Routers are very popular around the globe by the organization to setup their computer network. It provides various rich features which are essential for the organization secure computer network. Here is the step by step procedure to configure the Mikrotik router for the first use where we will setup our WAN interface and LAN interface and access the internet.

After Unboxing and Reset of Mikrotik router We need to setup or configure the LAN & WAN to access the internet. Follow the given steps to setup your interfaces to access internet. Interfaces are the Ports in the routers.

  • Firstly you need to download Winbox in order to access the mikrotik router setting or admin dashboard. or you can access the admin dashboard by simply typing 192.168.88.1 in the browser. You can download winbox applicatioin from this link https://mikrotik.com/download

  • Now open the winbox application then type default IP(192.168.88.1) in Connect To field, type admin in Login and leave blank in password field
  • OR you can select your router by clicking on neighbors tab in winbox and select your router and type admin in login and leave the password field blank
  • Now remove the configuration for first use.
  • Now follow the given steps
Fig: Access from Browser

Fig: Access from winbox


Step 1:
- go to IP tab and select Addresses
- click on + sign and add new address
- give IP given by ISP in address field (example: 202.131.84.94/29)
- select ether1 rename it to ether1_WAN in interface
- click apply and Ok

Step 2:
- go to IP tab and select DNS
- give the DNS server address provided by ISP (example: 202.131.80.1)
- give another DNS server by clicking in down arrow
- click apply and OK.

Step 3:
- go to IP tab and select routes
- click on + sign to add new routes
- give gateway provided by ISP in gateway field
- click on apply and see the reachable ether1_WAN is selected or not on the list field
- click Ok

step 4:
- go to IP and select addresses again
- click on + sign and add new address
- give IP for your inside network in address field (example: 192.168.10.1/24)
- select ether2 and rename it to ether2_LAN in interface field
- click apply and Ok.

step 5: 
- go to IP and select DHCP server
- click on DHCP setup
- select ether2_LAN in DHCP server interface and click next
- click next until the successfully completed message and then click Ok

step 6:
- go to IP and select Firewall 
- Select NAT Tab
- click on + sign to add new NAT
- go to  general tab
- select ether1_WAN in Out Interface field
- go to action tab
- select masquerade and click Apply and OK.

Finished....... Note In ether1 port is for uplink ISP cable and ether2 port is for our inside network cable.  

If you have any confusion regarding this post please feel free to write your queries in the comment section. Thank you.