Browsing articles in "Tips and Tutorials"
Mar
18
2013

On-Page SEO Checklist for WordPress Blogs

On-page SEO for WordPress

Today in the world of competition, it’s very difficult to beat someone without using resources like money, man power and skills. The field of blogging is also just like practical world where everyone want to be on top of the list and want to earn more than others. The methodology of competition goes on and with the passage of time you’ll see an increase in competitors and ratio of increasing competition is higher than decreasing. Blogging is good running business from past five years and now a day there is so much competition in this business also. The bad thing…

Read the rest of this post…

Mar
14
2013

How to export your RSS subscriptions from Google Reader

Google Takeout - Reader

By now, most of the web is abuzz with news of Google axing its Google Reader, which is a platform that most bloggers, including me, identify with. I’ve lived with Google Reader open while I worked for several years, either via FeedDemon and also directly. With the demise of Google Reader, Nick has also decided to kill FeedDemon, most of you might already be hunting for alternatives. Three popular names doing the rounds are Feedly, Newsblur and Netvibes. And, you even have a petition created on Change.org that has over 75,000 signatures at the time that I signed it. I…

Read the rest of this post…

Mar
12
2013

How to Build an Ecommerce Website Delivering More Profits?

How to Build an Ecommerce Website Delivering More Profits?

Is your online business with a great website designing sucks? Well, it happens to most ecommerce owners in fact. If you really do have a beautifully designed website and high-quality products, and still the business sucks, then obviously you are missing some tricks to convert the leads to sales. Reports say more than 45% shopping cart abandonments prior to sales raises due to unpromising shopping cart designing. Of course, there are a lot of businesses that earn customers as well as incredible profits with ease in the marketplace. So, what exactly are they following in order to make their online…

Read the rest of this post…

Feb
15
2013

How to take a screenshot on Google Nexus 7

Screenshot on Nexus 7

In the past taking a screenshot from your Android device was a painful experience requiring you to root your device. Even today, many of the screenshot apps available on Google Play require root access. However, if you’re running Android Jelly Bean then you don’t need any special apps to take screenshots, since the OS comes inbuilt with support for them! The screenshot that you see above is without using an app. All you need to do is to press the Power button and the Volume down button at exactly the same time. Keep if pressed for around 2 seconds and…

Read the rest of this post…

Jan
17
2013

How to quickly kill a program in Windows

During my regular work, I tend to face repeated issues of Excel hanging. This can be really frustrating because a stuck Excel means a painful wait for Windows to figure out what it wants to do with the process. Unfortunately, there isn’t much I can do about this because it is mainly due to addons that I have installed in Excel, which are required for me to do my job coupled with large files with tens of sheets and hundreds of rows with data. In this scenario, the method that most Windows users do is open up Task Manager and…

Read the rest of this post…

Jan
15
2013

How to add your blog to Google Currents

Techtites on Google Currents

Over the past few weeks I have been using Google Currents to read the latest news. Available for Android and iOS, Google Currents delivers beautiful magazine-like editions to your tablet and smartphone for high speed and offline reading. If you’re running your very own blog which publishes an RSS feed, then adding your blog to Google Currents is extremely simple. You’ll need Google Chrome to login to the website so download the software before proceeding. Once you have downloaded Google Chrome, visit the Producer website at https://www.google.com/producer. Once you sign into the website you’ll be prompted to create a new publication….

Read the rest of this post…

Jan
2
2013

What to Do When Someone Steals Your Website Content

site content

Creating content for the Internet is a challenge. On the one hand, without constant content creation, websites lose traffic and become irrelevant. On the other side of the equation, some unscrupulous webmasters and bloggers regularly seek fresh content from other sites, recycling it on their own pages. Not only is this blatantly unfair, but it could be costing the copyright owner lost revenue from advertising and sales. Fortunately, there are a few different steps that content owners can take to make certain their material is not used without permission. Taking a Proactive Approach “With the size of the Internet ever…

Read the rest of this post…

Oct
23
2012

How to divide two arrays with SUMPRODUCT in Excel

SUMPRODUCT to multiply two arrays

Way back in 2008, I wrote about using SUMPRODUCT to duplicate the functionality of SUMIFS which was introduced in Microsoft Excel 2007. SUMPRODUCT is a powerful excel function and is more commonly used to multiply two arrays. Let’s first understand the syntax of SUMPRODUCT. If you’re impatient, you can skip the tutorial and download the sample excel file from the end of this post. It contains solved examples with the related formulae. We’ll be using the following table in the example. Syntax: SUMPRODUCT(array1,array2,array3, …) Array1, array2, array3, …     are 2 to 255 arrays whose components you want to multiply and…

Read the rest of this post…

Oct
19
2012

Fixing Windows 7 Disk Errors

Windows 7 Check Disk

Disk errors plague virtually every Windows user at one time or another. These errors can show up in just about any stage of usage. Sometimes this can be something as simple as a bad connection. In these cases you can either reseat the hard drive (i.e. disconnect and reconnect the hard drive properly), or simply replace the hard drive entirely. In many cases, however, you may need to go into the disk system and check for specific errors. Odds are, like the majority of Windows users, you’re not an IT wizard, so you can’t just go into your system, look…

Read the rest of this post…

Sep
10
2012

How to enable 2 step verification on Dropbox

Dropbox two step verification

There have been concerns about the security of your files in Dropbox. Recently Dropbox added another layer of security similar to Google’s two step verification. When you enable two-step verification, whenever you want to login to Dropbox, you will need to use your password, and a security code that will either be texted to your mobile phone or generated by a mobile authenticator app (available for iOS, Android, Blackberry and Windows Phone 7). To turn on two-step verification go to the new Security tab in your Dropbox account settings and enable two-step verification in the “Account sign in” section. Navigate…

Read the rest of this post…