This is one very powerful and, in my opinion, less used feature of Microsoft Excel. Many of you are familiar with Paste Special, also popularly… Read More »This amazing Excel shortcut will save you hours!
Tips and Tutorials
In light of the bulk surveillance issues that have found their way across the web, the Free Software Foundation has launched a guide to help… Read More »Email Self-Defense – Secure your email in 30 minutes!
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.
Advertisement tracking is pretty much a given in today’s world. Major networks like Google and Microsoft are serving advertisements on thousands of websites and they attempt to serve you relevant ads based on your browsing experience. But, you can stop the tracking and serving of personalised ads.
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”.
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.
If you have configured your WordPress blog to display permalinks, WordPress will automatically generate a post slug using the title of your post. However, this post slug tends to be very long if you have a long title. Good SEO dictates that you keep your post slug as short as possible and you can do this by removing some stop words.
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.
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!