How to use MEDIUM: On more social platform to share blog post




Medium is one more place where you can write stories and publish it. It is  really a cool place to share you content with the other members on Medium. This website has an Alexa rank 377. Now, if a website has such high ranking, means it will have huge traffic. Hence, using this website will help you to connect with bloggers and experts around the world. If you have not used this website, I would recommend you to please start sharing your article on this website. Below are the steps to register and share your stories on this website.

Sign in with twitter, Facebook or Gmail account on Medium


You can easily sign in to Medium using twitter, Facebook or Gmail account as shown below. Once you become a member of medium, you can fill your profile details.

Write stories on Medium to share


Once you have logged in to Medium, you can see tab for writing a story. If you have a story or blog post to share, you can just go ahead and publish it as shown below.


Once you click Write a story, you will get a box with Title and tell your story description. Here, you can just feed your title and paste your blog post to publish it.

These are the simple steps to use Medium for sharing your blog post and connect with the members related to your niche. You might get a dofollow or nofollow backlink as well from medium if you become an active member on Medium.

How to use free Google Webmaster tool for your Blog




Google webmaster tool (GWT) is a free tool by google to keep a check on your blog performance in the backend. This is the best tool to use if you really want to increase your blog ranking in search engines. All the blogger and WordPress bloggers with a custom domain can use this tool. There are many features in this tool which can help you to beat your competitor in the search engine ranking. Once, you add your blog domain and verify it, your blog will be added to google webmaster tool. Now, you can analyze the performance of your blog in the google search engine. Let us check step by step how the GWT will help you increase your blog ranking in the google. 

Add and Verify your blogger and WordPress blog


In only two steps you can add your blog or domain in the Google webmaster too. Just follow the below steps.

First login to Google webmaster tool using your Gmail account. Now, click Add a property to add your website or domain as shown below.
How to use free Google Webmaster tool for your Blog

In the next step, you have to Verify for the ownership of the blog. Now, use any of the below method to verify your blog and add it in the google webmaster tool.
How to use free Google Webmaster tool for your Blog

Dashboard of Google webmaster tool


The dashboard itself will give lot of information about your blog performance in google search engine. As you can see below, you can see the Crawl errors, Search Analytics and the Sitemaps information is shared in the dashboard section. These three section plays a key role in increasing your blog ranking and performance in the search engines.
How to use free Google Webmaster tool for your Blog

Crawl Errors in detail


Crawl errors should be always avoided because the google spiders cannot crawl your blog smoothly if you have dead or broken links. Crawl errors decreases the Search Engine Optimization (SEO) score of a blog. Hence, always check the google webmaster tool to see any dead or broken links affecting your blog indexing. The more the google spiders crawl your blog, the more your blog will be ranking better in the search engine.
How to use free Google Webmaster tool for your Blog

Search Analytics in details


This section shows the keywords ranking for your blog. Keywords plays an important role in driving traffic to your blog. Yes, it is not easy to find keyword from keyword planner or from SEMrush. But, Google webmaster easily shows the keywords which are driving traffic toyour blog. This way you can easily target the keywords to generate more traffic to your blog.
How to use free Google Webmaster tool for your Blog


Sitemaps in detail


Sitemaps are necessary for proper in indexing and crawling of your blog. Creating and submitting a Sitemap in google webmaster tool is easy. Once you submit your sitemap, you can check the errors in your sitemap using google webmaster tool. This way you can remove errors in your sitemap and increase the SEO score of your blog.
How to use free Google Webmaster tool for your Blog

Backlinks of your website


One of the best use of google webmaster tool is you can check the backlinks of your blog. Backlinks are very important for SEO and the blog ranking. The more backlinks(referral) to your blog the more your blog rank increases in search engine. Also remember, high qualify backlinks and do follow links are very important to increase the SEO score of any blog.
How to use free Google Webmaster tool for your Blog


Hope, now you will start using google webmaster tool and increasing your blog ranking and performance in google search engine.

How to check Duplicate DATA in the Excel sheet



Microsoft office has amazing functions which really makes our job easy. If you are using MS Word and MS excel you will come to know how easily you can do your office or personal work in them. Today, I am just sharing a tip while using excel which can help you to perform your task efficiently. We will learn today how to find out the duplicate data is excel sheet with a single click and avoid using the overlapping of same data. This is the easiest way you can remove unnecessary data from your excel sheet.

Find duplicate data in Excel sheet with single click


Excel sheet is used for keep a list of your account or for calculation of number or metrics which can be easily done on excel. Hence, we might sometime duplicate some number or data while entering them in excel. It is easy to find the duplicate data if you excel has less or limited information, but when your excel has too much information, it will be difficult to find any duplication error in the data. Hence to remove this error just click the below button to find the duplicate data.

How to check Duplicate DATA in the Excel sheet


Once you click the above button, it will find out the duplicate data and will remove it.