Excel 2007 brought a host of new functions to Excel that were missing in Excel 2003. One of these functions was AVERAGEIF which returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. One essential function that is still missing is MEDIANIF or MEDIAN IF which should ideally return the median of all the cells in a range that meet a given criteria.
Tips and Tutorials
The Google Play store has several paid and free browsers for Android phones and tablets. Most phones come inbuilt with a browser. But, you have several options to choose from.
Two days back I took the decision to move from All in One SEO to Yoast’s WordPress SEO plugin. WordPress SEO automatically adds several new columns to the posts admin screen. Coupled with the columns that Jetpack adds, along with those added by my Top 10 and Where did you go from here plugins, I ended up with the post title column being one character long!
Recently the folks at Secunia contacted me regarding a vulnerability in my plugin Contextual Related Posts. Contextual Related Posts is a powerful plugin for WordPress that allows you to display a list of related posts on your website and in your feed. The plugin comes with a tonne of options and inbuilt caching that can possibly increase user retention.
In today’s day and age where most of our information is online, including banking information and more importantly emails, it is essential to think about what happens to this data in case of an untimely passing. Similar to making a will to bequeath your belongings to your near and dear ones, planning your digital afterlife is essential. Yesterday, Google launched a new feature called Inactive Account Manager that helps you in this regard, at least in the case of all things Google.
If you’ve been running a multi-author blog like us, over a period of time, you’ll see your list of tags growing exponentially. When I reviewed the number of tags on Techtites today, I noticed that this was well over 1,100 tags! So, I went into the Tags interface and immediately realised that I’m going to spend an hour just deleting and cleaning up tags.
Payback period in capital budgeting refers to the period of time required for the return on an investment to “repay” the sum of the original investment. For example, a $1000 investment which returned $500 per year would have a two year payback period. The time value of money is not taken into account.
I love LinkedIn. At the time of this post, I am nearing 1,000 connections there. Unlike generic social networking sites like Facebook, LinkedIn has managed to maintain its niche of being a business connections site.
If you’ve wanted to prevent your site from appearing on Google Shopping or Google Advisor, you now have a chance to do so within Webmaster tools. Webmasters can now opt out of having content that Google has crawled from their site displayed on: Google Shopping Google+ Local Google Flights Google Hotels Google Advisor To do so simply visit the Opt-Out page and you will be presented with the following option. Simply click the big red button to exclude your site from showing up in the Google properties.
Many weeks back after much deliberation, I decided to give CloudFlare a shot. As they describe themselves… CloudFlare protects and accelerates any website online.