tutorials

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. Once your website is a part of the CloudFlare community, its web traffic is routed through our intelligent global network. We automatically optimize the delivery of your web pages so your visitors get the fastest page load times and best performance. We also block threats and limit abusive bots and crawlers from wasting your bandwidth and server resources. The result: CloudFlare-powered websites see a significant improvement in performance and a decrease in spam and other attacks.

CloudFlare

CloudFlare offers both free and paid plans. You can check out a comparison between the various plans as well as see all that you have for offer. If you’re running a huge site, getting a paid plan is definitely a great option. It definitely works out cheaper than running your own server.

If you’ve decided to take the plunge, here is how you can go about speeding up your website. Note that you’ll need to be able to have access to change the nameservers for your domains, as well as add and activate a WordPress plugin (optional).

Follow my guide below to add your website to CloudFlare. I’ll walk you through how I added my site on Sir Arthur Conan Doyle to CloudFlare.

Read More »How to speed up your site with CloudFlare

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.

Source table

If you haven’t had a chance yet, please go through the VLOOKUP tutorial. Alternatively, if you’re ready to jump right into INDEX/MATCH, then let’s get started.

Firstly, create the above table in Excel. I’ll be using Excel 2010 in my example. You can also download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet with the answers.

If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.

Read More »Excel Tutorial: INDEX MATCH primer

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.

Source table

Firstly, let’s create the above table in Excel. So whip up the installation of Excel you have. You can use either of Excel 2003, Excel 2007 or Excel 2010. I’ll be using Excel 2010 in my example. Download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet as well.

If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.

VLOOKUP is the easier function of the two to use and understand. It takes just 4 parameters and we’ll be using all 4. And, we’ll look at 4 options of using VLOOKUP.

Read More »Excel Tutorial: VLOOKUP primer

WordPress Picks for the week [11/15]

Managing Comments With Ajax Edit Comments A new version of the very popular plugin Ajax Edit Comments is out. In this guest blog post by Ronald, the founder of Ajax Edit Comments, tells you in pictures all the new features of the plugin. The power that AEC gives you is phenomenal.

Advanced Photo Editing with Tutorials by PhotoBie

At first I thought Photobie no more than a PhotoShop clone – however I was too quick to label it. While it may be similar in nature to PhotoShop (ie its a digital imaging software) that’s about as far as the similarities go! I thought I’d never say this about a software but this one actually has heart!