Tips and Tutorials

CAGR in Excel - Dataset

3 ways to calculate CAGR in Microsoft Excel

You’ve come across the term CAGR and want to know how to calculate it in Excel? This post gives you three different ways to do so in Microsoft Excel. But, first, let’s understand what CAGR is.

Advertisements
Firefox - Mixed Content Blocking

How to stop Firefox from blocking Mixed Content

Firefox 23 added a new feature that automatically blocks mixed content. Mixed content comes into play when browsing secure websites. (i.e. websites with “https”), when the webpage doesn’t serve everything on the https protocol but serves some images on http.

Normally, this isn’t really the big issue. However, if you are concerned about security and especially tracking, then you might want to prevent this happening. Firefox understands that and automatically blocks mixed content. When browsing a secure website displaying mixed content, you might view something like this: “Firefox has blocked content that isn’t secure”.

Firefox - Mixed Content Blocking

As you note in the URL, browsing WordPress.org is likely to throw up this warning. This is because Firefox automatically blocks all active content like scripts that aren’t also served on the https protocol.

Hitting “Disable Protection on This Page” will fix it for the particular page. However, it won’t respect this on other sites. If you’re like me, this isn’t a helpful feature but rather a pain! And, you’ll want to disable this.

Here’s how you do it.

Read More »How to stop Firefox from blocking Mixed Content

MEDIAN IF example

MEDIAN IF tutorial in Excel 2007 and Excel 2010

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.

Screen Options - All Posts

Intro to Screen Options in WordPress Admin screens

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!

WordPress

How to prevent CSRF vulnerability in WordPress plugins and themes

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.

This vulnerability was on the settings page of the plugin and opened up the blog to a potential cross site request forgery (CSRF)

The application allows users to perform certain actions via HTTP requests without performing proper validity checks to verify the requests. This can be exploited to change plugin settings and e.g. insert malicious script to pages or posts when a logged-in administrator visits a specially crafted web page.

Since then, I’ve been scouring the web for material on this and you might also want to take a look this article on crunchify for a solution. In this post, I’ll tell you what I did to fix the vulnerability. But first, let’s understand what’s CSRF.

Read More »How to prevent CSRF vulnerability in WordPress plugins and themes

Inactive Account Manager

5 Steps to setup your Google Inactive Account Manager

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. You can now choose what happens with your data if your account goes inactive after a set period of time. You can choose to send it to a person(s) you nominate or delete your data.

Inactive Account Manager

Here’s how you go about using it.

Step 1: Login to Inactive Account Manager

Simply follow this link to Inactive Account Manager and login with your Google ID and Password. Hit the Setup link and you’re ready to begin the wizard.

Inactive Account Manager - Setup

Read More »5 Steps to setup your Google Inactive Account Manager