## Two Variable Data Tables in Microsoft Excel Tutorial

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.

## Data Tables in Excel tutorial

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.

## How to use Signal on your Desktop

If you’ve been following the press over the last week, you’d have noticed a large exodus of users from WhatsApp to Signal and Telegram. I am one of them and I’ve written about why I chose Signal as my primary messenger. Like me, if you’re familiar with WhatsApp web and have used it extensively, then…

## How to calculate NPV in Excel using Functions

In the last two posts, you learnt the basics of Net Present Value (NPV) and how to calculate NPV using formulae. However, Microsoft Excel makes it easy for you with two inbuilt functions. The first is NPV (surprise!) and the second is XNPV (my favourite). NPV From the official help article, NPV takes the following…

## How to calculate NPV in Excel using Formulae

I’ve covered the basics of Net Present Value (NPV) previously. If you don’t know what NPV is, then please read that post first before continuing. After reading this post, you will be able to learn how to use Excel to calculate NPV of cash flows. This tutorial will teach you how calculate the NPV using…

## Goal Seek in Microsoft Excel

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.

## 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.

## 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.

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.

## How to delete unused or less used post tags in WordPress

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 calculate Payback Period in Excel

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.

## 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.