Sunday 24 January 2016

How To Configure Outlook in MS Outlook 2013






Today I am teaching you very interesting thing is that of about outlook.in this tutorials we shall learn about POP and IMAP, and how to configure outlook in MS outlook 2013.You should to know about this.

Let’s join this tutorials without any delay.
Difference between POP and IMAP.

Of the two, IMAP is the better option - and the recommended option - when you need to check your emails from multiple devices, such as a work laptop, a home computer, or a tablet, smartphone, or other mobile device. Tap into your synced (updated) account from any device with IMAP.
POP3 downloads email from a server to a single computer, then deletes it from the server. Because your messages get downloaded to a single computer or device and then deleted from the server, it can appear that mail is missing or disappearing from your Inbox if you try to check your mail from a different computer.
POP3 - Post Office Protocol
IMAP - Internet Messaging Access Protocol
You can use only one computer to check your email (no other devices)
You can use multiple computers and devices to check your email
Your mails are stored on the computer that you use
Your mails are stored on the server
Sent mail is stored locally on your PC, not on a mail server
Sent mail stays on the server so you can see it from any device

If you want to go with POP, then here is setting for pop.
Here's how to enable POP in Gmail:
1.     Sign in to Gmail.
2.     Click the gear in the top right (setting).
3.     Select Settings.
4.     Click Forwarding and POP/IMAP.
5.     Select Enable POP for all mail or Enable POP for mail that arrives from now on.
6.     Choose what to do with your messages after your POP client or device receives them.
7.     Click Save Changes.
Although the radio button next to your selected option may not stay selected, Gmail displays the status next to 'POP Status:.' When you enable POP, your settings display 'POP Status: POP is enabled.'
If your POP settings are turned off, the status will indicate that POP is disabled.

If you want to go with imap here is setting for IMAP
Enable IMAP in your Gmail settings
1.     Sign in to Gmail.
2.     Click the gear in the top right .
3.     Select Settings.
4.     Click Forwarding and POP/IMAP.
5.     Select Enable IMAP.
6.     Click Save Changes.
Note: This setting is not available while using the basic HTML view of Gmail. To enable IMAP, use the standard view instead. Find out more about standard view and basic HTML view.

1    Then open outlook.
   
    Click on manual setup or additional server types.



3.       Click on POP or IMAP.




4.       Fill the all required option.(as shown in the fig.). Then   Click on more setting..


For ex.
User information
Your name=sanjay kaqnojiya
Email address=sanjaykanojiya339@gmail.com   
Server information
Account type=pop (you can select anyone either POP or IMAP)
Incoming mail server=pop.gmail.com                    
Outgoing mail server=smtp.gmail.com                  
Logon information
Username=sanjaykanojiya339
Password=in that you type your email password.

  Choose outgoing server.  Tick on the use same setting as my incoming mail server.(as shown in the fig.)


3.     .
4.       Click on advance tab.   Tick on this server require encrypted connection. (SSL Port no of POP=995)
Use the following type of encrypted connection. (Choose SSL from the list SMTP=465).
Then click OK

 And click next.
Following screen are appear on the screen.

If all the task completed it means you have successfully configure the outlook 2013.

If you did not receive all the mail then click on send\receive in the outlook 2013 homepage.
By this you can receive all mails.


Thank you for join this tutorials.


Sunday 17 January 2016

How To Use Hlookup In Excel








Hellow friend today I’ll teach you how to use hlookup.in previous tutorial I ‘ve teached you how to use vlookup .hlookup is same like a vlookup.in vlookup it show vertical result.in hlookup it give horizontal result.

Defination- Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.
Now lets join the tutorial.

To use vlookup first of all we have to create table (as shown in figure.)


Select tables and give table names such as SUN. In the name box(as shown in figure)



If you want to see HLOOKUP. For ex. How many lava smartphone sold by vijendra.
Then we use formula
=HLOOKUP (M9, SUN, 7, 0)
=41

IT MEANS 41 LAVA SMARTPHONE SOLD BY VIJENDRA.

EXPLANATION

M9= IF YOU WANT TO SEE HOW MANY LAVA SMARTPHONE SOLD BY SALESMAN .THEN WRIGHT THE NAME OF LAVA IN THE BOX THEN CLICK ON IT, M9 WILL BE SELECTED AUTOMATICALLY.NOW HERE I AM USINGLAVA. (YOU CAN TYPE ANY ONE SMARTPHONE NAME INSTEAD OF LAVA)


SUN=SUN IS THE NAME OF TABLE.

7 = YOU WANT TO SEE HOW MANY SMARTPHONE SOLD BY VIJENDRA AND VIJENDRA EXISTING ON 7TH ROW THAT’S WHY WE USE 7 IN THE FORMULA. (By this you can select any row instead of 7)

O = IS THE FALSE VALUE TO SHOW THE CORRECT RESULT.

Finally it looks like as


When you hit the enter button it show the value.



 BY THIS YOU CAN GET ANY SALESMAN PURCHASE DETAIL.

THANK FOR YOUR READING.








How To Root Any Android Device



Hi! Friend today I will teach you how to root any android device.The user will have more control on their Android phone like settings, features and performance by rooting. Root is giving more faculties but it avoids phone warranty. Let’s go to discuss all things of Root.
What is rooting?
In all Android phones rooting is very important for making any kind of changes in your Android phone OS level. Root enable or give right to any Android phone user to get full access on whole android OS or phone. Android rooted phone user make necessary changes according to his requirement. Root user mean as like window Administrator user. You cannot make any change without Root right.
Root give facility to remove bloatware of manufactures of Android phone, to increase internal storage capacity, make more RAM free, install custom ROM, settings and Apps.
Now lets start the rooting procedure in Micromax aq5001.
STEP 1
 Now go to system setting then open Security tab and scroll down and find Unknown Source option, tick the check box for enable this. After then Download and install Kingroot on your phone.
STEP 2
First of all check your device is rooted or not. You need to install root check app from google play store.
Then click on root check this show your device is not rooted.




Don’t worry. If you want to make your device rooted just go to xda developers homepage and download the latest version of kingroot. To download kingroot (click here)
Before downloading must read the instruction because rooting the device it voids your warranty.
After downloading install this app. when you open the app it will show you your device is not rooted and start root button gets highlighted and click on start root button to start rooting your device.

start root button to start rooting your device.
Remember
Make sure that you are connected to internet because it download the required files from the internet.
it will take 2 or 4 minute.
In this procedure don’t touch your device.
Now here you get result on your screen is that your device is rooted.
To check your device is rooted or not again open the root check app. now it ask your permission click on allow button. It show your device is rooted.

Finaly you have rooted your device and now enjoy your device without any obstruction.
Note
To root your device it voids your warranty. After rooting, you are able to make any kind of changes in your Android mobile phone, but if you made some wrong changes then your phone will be dead or bricked.
If you want to back your warranty simply you uninstall the kingroot. From your device.to install open the kingroot app and click on uninstall button. After uninstalling your device become unrooted .you can do one thing also you can reset your android device.
thanks for your reading.