• Office,  Techtites Featured,  Tips and Tutorials

    What is NPV?

    If you’re here and reading this post, then you’ve probably been asked to calculate the Net Present Value of a set of cash flows in Excel. Over the next few posts, I’ll walk you through Net Present Value (or NPV) as a concept and then go into the details of how to calculate this in Excel. Introducing NPV, PV and FV Net Present Value, as the name suggests, is the sum of the present values of future cash flows. Both incoming (i.e. receipts) and outgoing (i.e. payments) are considered for calculating the NPV. So, what’s present value (PV)? Let’s try to understand this via a simple example. Imagine that you…

  • Excel,  Office

    2 Tips to become more efficient at Microsoft Excel

    As part of my day job, I’ve spent a lot of time working with Microsoft Excel and Microsoft PowerPoint. Not only with 2010, but also with Excel 2003 and Excel 2007. And with any task or software, the more you use it, the more efficient you get with it. Below are two key tips that I have learnt and practice all the time. Are you ready to take that step to become a Microsoft Excel Expert?! Tip 1: Throw away your mouse and embrace your keyboard One of the biggest things that slows down Excel users is the constant need to switch from their keyboard to their mouse, drag it to where they want to reach within the Excel window. This…

  • Articles,  Blogging

    This is why your Guest Post request was rejected

    Techtites has been open to guest posts on this blog for a long time now. When guest posting was at its peak, I made the mistake of accepting posts with content and links that are today frowned upon my Google. Since then I’ve cleaned up several posts and massively cut down on what I accept on this blog. However, even today, I receive several emails offering to write a guest post. It only takes a few seconds to realise that most of these emails are just the result of a copy-paste exercise that so-called guest writers employ blindly on contact forms of most popular blogs including this one. As a result, they find their way…

  • Techtites Featured,  Tips and Tutorials,  WordPress,  WordPress Plugins

    This is how you stop Trackback and Pingback spam in WordPress

    When blogging started to gather steam a decade ago, you had (and still have) three ways of receiving comments. The first still which still holds to today are traditional style commenting done by a person reading your article. Then came the bots and the comment spam which has today become a more manageable issue given several free and paid services available to a blog owner. However, even now, you will see tonnes of spam hits on very old posts, many of which don’t call for a comment! Two more methods of collecting comments was through trackbacks and pingbacks. Both trackbacks and pingbacks had a similar concept of notifying a linked…

  • Windows 10 - Start screen
    Microsoft,  Operating Systems,  Windows

    Free upgrade to Windows 10 for all users

    In a startling revelation, Terry Myerson, who runs Microsoft’s operating systems unit, announced that all users of Windows 7, Windows 8 and Windows 8.1 will get a free upgrade to Windows 10. This also includes everyone who are, either knowingly or unknowingly, running a non-genuine version of Windows! This seems to be Microsoft’s plan to battle pirates who have always managed to get the upper hand in this. The best way to stop piracy is to just give it away for free 🙂 “We are upgrading all qualified PCs, genuine and non-genuine, to Windows 10,” he said in a telephone interview with Reuters. The plan is to “re-engage” with the hundreds of millions…

  • Design and Development,  Google,  Techtites Featured,  Tips and Tutorials

    Export projects from Google Code to Github

    Over the years, Google has killed many services it offered including my favourite Google Reader. And, now it is time for Google Code to bite the dust. As a developer, I started actively using Github to manage my WordPress plugins. I like the interface GitHub provides and definitely the ability of git to control all the changes. It’s something that Google Code always had missing. However, if you’ve still not moved from Google Code, it’s time to move over your project to Github or Bitbucket. Thankfully, as always, Google has made it easier (and in fact automated) to move your project from Google Code to Github. You have time until 25 January…

  • Articles,  Computers & Internet

    What India spends its money on

    When it comes to spending money, Indian have found diverse ways of doing so, be it offline i.e. in retail stores or malls or online via Myntra, Flipkart or Amazon. has put together a second by second infographic that gives you an insight of what India spends its money on. Seems like we drink a lot of tea and unfortunately, smoke a tonne of cigarettes.

  • Techtites Featured

    #FashTech Technology meets Fashion

    Whether it’s your latest t-shirt by Polo Ralph Lauren, a smart watch by LG or other wearable tech, you’ll notice technology in every aspect of our lives, especially fashion. If you’re willing to shell out a few bucks, you’ll find something that might catch your fancy that you can proudly wear with style!