Three weeks back I covered creating Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variable data table. This tutorial assumes that you have read the earlier one and are comfortable with creating a single variable data table.
Two Variable Data Tables in Microsoft Excel Tutorial Read Post »
In my last Excel Tutorial, I covered using SUMIFS and SUMPRODUCT. Data Tables is also an advanced topic in Microsoft Excel that falls under the category of What-If Analysis. What-If or Sensitivity Analysis is carried out to study the variation of the output to changes in the input variable.
If you’ve been following the press over the last week, you’d have noticed a large exodus of users from WhatsApp
In the last two posts, you learnt the basics of Net Present Value (NPV) and how to calculate NPV using
I’ve covered the basics of Net Present Value (NPV) previously. If you don’t know what NPV is, then please read
Continuing with our Excel Tutorials, in this article, I’ll take you through using Goal Seek in Microsoft Excel 2007. The function is same as that of earlier versions of Excel as well as Excel 2010. The screenshots below are taken in 2007.
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.
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.
How to prevent CSRF vulnerability in WordPress plugins and themes Read Post »
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.
5 Steps to setup your Google Inactive Account Manager Read Post »
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.
How to delete unused or less used post tags in WordPress Read Post »
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.
Many weeks back after much deliberation, I decided to give CloudFlare a shot. As they describe themselves… CloudFlare protects and accelerates any website online.
