Tips and Tutorials

How to use your own Domain with FeedBurner

One little known and even lesser used feature of Feedburner is called MyBrand. MyBrand lets you use your own domain name to host your feed instead of feedproxy.google.

Advertisements

FeedBlitz introduces Embedded Subscription Forms

Using FeedBlitz or any third party service requires your visitors to move away from your site when they are subscribing or using that service. Google’s Custom Search Engine as well as Adsense for Search ensured that visitors stayed on your site by embedding custom forms on pages of your site. Now, FeedBlitz has introduced Embedded Subscription Forms.

Ten must-use Windows Shortcuts (Windows Wednesday)

If you are using Windows, the number of shortcuts that Windows presents you is phenomenal. You even have the option to create your own shortcuts to launch applications. Here are ten shortcuts that can improve productivity: Windows Key + R Open the Run window Windows Key + F Open the search window Windows Key + E Open Windows Explorer Windows Key + 1, 2, …

It’s ok to search your own site with AdSense for search, but…

Many bloggers and site owners have Google Adsense for Search installed on their blogs. This ensures that you can provide relevant results to your blog users while simultaneously making some money on the side. While, there is no issue with other users using the search box, however, the question arises on the legality of you using the same.

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.

Consider a case of compound interest, where you invest a certain amount of money in a bank deposit and the amount is compounded every year.

Formula for calculating compound interest:

A = P * (1 + r/n) ^ nt

Where:

  • P = principal amount (initial investment)
  • r = annual interest rate (as a decimal)
  • n = number of times the interest is compounded per year
  • t = number of years
  • A = amount after time t

Now, if suppose we want to see what the final amount will be at different interests rates, we can quickly use a data table for the same.

Read More »Data Tables in Excel tutorial