How to speed up your site with CloudFlare
Many weeks back after much deliberation, I decided to give CloudFlare a shot. As they describe themselves… CloudFlare protects and accelerates any website online.
How to restart your Amazon Kindle
Just yesterday my wife told me that for some weird reason her Kindle wasn’t responding. We had it fully charged, but all that we could see was a blank screen… almost blank cause I could make out some light shade of the e-Ink.
On-Page SEO Checklist for WordPress Blogs
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.
How to export your RSS subscriptions from Google 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.
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.
How to take a screenshot on Google 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!
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.
How to divide two arrays with SUMPRODUCT in Excel
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.
How to enable 2 step verification on Dropbox
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).
Stop your Mac from sleeping without an application
A few months back, we blogged about 7 applications for your Mac to prevent it from sleeping. While these programs make the process extremely simple, OSX Mountain Lion comes inbuilt with a ready command line tool that makes this process extremely easy. Fire up Terminal and run the following command: caffeinate -i -t 36000 & The command above will tell OS X to not sleep on idle (-i) and to keep running for 36,000 seconds or 10 hours (-t 36000).
Excel Tutorial: INDEX MATCH primer
Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we’ll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.
Excel Tutorial: VLOOKUP primer
Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we’ll use VLOOKUP to find a value from the table. Firstly, let’s create the above table in Excel.